Hi,
Thank you very much for answering,
I am going to try to give more details about what I am trying to do, the testing I've performed and my interrogations.
- The goal is to filter 2 tables (PurchTable, PurchReqLine) on fields that they don't have (Site) using policies via table relations (with InventDim and InventSite) and constrained tables WITHOUT FILTERING InventDim and InventSite.
- The set up is done as described below :
- Query on InventDimSiteID_Site1 (then Site2 and so on)
- Primary Table = InventDim
- Policy InventDimSiteID_Site1
ConstrainedTable = Yes
Table = PurchReqLine
Table Relation = InventDim
- Query on InventSiteSiteID_Site1 (then Site2 and so on)
- Primary Table = InventSite
- Policy InventDimSiteID_Site1
ConstrainedTable = Yes
Table = PurchTable
Table Relation = InventSite
- To apply these 2 Policies on the Role I created the contextstring :
- PurchReqLineAndPurchTableFilter
Now when I apply these Policies using :
- ContextType = RoleProperty then the contextstring above
-> THE FILTER APPLY ALSO TO PRIMARY TABLES
- ContextType = Contextstring then the contextstring above
-> THE FILTER DOES NOT WORK
Thank you for reading and for your answer (I am also interested in any document that provides information about ContextType = ContextString
Best Regards,