Pipelines - obtain count of records processed in a Search step

Question

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.

------------------------------
George Romanowski
------------------------------

sherriedrummond · Answer

My solution was to add a counter field to my table and update by adding 1 every time it loops. Then at the end of the pipeline, I create/update my records with my counter.

I would love to know if there is a better solution to this as well.

------------------------------
Sherrie Drummond
------------------------------

matthardy · Answer

You could possibly create a formula query with the same search parameters as your pipeline search.
Or to expand on Sherrie's idea, you could create a bucket in your pipeline to store the count rather than updating an existing record. This bucket is temporary and will be removed when the pipeline ends.

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

matthardy · Answer

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

georgeromanowsk · Answer

Thanks,&nbsp; {{a|count}}&nbsp; works.&nbsp; Just what I was looking for.------------------------------George Romanowski------------------------------

paulpeterson1 · Answer

This is exactly what I need also, how would I use this as an expression to see if the count is equal to zero (ie, this is the first iteration)

------------------------------
Paul Peterson
------------------------------

Forum Discussion

Pipelines - obtain count of records processed in a Search step