Forum Discussion

DonStrickland's avatar
DonStrickland
Qrew Member
6 months ago
Solved

advanced query in a pipeline

Help! I have a pipeline that runs great as long as I don't put in an advanced query. If I put that in, no matter what field I reference or syntax I use, the pipeline bombs because of the advanced query. 

Her's the syntax I am using:

I am thinking this says Look in Field ID 12, and if that is greater than 0, select the record.

Again, it works fine with no value in there, but any value seems to break things. Thoughts?



------------------------------
Don Strickland
------------------------------
  • try just

    {12.GT.0}



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

2 Replies

  • try just

    {12.GT.0}



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • DonStrickland's avatar
      DonStrickland
      Qrew Member

      Well I'll be! That worked! Many many Thanks!



      ------------------------------
      Don Strickland
      ------------------------------