Skip to main content
Solved

advanced query in a pipeline

  • December 5, 2023
  • 0 replies
  • 713 views

Forum|alt.badge.img+2

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
------------------------------

Best answer by MarkShnierYou

try just

{12.GT.0}



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

try just

{12.GT.0}



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