Query of Tile should add a range based on the current company, but how

(0) Share

Report

Posted on by Willem van Duren

230

Good evening everyone!

I have a Tile control which uses a query. It works fine. However: when I am in the supply chain company (DatareaId = SCNL), I would like to remove the range on dataarea. So it is like a conditinal range:

if ( curExt() != "SCNL") --> Add Range to only show the current dataAreaID records

Is this possible? And if yes, what would be the way to do that? The tile control now uses a [Display Menu Item] which uses a [Simple Query] from AOT

To make it work I put the filter now on the init of the datasource of the form that is opened with the tile. That works, however: the counter of the tile gives the wrong number becuase it uses a different query (it does not have the same "conditional range" on dataareaid).

I have the same question (0)