Query - Order of Columns

18 views
Skip to first unread message

Sam Seccombe

unread,
Mar 4, 2022, 7:15:52 AMMar 4
to SMART Community Forum
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

unread,
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. 

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

unread,
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
Forward
0 new messages