Pipelines_Bulk Upsert_Remove Records_Query

Question

I want to remove records where FID's 9, 10, & 11 are blank. I am using query {9.LT.1}AND{10.LT.1}AND{11.LT.1}, but it isn't working. Any ideas?

Here is an example from the activity log:

I have the pipeline set-up right because I tested it by deleting all records in a table using query {3.GT.0}.
------------------------------Adam Keever------------------------------

MarkShnierYou · Answer

Not tested but when I cheat and look at the expanded URL for a report looking for blank it gives me this

{'33'.EX.''}

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

Sign up

Login to the community