How to sort a collection in the ascendind order, but with the NULL-values at the tail instead of the head?

Ask your questions
,
1

I am try to sort my product collection.

At first it should be sorted by Ascending Order (1,2,3…) and then by other character like NULL …
$collection = $this->_productCollectionFactory->create();
$collection->setVisibility($this->_catalogProductVisibility->getVisibleInCatalogIds());
$collection->addStoreFilter()
->addMinimalPrice()
->addFinalPrice()
->addTaxPercents()
->setPageSize($limit)
->addAttributeToSelect(’*’)
->addAttributeToSort(‘featuredproduct_sort_order’, ‘ASC’) ;
$collection->addAttributeToFilter(‘is_saleable’, 1, ‘left’);
$collection->addAttributeToFilter(‘et_featured’, ‘1’);

But My code is displaying Null as first.

2

There are solutions for the raw MySQL query case:

They need to be adated to the Magento 2 API.