Download EXT: Data Query (SQL-based Data Provider) - SVN
Transcript
EXT: Data Query (SQL-based Data Provider) - dataquery EXT: Data Query (SQL-based Data Provider) Table of Contents EXT: Data Query (SQL-based Data Provider). 1 Comments.............................................................. 9 Introduction........................................................... 3 Mandatory field “uid”...............................................9 What does it do?.....................................................3 Additional SQL in Data Filter.................................... 9 Screenshot............................................................. 3 Behind the scenes................................................ 10 Questions?............................................................. 3 Query parsing and query building...........................10 Keeping the developer happy...................................3 Translations, ordering and limits.............................10 Installation.............................................................4 Queries and Data Filters........................................11 User manual........................................................... 5 Data Query output................................................ 11 Defining a query..................................................... 5 Advanced uses of aliases....................................... 11 Writing queries.......................................................8 Caching................................................................ 11 Allowed keywords................................................... 8 Developer's Guide................................................ 13 Non-standard SQL keywords....................................8 Hooks...................................................................13 Join rules................................................................8 Known problems.................................................. 14 SQL function calls................................................... 9 To-Do List............................................................. 15 Expressions in queries............................................. 9 Changelog............................................................ 16 2