0

Implement 'OR' function in prompts or filters

Hi,

How do we implement 'OR' function in the prompt or filter section?

Example

HTS Number 1 begins with <prompt>

Or HTS Number 2 begins with <prompt>

Or HTS Number 3 begins with <prompt>

Or HTS Number 4 begins with <prompt>

 

Thanks,

Swapna

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Swapna Chennam , you can check Incorta's formulas out in more detail here:

    https://docs.incorta.com/4.4/formula-functions/

    Details around the "OR" function are in the Boolean section.  E.g.

    OR(startsWith(myschema.mytable.HTSNum1, "stringValue1"), startsWith(myschema.mytable.HTSNum2, "stringValue2"), startsWith(myschema.mytable.HTSNum3, "stringValue3"))

    Both functions used above, return "true" or "false".  Thus, if you're using it as a filter, set your operand to True.

    Reply Like
Like Follow
  • 1 mth agoLast active
  • 1Replies
  • 21Views
  • 2 Following