google-code-export / ords

Automatically exported from code.google.com/p/ords
1 stars 0 forks source link

Need to improve query builder #623

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

1. The Current query builder isn't really worthy of the name. During the 1st 
ORDS User Group meeting (2nd March 2015) the users approved a new more 
graphical and functional version - see the attached image.

2. We should include the table name before each field name in the ORDER BY and 
CONDITIONS sections (e.g. 'places.PlaceName') so that it doesn't become 
confusing if the same field name is used in more than one table.

3. Operators should also include 'contains' - which returns results if a 
particular string (or set of numerals) is present in a particular fields.

Please use labels and text to provide additional information.

There was a request to be able to repeat the same table several times in the 
FIELDS TO DISPLAY section, but I think we should re-scope this once the basic 
functionality is in place

Original issue reported on code.google.com by jajwil...@gmail.com on 2 Mar 2015 at 4:53

Attachments: