How to avoid custom column in search collection filter?

Question

How to avoid custom column in search collection filter? Column not found: 1054 Unknown column 'show_in_custom_assistance' in 'where clause',

  $collection = $this->_autoSearchCollection->create();
    $collection->setVisibility($this->_catalogProductVisibility->getVisibleInCatalogIds());
    $collection->addAttributeToSelect('*')
    ->setStoreToFilter($storeid)
    ->addStoreFilter($storeid)
    ->addSearchFilter($search_arr)
    ->addMinimalPrice()
    ->addUrlRewrite()
    ->addTaxPercents();
    $collection->addCategoryFilter($category);
    // echo $collection->getSelect();

    return $collection;

Answer 1

You can use below code to remove either field or any attribute from your custom collection.

To remove attribute :

$collection->removeAttributeToSelect('show_in_custom_assistance');

To remove field/table column :

$collection->removeFieldFromSelect('show_in_custom_assistance');

Hope this help to you.

Thanks,