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.
I have this issue
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