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