External Lookup Syntax For 'Or'

[cantcacheme]

I'm one of the new (still learning) system admins for our Workfront instance.  We are trying to create an external lookup field that will find all of our projects that are in the "In-Progress" (CUR) or "Planning" (PLN) status.  I am having a hard time determining if Workfront supports syntax for "OR" not to mention what it would be.  We have tried using ||, however that didn't seem to produce the results we wanted.

This is what we have so far:

$$HOST/attask/api/v19.0/projects/search?status=PLN||status=CUR

We have also tried:

 $$HOST/attask/api/v19.0/projects/search?status=PLN,CUR

  $$HOST/attask/api/v19.0/projects/search?status=PLN&status=CUR

plus some other variations.

Any advice would be appreciated.

[Sven-iX · Accepted solution]

Read up on the text-mode 

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/text-mode/create-or-sta...

Per support you can also pass a "filters" argument:

filters={"status_Mod":"ciin","status":["PLN","CUR"]} - this is the only instance where I can get "in" and "notin"  to work.

[cantcacheme]

Thanks for the quick response @Sven-iX.  My co-worker and I actually found that link you provided a few minutes before you sent it over.

We just got it to work.  Here is the final syntax that we ended up with.

$$HOST/attask/api/v19.0/project/search?status=CUR&status_Mod=in&OR:1:status=PLN&OR:1:status_Mod=in

Thank you for the quick response and for your patience.  As I am still learning, I didn't realize that text mode syntax also works for external lookups, so this has been a good learning exercise.

Thanks again!

[Sven-iX]

Perfect - love it!