In composer I have a field whose data is populated by a query to a custom table.
This table has 500 plus entries and I have to add more from time to time.
The problem is that SQL does not store the entries alphabetically, so when the data is returned my newest entries are stuck all the way down at the bottom making selecting them a pain.
My query reads like this: select entry from dbo.fileguide
Query attribute providing data: entry
Is it possible to simply append an "order_by" statement to the end of the current query? If so what would it look like to sort alphabetically?
