Discussions

Expand all | Collapse all

Pipeline Record Search Advanced Filter didn't find any records

  • 1.  Pipeline Record Search Advanced Filter didn't find any records

    Posted 7 days ago
    I've continued messing with these pipelines.

    I have a pipeline that does a Search Records prior to Update Record the record(s) found and clearing 3 checkboxes.

    This is the Advanced Query from the search.  The text was taken from the Run log.  When the pipeline runs, it says Found No Records of Record Type.  

    query:"{40.EX.'yesterday'}}AND({81.EX.'true'}OR{109.EX.'true'}OR{110.EX.'true'})"
    table:"bq2362msd"

    Field 40 is a Date Time field
    Fields 81, 109 and 110 are Checkbox fields

    The value of the date Date Time field in the records is yesterday, the 10th, at 10:00 am.  Does that not qualify as 'yesterday'?

    What am I missing with getting these records found and updated.  I want to find all the records from yesterday's event and the Update Record to reset the checkbox to false/off.

    ------------------------------
    Katherine Oakey
    ------------------------------


  • 2.  RE: Pipeline Record Search Advanced Filter didn't find any records

    Posted 7 days ago

    At your skill level (and mine!!), I would dumb this down. 


    Make a native checkbox formula field in QuickBase. Use that single field in your regular filter (not advanced query). 


    But if you want to learn the syntax others in this forum will have to wade in or you will need to research the help if it exists. Or the QuickBase Junkie may have courseware. 



    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------