Forum Discussion
Solved
How to pass dynamic data to the "Where Condtion"
Hi, Can some one help me how to pass the variable data dynamically in where condition for log analytics query . below query is not executing , it is telling that "Syntax Error" Example : let ID...
Hi Patrick ,
Sorry for the late reply.. I got other solution...
And yes It is working as well, appreciate your help.. thank you.
Thank you for response..
Sorry for typo(mistakenly keyed), But I have tried exactly below(semicolon after let statement and correct spelling for TimeGenerated) ,
erro is "'where' operator: Failed to resolve column or scalar expression named 'id' "
let ID = customatable | top 1 by TimeGenerated | summarize by id;
search Columname = "ABC" | where id == ID | sort by TimeGenerated desc
let ID = toscalar(customtable_CL | top 1 by TimeGenerated desc | project id);
customtable_CL | where Columname == "ABC" and id == ID | order by TimeGenerated descHi Patrick ,
Sorry for the late reply.. I got other solution...
And yes It is working as well, appreciate your help.. thank you.
