My team plans to use stored_query_results for certain partial calculations that need in preparation for an append into a table that is orchestrated by function that joins the various stored_query_results. Currently using a variable to set the string via strcat results in the following error: "stored_query_result(): the argument must be a non-empty string literal" (the respective strcat looks like this: strcat("constantFunctionName123",runId)
runId is also a nonempty string)
Because of this we need to hand over a list of all pre built names of the stored_query_results from our Logic App to the KQL-function. This makes the signature of the function to join the stored_qurey_results(sqr) rather cumbersome. We would like to only handover the runId and built the names of the stored query results in the function.
Could you enable the use of variables as inputs for stored_query_results(string)?
My team plans to use stored_query_results for certain partial calculations that need in preparation for an append into a table that is orchestrated by function that joins the various stored_query_results. Currently using a variable to set the string via strcat results in the following error: "stored_query_result(): the argument must be a non-empty string literal" (the respective strcat looks like this: strcat("constantFunctionName123",runId) runId is also a nonempty string) Because of this we need to hand over a list of all pre built names of the stored_query_results from our Logic App to the KQL-function. This makes the signature of the function to join the stored_qurey_results(sqr) rather cumbersome. We would like to only handover the runId and built the names of the stored query results in the function.
Could you enable the use of variables as inputs for stored_query_results(string)?