Forum Discussion

DonLarson's avatar
DonLarson
Qrew Commander
4 years ago

Pipelines Advanced Query

The goal is to build an Advanced Query in a Pipeline that will compare two User Fields in the record.  I am looking for the Record Owner to match the User in FID 9.

The query that will not work is

  • {'4'.EX.'9'}
What the query says is Record Owner equals 9 not the value of the User in FID 9.  

Searching for the syntax to get this right has been fruitless.  Anyone know a solution?


------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Pipelines

10 Replies

Sort By
    • DonLarson's avatar
      DonLarson
      Qrew Commander
      4 years ago
      Jim,

      Love the new Avatar.  Mr Magoo was hysterical.

      I just added a vote!


      ------------------------------
      Don Larson
      Paasporter
      Westlake OH
      ------------------------------
      • JimHarrison's avatar
        JimHarrison
        Qrew Champion
        4 years ago
        @ Don, that's not Mr Maggo, it's Glum from Gullivers Travels - noted for being very pessimistic. I love being pessimistic.

        ------------------------------
        Jim Harrison
        transparency = knowledge + understanding : The Scrum Dudes
        ------------------------------
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    4 years ago
    You could try building an Expression in the standard Query section. I was able to do this to limit the run-time of a Pipeline to a little more than office hours:



    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • JakeRattner1's avatar
      JakeRattner1
      Qrew Cadet
      4 years ago
      Maybe try something like
      {'9'.EX.'Record Owner'}
      I have a pipeline using a query with similar syntax, but its looking at a different table.  Hope this helps.  I'm a little ignorant about queries so its a shot in te dark

      ------------------------------
      Jake R
      ------------------------------
      • JimHarrison's avatar
        JimHarrison
        Qrew Champion
        4 years ago
        I tried the following and none produced any results.
        {'fid'OBF'today'}
        'fid'OBF'today'
        'fid'OBF'today()'
        'fid'OBF'now()'
        'fid'OBF'now'
        'fid'OBF'04-30-2021'
        {'fid'OBF'04-30-2021'}

        ------------------------------
        Jim Harrison
        transparency = knowledge + understanding : The Scrum Dudes
        ------------------------------