Query - Order of Columns

Skip to first unread message

Sam Seccombe

Mar 4, 2022, 7:15:52 AMMar 4
to SMART Community Forum

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?



Alexander Wyatt

Mar 6, 2022, 11:49:23 PMMar 6
to Sam Seccombe, SMART Community Forum
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. 



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

Mar 8, 2022, 10:46:07 AMMar 8
to SMART Community Forum, awy...@wwf.org.kh, SMART Community Forum, Sam Seccombe
Thank you for your responses!
Reply all
Reply to author
0 new messages