Pipelines_Bulk Upsert_Remove Records_Query

Question

I want to remove records where FID's 9, 10, &amp; 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------------------------------

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

adamkeever1 · Answer

Thanks Mark. I used {9.EX.''}AND{10.EX.''}AND{11.EX.''} and it worked. The syntax in jinja is slightly different.

------------------------------Adam Keever------------------------------

Forum Discussion

Pipelines_Bulk Upsert_Remove Records_Query