Skip to main content
Question

Pipeline Advanced Query multiple conditions

  • April 5, 2023
  • 0 replies
  • 804 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
------------------------------

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • April 5, 2023

    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Forum|alt.badge.img+5
    • SuryaAvantsa
    • Quickbase Alumni
    • October 13, 2024

    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+15
    • DonLarson
    • Quickbase Alumni
    • October 13, 2024

    Anne,

    Try this

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

    Terms & ConditionsAccessibility statement