It’s been almost two months since the last ORDS release, and the eagle-eyed amongst you will have noticed that we seem to have skipped a few version numbers (from 1.0.10 to 1.0.14). During this time we’ve been working on getting the data filtering interface to work properly. Data filtering had been built-in to the ORDS before its official release in August 2014, but was removed from the official launch version due to various problems associated with it. Its reintroduction has required a lot of testing and several software builds that were deemed too unstable to make it into the public service, but everything should now be in place and working. Do let us know how you get on with it.
Much of the credit for the filtering interface should go to the members of the ORDS User Group, who helped us design the function. The User Group have also been helping the ORDS team design a visual query builder, which will allow users to create sophisticated conditional queries across multiple tables without the need to know SQL. We’ll be starting work on that shortly, and will report back on progress in due course.
Changes between this version of the ORDS and version 1.0.10 include the following:
- Implemented filtering interface. Records can now be filtered in the data editing view enabling users to isolate those that are of interest or require further work
- Commas within data should no longer cause problems when exporting the data as .csv files
- Record auto-numbering within the ORDS native interface should now work after a table has been edited via third-party software such as MS Access
- Bug relating to changing the accuracy of decimal data types now fixed
- Occasional occurrence of ORDS generating SQL syntax errors fixed
- Updated documentation regarding data types
- Occasional crash when re-running static datasets fixed
- Improvements to presentation of ‘Add New Record’ form – including fixing occasional font re-sizing issues
- Uploaded data containing Greek (or other non-Roman) characters should now always display correctly in the editing interface
- Improved database upload mechanisms – this enables larger databases than formerly to be uploaded directly by users without the system timing out
- Improved memory handling when deleting databases