Record page filter for a multi-value User Selector field

I have a record page filter where the intent is only to list those records where the current user is included in the record field “users”, using the filter query users = ${userID}

This works fine when the current user is the first value in the multi-value field, but it does not work if they are not the first user. I also tried ${userID} IN users, but that does not return any records.

Is there another query syntax to overcome this, before I investigate a contextual role approach?

Solved.

I got it to work by using the IN query below, with the single quotes around the ID

'${userID}' IN users

1 Like