
Hi All
I have a form where I am calling a custom lookup from to enter the item details.
I am getting an error "Column is not filterable" while clicking on the field for filter and sorting.
Can Someone help me to resolve this error and why this error occurs.
Actually i am expecting near the item id field.
Thanks in advance!
Ramakrishna Tanneeru
The issue is solved by myself.
Root cause: We have a datasource InventTable, and adding new datasource to the query which we are building in ExecuteQuery () method of InventTable.. like below
Query = new query();
InventTableQbds = query.adddatasource(tablenum(inventtable)); // this is causing the issue..
Solution:
If we need to change the Query of the existing datasource (inventTable in this case).
use the code like Query = InventTable_ds.Query()
qbdsInventTable = Query.dataSourceNo(1);
....
I am happy that I could resolve this simple issue :P Hope this would be useful to others.
Thanks,
Ramakrishna T.