Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

Pipeline perform action when record is NOT found

I have a pipeline that is triggered, searches through a table, and performs actions for each record that is found that matches.

However, if NO record is found in the search, I need to perform a different action. Is there a good way to do this?

------------------------------
Mike Tamoush
------------------------------
Pipelines
  • RogerDartnell's avatar
    RogerDartnell
    Qrew Trainee
    5 years ago
    Mike,

    I'm not sure if this is the best practice way of doing it but it works for me...  I add an IF statement in the pipeline after the Search step and set it to 'List of records' (from the search step above) 'is not empty'.  That way in the 'Then' branch I can add the steps I want it to undertake on each record from the search but if there a no records the pipeline continues to the next step.

    Hope this helps,
    Roger

    ------------------------------
    Roger Dartnell
    ------------------------------