Magento 2 Filter Orders Based On shipping Country

Question

I want to Filter Orders based on Shipping country I have filtered using other attributes like grand_base_total and store_id but struck at shipping country as there is no any attribute for that in sales_order table

Answer 1

I have done this using one of the clues from M1 Question

protected $_orderCollectionFactory;

public function __construct(
    \Magento\Sales\Model\ResourceModel\Order\CollectionFactory $orderCollectionFactory
) {
    $this->_orderCollectionFactory = $orderCollectionFactory;
}
public function getOrderCollection()
{
      $collection = $this->_orderCollectionFactory->create()
            /* Joined with `sales_order_address` to get COuntry Id */
            ->join(
                'sales_order_address',
                'sales_order_address.parent_id=main_table.entity_id',
                'sales_order_address.country_id ')
            /* Added `country_id` Filter */
            ->addFieldToFilter('country_id', 
                array('IN' => 'US,UK')
            );
        return $collection;
}