Forum Discussion

srikanth3300's avatar
srikanth3300
Icon for Microsoft rankMicrosoft
Apr 21, 2020

Custom field for Timegenerated

We are using the below query to get time details , it is working fine in workbooks but it is not working in logs 

 

let data = ADFTriggerRun
| where TimeGenerated {TimeRange}
 
 SYNTAX ERROR
Query could not be parsed at '{' on line [2,22] Token: { Line: 2 Position: 22
 
Request id: 1481ff60-9ae7-428d-9d22-426ecf49a693
  • This will work in logs.

    | where TimeGenerated > ago(1d)

    {Timerange} is unique to a Workbook and takes the Parameter from a drop down, replacing the selected value with something like > ago(7d). You can't reuse these parameters in a normal query as the drop down control doesn't exist
  • This will work in logs.

    | where TimeGenerated > ago(1d)

    {Timerange} is unique to a Workbook and takes the Parameter from a drop down, replacing the selected value with something like > ago(7d). You can't reuse these parameters in a normal query as the drop down control doesn't exist

Resources