S123 Version: 3.24.21; iPadOS 18.7.1; iPad 9th gen;
This works for us:
survey_status = 'Assigned' OR survey_status = 'InProgress' OR survey_status = 'Paused'
But this throws an error:
( ( survey_status = 'Assigned' OR survey_status = 'InProgress' OR survey_status = 'Paused') AND ( assignee = '${username}' ) )
Also, this does:
assignee = '${username}'
Can anyone help me? I have both values in my feature layer to check, and they match.
Thanks in advance for the help.
Solved! Go to Solution.
Is survey status in the form a select_one, if so have you verified that capitalization is correct? Also ${username} shouldn't have quotes.
Another way you could try is
survey_status IN ('Assigned', 'InProgress', 'Paused') AND assignee = ${username}
Is survey status in the form a select_one, if so have you verified that capitalization is correct? Also ${username} shouldn't have quotes.
Another way you could try is
survey_status IN ('Assigned', 'InProgress', 'Paused') AND assignee = ${username}