Hi there,
I want to apply Plant filter on PartWhseSearchSvc. Even though the column for Plant is available in results, when I put filter Plant eq 'something' .
It gives error: Invalid column name 'Plant'.
Can anyone please help with this?
Thanks
Filter is translated to the underlying WhereClause for GetRows method. It works only with database fields.
Probably in your case Plant is not database field and filled manually from the code? in that case you cannot use it in filter.
The site identifier field for the part warehouse(PartWhse) table is ‘KBPlant’.
Using this field in the filter for a REST call worked in my testing.
Sample request url: https://epicor102100/erp10train/api/v1/Erp.BO.PartWhseFullSearchSvc/PartWhseFullSearches?$filter=KBPlant%20eq%20’MfgSys’
Kanban Warehouse is blank for all parts. So we can’t filter it on that field.
Have you tried using WarehouseCode and KBPlant?
Seems like Plant is an external field assigned after the search looking at the warehouse plant and some other validations, so like Olga said you can’t filter directly on Plant.