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.
let ID = toscalar(customtable_CL | top 1 by TimeGenerated desc | project id);
customtable_CL | where Columname == "ABC" and id == ID | order by TimeGenerated desc
Hi Patrick ,
Sorry for the late reply.. I got other solution...
And yes It is working as well, appreciate your help.. thank you.