Forum Discussion

GeorgeRomanows1's avatar
GeorgeRomanows1
Qrew Member
4 years ago

Pipelines - obtain count of records processed in a Search step

How do you get a count of the records processed by a 'search' step within a pipeline. I would like to add this count to a 'create record' step at the end of the pipeline. ---------------------...
Pipelines
MattHardy's avatar
MattHardy
Qrew Trainee
4 years ago
While working on something I came across a possible solution. {{a|count}} should return the number of records found in your search

------------------------------
Matt Hardy
------------------------------
DonLarson's avatar
DonLarson
Qrew Elite
4 years ago
In the syntax

 {{a|count}} 
​

The "a" is the search step?  ​

------------------------------
Don Larson
------------------------------
  • PaulPeterson1's avatar
    PaulPeterson1
    Qrew Assistant Captain
    4 years ago
    I understand that part, what I would like to do is add a condition to check if the count is equal to zero.

    ------------------------------
    Paul Peterson
    ------------------------------
    • MattHardy's avatar
      MattHardy
      Qrew Trainee
      4 years ago
      Try adding an IF with an advanced expression. I haven't tested this, but I suspect {{a|count}} = 0 would work

      ------------------------------
      Matt Hardy
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        @Paul Peterson  You can check for zero natively.

        Just delete the For Each after the search and insert condition.  Then there is a drop down to check if the Step A (the search step) was empty or not.
        ​

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