|
The technical forum of the NBN Trust for use by the Network. It includes discussions and announcements on the NBN Atlas, Recorder 6 and Indicia |
You are not logged in. Please login or register.
Forum → How Do I... & Other Questions → Displaying First County Records
I have written a report which reports the first/last records for each species in the database - the SQL runs fine in SQL Server Management Studio, but when I apply it to Recorder as an XML, it appears to completely ignore the ORDER BY command - anyone know what I've done wrong?
The Report is attached
Craig
Could it be related to this: https://forums.nbn.org.uk/viewtopic.php?id=4845
Does look to be related, however, running the SQL in SQL Management Studio, the ORDER_BY is recognised and interpreted correctly (but not when run through Recorder)
Craig
AFAIK Recorder inserts the results into a temporary table and expects the sort to be maintained (it isn't guaranteed), hence why it works okay in management studio.
Hi
Just noticed this post. You need to apply the sort in the xml report using OutputTableOrderby eg.
</Where>
<OutputTableOrderby name="by default" SQL="ORDER BY Matched_List,Taxa_Input"/>
</SQL>
This looks a useful report, please would you share it, assuming you got it to work?
many thanks
Forum → How Do I... & Other Questions → Displaying First County Records
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.