Skip to main content
Inspiring
Aug 30, 2023 5:39 PM UTC
Question

Filter Data

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

    13 replies

    stefanhelzle0001
    Brainy
    Aug 30, 2023 5:41 PM UTC

    Storing multiple values in one field will not work. What are you trying to achieve?

    Inspiring
    Aug 30, 2023 5:43 PM UTC

    I would like to display all the records that assginee column has loggedin user as value

    anmolv0003
    Participating Frequently
    Aug 30, 2023 5:56 PM UTC

    If you are facing an error , please be specific about it. 

    Anmol