odbc.get columns are reordered after jsonpath preprocessing
Hello,
I use odbc.get to get a list of 6 columns (ID, SUB_ID, TYPE, STATUS, NAME, CATEGORY) and then use JSONPATH preprocessing on a dependent item to filter out some of the results by TYPE:
$[?(@.TYPE=='XXXX' || @.TYPE=='XXXX')]
The problem is the ordering of the columns is for some reason different in the json value after this step and changed to STATUS, CATEGORY, TYPE, ID, NAME, SUB_ID. Basically it looks completely random instead of following the order in the SQL output.
Anyone have an idea why this happens and how to fix it? Version is 6.0.28.
I use odbc.get to get a list of 6 columns (ID, SUB_ID, TYPE, STATUS, NAME, CATEGORY) and then use JSONPATH preprocessing on a dependent item to filter out some of the results by TYPE:
$[?(@.TYPE=='XXXX' || @.TYPE=='XXXX')]
The problem is the ordering of the columns is for some reason different in the json value after this step and changed to STATUS, CATEGORY, TYPE, ID, NAME, SUB_ID. Basically it looks completely random instead of following the order in the SQL output.
Anyone have an idea why this happens and how to fix it? Version is 6.0.28.