Reference Qualifier - OR condition

[Mark Van Loock]

Hi,

I have a form with a list collector question pulling all users from the sys_user table.

I want to filter the list with two reference qualifiers. They work individually, but I can't find a way to combine them with an OR operator.

The following gives me incorrect results -

javascript:"u_in_active_directory=true || company.name="insurance company"'

Any help in determining what I'm doing wrong would be gratefully received.

Many thanks,

Mark.

[Upender Kumar]

Try applying filter in the list view and copy the condition and paste here.

[Upender Kumar · Accepted solution]

javascript:'u_in_active_directory=trueORcompany.name=insurance company'

[ABHAY_M]

Hello,

navigate to list view of user table apply the filters as per you need and paste the encoded query on advanced reference qualifier.

[Mark Van Loock]

Ah! So by viewing the users and applying a filter in the GUI, you can then copy the query by right clicking on the blue condition. I did that and got -

u_in_active_directory=true^ORcompany.name=insurance company

That's doing what I want now.

Fab.

Thank you!