Forum Discussion

EmmaFinger1's avatar
EmmaFinger1
Qrew Trainee
4 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...
Pipelines
EvanMartinez's avatar
EvanMartinez
Moderator
4 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's avatar
NateKurtz
Qrew Trainee
3 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's avatar
    NateKurtz
    Qrew Trainee
    3 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
    ------------------------------