MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.26k stars 21.43k forks source link

How to escape `prop__{OriginalFormat}` in Workbooks #73161

Closed coolhome closed 3 years ago

coolhome commented 3 years ago

In the event I have an Azure Workbook and Azure Functions traces it appears I need to escape {OriginalFormat} that is a customDimensions property. In the documentation for Parameters I did not find anything about escaping. Under kusto for strings it does not talk about parameters. Not really sure how to work around that.

Example from Azure Workbook image

traces 
| extend Test = tostring(customDimensions["prop__{OriginalFormat}"])

References:

https://docs.microsoft.com/en-us/azure/azure-functions/functions-dotnet-class-library?#structured-logging https://docs.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-parameters https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/scalar-data-types/string


Document Details

Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

femsulu commented 3 years ago

@coolhome Thanks for bringing this to our attention. Your feedback has been shared with the content owner for further review.

yves-chan commented 3 years ago

Currently, we cannot escape parameters in workbooks. What you could do as a workaround is create a text parameter named OriginalFormat with the value {OriginalFormat} so that the query can reference the OriginalFormat parameter.

lgayhardt commented 3 years ago

Closing this issue for now, let us know if you have any more questions.

please-close

coolhome commented 3 years ago

This may be potentially resolved by this PR which converts {OriginalFormat} to just OriginalFormat if I understand it correctly. microsoft/ApplicationInsights-dotnet#2362?