Latest Activity


Function row_number() not executable with temporary tables

Hi, When I use row_number() with a temporary table in VQL Shell, it gives me this error - Function row_number is not executable. If I run the query without the temporary table, it runs perfectly fine. Is there any way to use row_number() function with...



Unable to use row_number() function when JSON as Data source

Hi,I am using JSON as data source. I would like to use row_number() function in my view. Getting data source from API in JSON format. Base view is created from the root JSON array. I have used flattern view to remove the top JSON array. From the fla...

row_number() JSON JSON Datasource