Discussions

 View Only
  • 1.  Pipelines_Bulk Upsert_Remove Records_Query

    Posted 03-17-2023 14:24
    Edited by Adam Keever 03-17-2023 14:33

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



  • 2.  RE: Pipelines_Bulk Upsert_Remove Records_Query

    Posted 03-17-2023 14:42

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



  • 3.  RE: Pipelines_Bulk Upsert_Remove Records_Query

    Posted 03-17-2023 15:05

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



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