On 5 March 2012 15:21, Roderick <[email protected]> wrote: So, can you please help me - how do I do this: > "as long as all the tables are presented in the original query" > query = ? > form = SQLFROM.grid(query,...) > > I.e. I need a grid that displays all data from all 10 of my tables so > my users can run a complex query on any of them including joins? >
Give me an example of a raw sql query that will do what you want. Appadmin uses SQLTABLE which is easy to use with complex queries. There are at least two plugins which can be used with complex queries: Powertable http://powertable.blouweb.com/ and Solidtable http://dev.s-cubism.com/plugin_solidtable Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3)
