Archive
Highlighted

DB Connect: How to prevent append command from sorting columns in alphabetical order in the result set?

Contributor

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 tableT where <> Order By timecol"]

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.

Highlighted

Re: DB Connect: How to prevent append command from sorting columns in alphabetical order in the result set?

Path Finder

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

View solution in original post

Highlighted

Re: DB Connect: How to prevent append command from sorting columns in alphabetical order in the result set?

Contributor

Thanks a lot @russellliss. This was really helpful

0 Karma