magento colloction query
$object->getCollection()
->addStatusFilter(1)
->addPriorityFilter('ASC')
->addFieldToFilter('main_table.from_date', [['lteq' => $now], ['null' => true]])
->addFieldToFilter('main_table.to_date', [['gteq' => $now], ['null' => true]])
->addFieldToFilter('main_table.column', ['eq' => 87])
->addCustomerGroupFilter($customerGroup)
->addStoreFilter([$this->_storeManager->getStore()->getId()],false );