Azure / Azure/azure-cli-extensions

How to use multiple --filters for datafactory pipeline-run query-by-factory

Open
#6,959 5 comments 4 reactions 1 assignee Claimed by @Jingshu918 View on GitHub
customer-reported Data Factory question Service Attention
Dominant language
Python
Stars
454
Forks
1.7k
Avg merge
2d 19h
Merged PRs (30d)
64

Description

### Describe the bug

[Documentation ](https://learn.microsoft.com/en-us/cli/azure/datafactory/pipeline-run?view=azure-cli-latest#az-datafactory-pipeline-run-query-by-factory-optional-parameters) mentions that `--filters` can be used multiple times but does not describe how.

### Related command

az datafactory pipeline-run query-by-factory

### Errors

None of these commands work.

```pwsh
az datafactory pipeline-run query-by-factory `
--factory-name $DataFactoryName `
--resource-group $ResourceGroupName `
--filters operand="Status" operator="Equals" values="InProgress" `
--filters operand="Status" operator="Equals" values="Queued" `
--last-updated-after ((Get-Date).AddDays(-1) | Get-Date -Format "o" -AsUTC) `
--last-updated-before (Get-Date -Format "o" -AsUTC)

az datafactory pipeline-run query-by-factory `
--factory-name $DataFactoryName `
--resource-group $ResourceGroupName `
--filters operand="Status" operator="Equals" values="InProgress" operand="Status" operator="Equals" values="Queued" `
--last-updated-after ((Get-Date).AddDays(-1) | Get-Date -Format "o" -AsUTC) `
--last-updated-before (Get-Date -Format "o" -AsUTC)

az datafactory pipeline-run query-by-factory `
--factory-name $DataFactoryName `
--resource-group $ResourceGroupName `
--filters operand="Status" operator="Equals" values="InProgress" values="Queued" `
--last-updated-after ((Get-Date).AddDays(-1) | Get-Date -Format "o" -AsUTC) `
--last-updated-before (Get-Date -Format "o" -AsUTC)

az datafactory pipeline-run query-by-factory `
--factory-name $DataFactoryName `
--resource-group $ResourceGroupName `
--filters operand="Status" operator="Equals" values="InProgress,Queued" `
--last-updated-after ((Get-Date).AddDays(-1) | Get-Date -Format "o" -AsUTC) `
--last-updated-before (Get-Date -Format "o" -AsUTC)

az datafactory pipeline-run query-by-factory `
--factory-name $DataFactoryName `
--resource-group $ResourceGroupName `
--filters operand="Status" operator="Equals" values="InProgress Queued" `
--last-updated-after ((Get-Date).AddDays(-1) | Get-Date -Format "o" -AsUTC) `
--last-updated-before (Get-Date -Format "o" -AsUTC)
```

### Issue script & Debug output

N/A

### Expected behavior

I expect the features described in the documentation to be available and readable.

### Environment Summary

azure-cli 2.53.0 *

core 2.53.0 *
telemetry 1.1.0

Extensions:
datafactory 0.9.0

Dependencies:
msal 1.24.0b2
azure-mgmt-resource 23.1.0b2

Python (Windows) 3.10.10 (tags/v3.10.10:aad5f6a, Feb 7 2023, 17:05:00) [MSC v.1929 32 bit (Intel)]

### Additional context

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.