Forum Discussion

Qrew Trainee

3 years ago

Limit the number of records returned in Pipeline using a field value

Does anyone know how to limit the number of records returned in a pipeline quickbase channel records search using the value in another field as the criteria? I know that we can hard set the limit usi...

MarkShnier__You

Qrew Champion

I have not tried this myself but did you try dragging a field from one of the fields on the right hand panel into the limit box?

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

Qrew Trainee

3 years ago

Hello Mark,

Yes, the limit field will only except 2 characters and if you try to enter anything besides a number it displays a warning and will not allow it.

------------------------------
Emma Finger
------------------------------

ShannonHenry1
Qrew Trainee
3 years ago
You need to use the Query section that appears below Limit. It'll be collapsed initally, but once you expand it you can select any of the fields you chose above as output and set criteria on them.

------------------------------
Shannon Henry
------------------------------
EvanMartinez
Qrew Elite
3 years ago
Hi Emma,

there is a couple of options available when setting up a Pipeline like this but they do take some steps beyond the drag and drop builder.

You can use the QB API and specify the top parameter. https://developer.quickbase.com/operation/runReportSo the query would be something like
https://api.quickbase.com/v1/reports/511/run?tableId=bck7gp3q2&top={{a.limit}}

Or as Shannon was mentioning you can use an advanced query to help with that, specifically _fidX in an advanced query

https://help.quickbase.com/api-guide/do_query.html#queryOperators
Using the value in another field as the matching value

------------------------------
Evan Martinez
------------------------------
- NateKurtz
  Qrew Trainee
  2 years ago
  I am attempting a similar thing here and running into a wall. For context, we are trying to use this pipeline to automate ticket creation. So when we want to ship x pieces of equipment we will put a number in a field in the main form. The pipeline would then run and do a search on our inventory, then create a ticket for the number of units we want to ship.
  
  Everything seems to be working but i can't reduce the number of results returned when searching the records. My "Search Records" step in the pipeline is returning all of our inventory (which I want) but then i can't reduce the number of results based on a field. Looking at the list of criteria i can use in the advanced query i am drawing a blank for what to use. Any suggestions? Did this solution end up working for your use case?
  
  ------------------------------
  Nate Kurtz
  ------------------------------
  - NateKurtz
    Qrew Trainee
    2 years ago
    I am currently trying this (evaluates to be TRUE) under the advanced query.
    <options>num-{{a.quantity_to_add}}</options>
    
    Not sure where I am going wrong here, everything runs now but it still just returns all of the results instead of limiting to the number in {{a.quantity_to_add}}
    
    ------------------------------
    Nate Kurtz
    ------------------------------