Based on filtering in adf Pipeline Runs report

Question

In our Azure Data Factory, we operate a pipeline that runs multiple times daily, each with distinct parameters. While reviewing the Pipeline Runs report and filtering by time range, pipeline name, runs, and status is possible, we’re curious if there’s a way to filter pipeline runs based on the parameters passed to the pipeline.

Answer 1

@ClarissaJacquline

 Thanks For Reaching out MS Q&A

Natively you cannot filter pipeline runs by pipeline parameters, you can just list them as one of the columns in the report.

Meanwhile you can use Triggered By to filter pipeline runs based on Trigger Parameters.

By default some are not listed, you can edit columns to see them.

Add column or select:

Filter based on different parameters you have created. Have shown one as an example

 

reference: https://learn.microsoft.com/en-us/azure/data-factory/monitor-visually#:%7E:text=Parameters,name/value%20pairs

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

Hi ClarissaJacquline,

It is not possible to filter by parameter value.

Allowed filters (from ADF portal\REST API):

• PipelineName,
• Status,
• RunStart, RunEnd,
• SandboxId, RunGroupId,
• LatestOnly, TriggeredByName

You may raise a feature request here to include filter for params, as these requests are tracked and monitored by product teams on a regular basis.

https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c

Hope that helps.

Thanks.