Hi Team,
I have a column(Assignees) in a record type, there in the filter I'm thinking to write a logic like below
a!queryFilter( field: 'recordType!Record Details.fields.assignees', operator: "=", value: loggedInUser() ),
id, Assignee(text)
-----------------------
1, "user1;user2"
2, "user2"
if the user1 login, record 1 should be displayed in the grid
if the user2 login, record 1,2 should be displayed in the grid
Discussion posts and replies are publicly visible
Merging a list of values into a single string and storing that in a field is not a valid approach to achieve your goal.
Have a look at this article to get a basic idea of the principle. In your case you will not use record security rules, but just a filter when querying your data.
community.appian.com/.../record-level-security-for-entity-backed-records
Can we disable related action?
docs.appian.com/.../record-actions.html