Forum Discussion

RyanPeart's avatar
RyanPeart
Qrew Trainee
3 years ago
Solved

Pipelines - Get Length of List of Pipeline Rows

Hello, I am trying to schedule a weekly calculation every Friday using Pipelines. The calculation process is as follows: Select the 20 most recent records from a QuickBase App table, sorted ...
Pipelines
  • Quick_BaseJunki's avatar
    Quick_BaseJunki
    3 years ago
    I think the Jinja you're looking for is {{ (d | count)/20 }}.

    This would return the count of records found in step D then divide by 20.

    If you're interested in learning more about Jinja I suggest checking out my blog post "What is Jinja" and my course "Intro to Jinja for Pipelines"

    ------------------------------
    Sharon Faust (QuickBaseJunkie.com)
    Founder, Quick Base Junkie
    https://quickbasejunkie.com
    ------------------------------
Quick_BaseJunki's avatar
Quick_BaseJunki
Qrew Captain
I think the Jinja you're looking for is {{ (d | count)/20 }}.

This would return the count of records found in step D then divide by 20.

If you're interested in learning more about Jinja I suggest checking out my blog post "What is Jinja" and my course "Intro to Jinja for Pipelines"

------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
RyanPeart's avatar
RyanPeart
Qrew Trainee
3 years ago
Hi Sharon! Thanks for getting back to me.

I tried using {{ (d | count) / 20 }} and the Pipeline can successfully run now. But I don't think (d | count) returns the count of records from step D. When I test run the Pipeline, step D does return a number of rows, but the final records get updated with the value 0.

Is there a different syntax I can use with Jinja?

------------------------------
Ryan Peart
Database Analyst
Minerva Knowledge Management
WA
------------------------------
  • Quick_BaseJunki's avatar
    Quick_BaseJunki
    Qrew Captain
    3 years ago
    It may be that you need to use step E (or another step). In that case it would be {{ (e | count) / 20 }}.

    ... it's a little hard to tell from the image.

    Basically, {{ e | count }} will give you the number of records returned in a search (assuming your search step is E), but I'm not sure what step your search is in.

    ------------------------------
    Sharon Faust (QuickBaseJunkie.com)
    Founder, Quick Base Junkie
    https://quickbasejunkie.com
    ------------------------------
    • RyanPeart's avatar
      RyanPeart
      Qrew Trainee
      3 years ago
      I do want to get the resulting records from step D. However, step D is using the 'Search Pipeline Rows' function from the Bucket channel. Could that be the reason why {{ (d | count) / 20}} isn't working? Does Jinja only work for the 'Search Records' function in the QuickBase channel? 

      I created a bucket because I am performing a query upon a query. I need to get the latest 20 records, and then search within those records for the records that match a certain criteria. Would it be easier if I tried to put all the filter criteria into the initial Search Records step (Step 1 from my initial post)?

      ------------------------------
      Ryan Peart
      Database Analyst
      Minerva Knowledge Management
      WA
      ------------------------------
      • Quick_BaseJunki's avatar
        Quick_BaseJunki
        Qrew Captain
        3 years ago
        I'm not 100% sure about the "Search Pipeline Rows" function and that the 'count' Jinja.

        However, I'm not certain the approach your taking is right for what you want to accomplish either.

        For your initial sorted search limited to 20 items (step 1), it would be ideal to use the JSON channel with the query API here: https://developer.quickbase.com/operation/runQuery
        After iterating on that data, run a webhook including your criteria to filter out the unneeded records (step 4) and then update (step 6) those records as necessary using this API: https://developer.quickbase.com/operation/upsert

        (I'm unclear how step 5 fits in) 

        This is a much more advanced use of Pipelines as it involves quite a bit of JSON & Jinja. Too much to explain here on the forum I'm afraid.

        Hopefully, this information will point you in the right direction.

        ------------------------------
        Sharon Faust (QuickBaseJunkie.com)
        Founder, Quick Base Junkie
        https://quickbasejunkie.com
        ------------------------------