Magento 2 + custom eav field value store in array

Question

I have a custom eav structure and there is store_id save in array format in the database field.

I need to filer collection with addFieldToFilter with store_id.

$collection = $this->xyzCollectionFactory->create();
$collection->addFieldToFilter('store_id', ['in' => $this->storeManager->getStore()->getId()]);

Datastore in the database below format

["1","2","8","3","4","5"]

this filter is not working, anyone has an idea how can I do that?

Answer 1

Reference Link :- https://fishpig.co.uk/magento/tutorials/addattributetofilter/

Try This :

$storeId[] = $this->storeManager->getStore()->getId();
addAttributeToFilter('store_id', array('in' => array($storeId)));

Answer 2

First of all, check that store_id field create in your custom table or not. If yes, then make sure that you extend Magento\Eav\Model\Entity\Collection\AbstractCollection class in your collection file.

For more reference : click here

Answer 3

Try this code regarding my friend RK

     $storeIds = array();
     $storeIds[] = 1; //store id
     $collection = $this->xyzCollectionFactory->create();
     $collection->addFieldToFilter('store_id', ['in' => (array)$storeIds]);

     Or

     $storeId = 1;
     $collection->getSelect()->where('main_table.store_id in (?)', [0, $storeId]);