Query - Order of Columns

[Sam Seccombe]

Hi,

I would like to change the order of columns when creating a Query so that when it exports to a .csv file it is formatted correctly.

I have seen a similar question on the forum from 2014 but no reply and cannot find anything about this in the resource library.

Is this possible or do I need to turn the Query into a Report, format columns and then export?

Thanks,

Sam

[Alexander Wyatt]

Hi Sam, 

The order of your query results will mirror the design of the data model and the query definition. 

Yes, to do this within the SMART software I would recommend to use the reporting module. Please refer to the advanced reporting handbook for guidance. 

Cheers, 

Alex

--
You received this message because you are subscribed to the Google Groups "SMART Community Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to community+...@smartconservationsoftware.org.
To view this discussion on the web visit https://groups.google.com/a/smartconservationsoftware.org/d/msgid/community/d8124660-1310-4fae-8c9f-9ab784a44e4en%40smartconservationsoftware.org.

[Sam Seccombe]

Thank you for your responses!