Magento 2.1 - Get a collection including out of stock products

Question

In a basic block I'm getting the featured products, however I only get the products that are in stock:

public function getProducts()
{
    $collection = $this->_productCollectionFactory->create();
    $collection->addAttributeToSelect('*')
        ->addAttributeToFilter('featured', '1');

    $collection->getSelect()
        ->limit(8);

    return $collection;
}

How can I get the out of stock products (I guess those which stock_status=0 in cataloginventory_stock_status) as well? without changing "anything" in the backend configuration.

Answer 1

Yes,you can be get out of product in your collection whenever Stock options -> Display Out of Stock Products = no

Add below code to $collection.

    $cond = [
        '{{table}}.use_config_manage_stock = 0 AND {{table}}.manage_stock=1 AND {{table}}.is_in_stock=1',
        '{{table}}.use_config_manage_stock = 0 AND {{table}}.manage_stock=0'
    ];

        $cond[] = '{{table}}.use_config_manage_stock = 1';

    $collection->joinField(
        'inventory_in_stock',
        'cataloginventory_stock_item',
        'is_in_stock',
        'product_id=entity_id',
        '(' . join(') OR (', $cond) . ')'
    );