You’re offline. This is a read only version of the page.
75
Hello guys,
I am trying to create some queries that will restrict records in All purchase orders form, I want to see only PO that belongs to the project with Project ID starting with AB* and that have PO status as Open order. I have created new Query, with the datasource ProjTable, on this data source I have created a new range, AB*. Then in this datasource I have added another one, PurchTable, and on this datasource, I have created new range for Purchase order status field set as Open order.
Than I have assigned this query
to the security policy,
where is the Context Type set as RoleName and the role name is set in the properties as well. The role is then assigned to the user that should be restricted.
The restriction works fine for the Project ID, the user can see only projects starting with AB, but can see PO with all of the PO status, the range in the query does not affect the PO status. Does someone know, please, why is this happening? I have tried to clear usage data for example, but still the same issue
When I have created the query/policy in this way before, it worked fine, but now I have this issue.
Hi Sayid,
In this policy, the ProjTable is the primary table and determines which records are visible. The additional constrained tables will not inherit ranges from the security query. If you need to have the additional filter for the POs, you will need a second security policy starting with the PurchTable.
Share
Report
All responses (
Answers (
