Forum Discussion

RyanPeart's avatar
RyanPeart
Qrew Trainee
4 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
  • QuickBaseJunkie's avatar
    QuickBaseJunkie
    4 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
    ------------------------------
QuickBaseJunkie's avatar
QuickBaseJunkie
Icon for Qrew Legend rankQrew Legend
4 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
------------------------------
  • RyanPeart's avatar
    RyanPeart
    Qrew Trainee
    4 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
    ------------------------------
    • QuickBaseJunkie's avatar
      QuickBaseJunkie
      Icon for Qrew Legend rankQrew Legend
      4 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
        4 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
        ------------------------------