Lost query lines for a multiline query when using "az monitor log-analytics workspace saved-search create"

[lqm678]

az feedback auto-generates most of the information requested below, as of CLI version 2.0.62

Describe the bug
Lost query lines for a multiline query when using "az monitor log-analytics workspace saved-search create"

To Reproduce

az monitor log-analytics workspace saved-search create -g MyRG --workspace-name MyWS -n MySavedSearch --category Test1 --display-name TestSavedSearch -q $query

If the query is a multiline string. (A typical scenario is a query from az monitor log-analytics workspace saved-search list)

Expected behavior
Should keep the multiline query string.

Suggestions
Method-1: Check the input value of --query: if it's a file, then read the file content, this should be safe, easy and transparent.
Method-2: Provide a new option like --query-from-file , need 2 validations.

[yonzhan]

monitor

[YuanyuanNi]

Hi:
@lqm678 you could use " " to quote what you want to query and it works well even the query is a multiline string, an example from doc as below:
az monitor log-analytics workspace saved-search create -g MyRG --workspace-name MyWS -n MySavedSearch --category Test1 --display-name TestSavedSearch -q "AzureActivity | summarize count() by bin(TimeGenerated, 1h)"
Best wishes.

[PetrPospisil]

Hi @YuanyuanNi,
could you elaborate how you get multiline string into the -q parameter using the "" in powershell? I tried multiple escape options and the CLI always cut the string behind the first line on '\n'.
azure-cli 2.47.0

$multiline = @"
omg1
omg2
"@

az monitor log-analytics workspace saved-search update `
        --saved-query $multiline `
        --name $functionName `
        --display-name $functionDisplayName `
        --category $functionCategory `
        --resource-group $resourceGroup `
        --workspace-name $workspaceName `
        --fa $functionAlias `
        --fp $functionParameters

fails with error
ERROR: unrecognized arguments: omg2

Thx.