Skip to main content
Question

Pipeline Advanced Query multiple conditions

  • Apr 5, 2023 12:47 PM UTC
  • 0 replies
  • 861 views

I have a pipeline I'd like to trigger based on conditions from multiple fields.
These conditions work separately but I'm not able to get them to work together.
I used the syntax provided on this page: Quickbase Help

I need to use a query instead of the built in conditions because the first condition requires 2 date fields to match each other.

{35.ex.'_fid_7'}AND{36.ex.'true'}



------------------------------
Anne Martin
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

If you don't want to do the query Syntax you can make a helper field in native Quickbase and just filter on that being true.  But it's also possible that you are trying to learn the "proper" syntax.



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

Forum|alt.badge.img+5

I know we can use $prev for setting field values but can I access the previous value in the jinja format of the filter above? Something like {$prev.35.ex.'SUBMITTED'}AND{35.ex.'REJECTED'}


Forum|alt.badge.img+19
  • Qrew Champion
  • Oct 13, 2024 10:59 PM UTC

Anne,

Try this

{35.EX.'_fid_7'}AND{36.EX.'true'}