Forum Discussion

GeorgeRomanows1

Qrew Member

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

Qrew Trainee

While working on something I came across a possible solution. {{a|count}} should return the number of records found in your search

------------------------------
Matt Hardy
------------------------------

Qrew Elite

3 years ago

In the syntax

{{a|count}}

The "a" is the search step?

------------------------------
Don Larson
------------------------------

PaulPeterson1
Qrew Assistant Captain
3 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
  Qrew Trainee
  3 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
    Qrew Legend
    3 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
    ------------------------------