Hi everyone,
I've published a page that is consumed from an external application. The source table of this page, is "Item".
I need to aplly one filter, not to send al the items to the external aplication. The filters logic is this:
IF "Item Category Code" = 'XXX' THEN
SETFILTER("Product Group Code",'<>%1&<>%2&<>%3','00','100','99');
I don't want to send items from category XXX and with the indicated product group code. Where and how can I locate that filter?
Thank you all, and merry christmas!!
Answers
You can use the "SourceTableTemporary" of the page. Set this property to TRUE and then populate the temporary table with the lines you need, by looping through your records and applying the above logic.
Regards