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

Question

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 using the limit field in the step, but I need the ability for it to depend on the value in a field.

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

shannonhenry1 · Answer

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

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&nbsp;top&nbsp;parameter.&nbsp;https://developer.quickbase.com/operation/runReportSo the query would be something like
https://api.quickbase.com/v1/reports/511/run?tableId=bck7gp3q2&amp;top={{a.limit}}Or as Shannon was mentioning you can use an advanced query to help with that, specifically _fidX in an advanced queryhttps://help.quickbase.com/api-guide/do_query.html#queryOperatorsUsing the value in another field as the matching value------------------------------Evan Martinez------------------------------

markshnier__you · Answer

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

emmafinger1 · Answer

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

natekurtz · Answer

I am attempting a similar thing here and running into a wall.&nbsp; For context, we are trying to use this pipeline to automate ticket creation.&nbsp; So when we want to ship x pieces of equipment we will put a number in a field in the main form.&nbsp; 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.&nbsp;&nbsp;Everything seems to be working but i can't reduce the number of results returned when searching the records.&nbsp; 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.&nbsp; Looking at the list of criteria i can use in the advanced query i am drawing a blank for what to use.&nbsp; &nbsp;Any suggestions?&nbsp; Did this solution end up working for your use case?------------------------------Nate Kurtz------------------------------

Forum Discussion

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