Anyone have any success with adding a filter for a EmbBasic ComboBox?
It would be nice to use EmpBasic BO vs creating a BAQ.
Trying to add a filter Payroll = true and EmpStatus = ‘A’
Nothing seems to work and am getting the following error.
Ice.Common.EpicorServerException: Invalid column name 'Payroll'.
Invalid column name 'Payroll'.
Invalid column name 'Payroll'.
Invalid column name 'Payroll'.
Invalid column name 'Payroll'.
Invalid column name 'Payroll'.
Invalid column name 'Payroll'.
Invalid column name 'Payroll'.
---> System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Payroll'.
Go look at @hmwillett control compendium post. You should be able to get to it through her tag. She has very good examples of the syntax for using the reusable combo.
That worked. Thanks a bunch! Looks like the issue Ken and I were having is that we were defining “GetRows” in the Service Method field and leaving Data Mode set to blank.
Eh, I think the bigger issue is it’s not letting us define the filter to a specific whereClause. It was doing the EmpStatus filter on all of the returned tables from GetRows, but EmpStatus didn’t exist in the others.
It’s a lot of trial and error.
Do you also have an example of a combo box with a whereclause filter like ?{Constant.CurrentPlant} of something like that?
I tried to create a combo box for warehouses where hidden column Plant = ?{Constant.CurrentPlant}. Unfortunately the ?{…} is always interpretated like a string, not like a reference to the existing parameter. Tried with single brackets, % and double, but probably doing something wrong.
