I have a query that looks like the following:
index=<> host=<> |rex=<> spath <>|table a,k,h|sort time|append[|dbquery DB "select X,Z,W,P from table_T where <> Order By time_col"]
the result set has the following columns:
a|k|h|P|W|X|Z
While I expect
a|k|h|X|Z|W|P
How can I get rid of this automatic alphabetical sorting?
While I run the dbquery alone, it works fine and shows me the expected columns.
I have gotten around this before by using the table command, so in your example :
index= host= |rex= spath |table a,k,h|sort time|append[|dbquery DB "select X,Z,W,P from table_T where Order By time_col"] | table a,k,h,X,Z,W,P
I have gotten around this before by using the table command, so in your example :
index= host= |rex= spath |table a,k,h|sort time|append[|dbquery DB "select X,Z,W,P from table_T where Order By time_col"] | table a,k,h,X,Z,W,P
Thanks a lot @russellliss. This was really helpful