Forum Discussion

John_Perkins's avatar
John_Perkins
Qrew Cadet
2 months ago

Pipeline Search Searches EVERY Record in Table Unless Created Date Filter

Curious if there's a better way to do this. Here's an example. I have a table with tens of thousands of records, and each record has a "Date of Work" field that is pulled from a related record. If I want to search for records with that specific "Date of Work", it searches the entire table. Like it pulls in every record and then tries to filter instead of doing a search based on the filter.

So, I search for a date where there should be 400 records, I get a message that it found 400 records hundreds of times. If I change it to also search for a Created Date after a certain date to limit the search even more, it only searches the batch after the created date. So in this case I get that message 40 times instead of 100s of times. This seems incredibly inefficient and makes the pipeline take way longer than it needs to. 

Is there any way to force the search to run against the table and just pull in the results, not a huge batch and then filter from there? I suppose I could manually set up a GET request that uses the API, but why does the built-in search work so inefficiently? I suppose it puts more of the burden on the Pipeline than the app, but that's insane when you're looking for a handful of records in a table with tens of thousands of items. 

Here's an example of what I'm seeing. Just a bunch of "Found 406 Records of Record type" along with the filter.

2 Replies

  • Maybe you'll need a support ticket. I have never seen that behaviour. Whenever I have searches, it only counts up to the number of records it finds, typically by hundreds. So it might say like 

    found 100

    found 200

    found 300

    found 400

    found 406

    then it stops finding.

    I have never seen behaviour where it repeats the number it found. 

     

     

  • Happens to me all the time. I also get the batches of 100 that count up, but it just keeps going unless I set specific created/modified date criteria. Sometimes I can do that, and sometimes I can't.

    I also saw that JimHarrison had a very similar issue about 3 years ago that had no replies: Running pipeline output seems execessive | Qrew Discussions. But Pipelines were a little different back then.