SOLVED

Custom field for Timegenerated

Microsoft

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
2 Replies
best response confirmed by srikanth3300 (Microsoft)
Solution
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
thanks Clive,
It is working fine now
1 best response

Accepted Solutions
best response confirmed by srikanth3300 (Microsoft)
Solution
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

View solution in original post