Forum Discussion

DonLarson's avatar
DonLarson
Qrew Commander
2 years ago

Re: Pipeline code using 'or' and 'and'

Amy,

I am not a Jinja guru.  @Prashant Maheshwari  @Doug Henning are the kings of this.   However I think your expression has the wrong operator and the text value needs quotes.

a.account_number_family_1_birth_month_3_charac == 'May'



------------------------------
Don Larson
------------------------------

4 Replies

  • AmyGosz1's avatar
    AmyGosz1
    Qrew Trainee
    == is a comparison operator to compare two objects so I don't thnk it would be used in this case.

    ------------------------------
    Amy Gosz
    ------------------------------
    • DonLarson's avatar
      DonLarson
      Qrew Commander
      Amy,

      I looked at this again and may have a non Jinja solution for you.

      FID 111 is a Date
      FID 112 is a Date
      FID 113 is a Text 


      # Character Date Search
      #

      # Account slugs:
      # - quickbase[XXXX]: Pipeline Token <None>
      ---
      - META:
      name: Character Date Search
      - QUERY quickbase[XXXXX] record search -> a:
      inputs-meta:
      export_fields: '"Touch, OneCharacter, TwoCharacter" <113, 111, 112>'
      query: ({111.EX.'May'}OR{112.EX.'May'})AND{113.EX.''}
      table: '"Parents: Parent" <bp4igy3re>'
      - a<>LOOP:
      - DO:
      - a<>ACTION quickbase record update -> b:
      inputs:
      touch: May
      ...



      ------------------------------
      Don Larson
      ------------------------------
      • AmyGosz1's avatar
        AmyGosz1
        Qrew Trainee
        All fields are text fields, the '3 charac' field is capturing the 3 letter abbreviation used for months. I am not querying or using date fields for this.

        ------------------------------
        Amy Gosz
        ------------------------------