External Lookup Syntax For 'Or' | Community
Skip to main content
C
cantcacheme
March 13, 2025
Solved

External Lookup Syntax For 'Or'

  • March 13, 2025
  • 1 reply
  • 535 views

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.

Best answer by Sven-iX

Read up on the text-mode 

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

 

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.

 

1 reply

Sven-iX
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
March 13, 2025

Read up on the text-mode 

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

 

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.

 

C
cantcachemeAuthor
March 13, 2025

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
    Community Advisor
    Sven-iXCommunity Advisor
    Community Advisor
    March 14, 2025

    Perfect - love it! 

    Terms & ConditionsAccessibility statement

    Loading footer...