Pipeline Record Search Advanced Filter didn't find any records

Question

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 fieldFields 81, 109 and 110 are Checkbox fieldsThe 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------------------------------

MarkShnierYou · Answer

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

Sign up

Login to the community