I have a read-only grid with the following data (image below)Currently all my users can see all the dataIn my case, i want "User1" should be able to see just "Vendor1" in vendor_selected column, "User2" should be able to see just "Vendor2",....etc.How can I do that?
Discussion posts and replies are publicly visible
for this, you have to use filters while query the record.
how?
can you help me with the basic steps or expression example ?
Configure a source filter and make the value as an expression and in that you can provide the value based on your logic and field will be vendorName. For vedorName based on user name you can create a decision table for the user and vendor mapping and use that decision table to get the vendor name which you have to show to them. Also, by using the Security you can achieve.
You should use the record level security here. docs.appian.com/.../record-level-security.html
A New security rule needs to be created In order to achieve your case,
Here, I am explaining you with the sample record Type ZMS_KMR_Request
In place of requestedBy, you should use the Vendedor_Selected field
Hope you got the answer
I have this issue
Hi Mohan
For "User found in fields" I do not have a field where users are registered.
The column "Vendor Selected" field is text type and in come from a dropdown
Then you should create security expresion in record level security
You cannot put a queryFilter inside a queryFilter. You either need to switch to expression mode or just call your decision table in that field.
thanks it works now