Difference between revisions of "Globals test"

Revision as of 22:49, 27 September 2013

{{#get_db_data: db=globals |from=globalnames |limit=10 |order by=id |data=id=id,name=name }}

ID	Name
{{{id}}}	{{{name}}}

@@ Line 2: / Line 2: @@
 {{#get_db_data:
 db=globals
-|from=tracker.globallog, tracker.globaltype
+|from=globalnames
-|where=globallog.item=3
 |limit=10
-|order by=value DESC
+|order by=id
-|data=date=globallog.date,name=globallog.owner,value=globallog.value
+|data=id=id,name=name
 }}
 <table>
-<tr><th>Date</th><th>Name</th><th>Item</th><th>Value</th></tr>
+<tr><th>ID</th><th>Name</th></tr>
-{{#for_external_table:<tr><td>{{{date}}}</td><td>{{{name}}}</td><td>{{{value}}}</td></tr>}}
+{{#for_external_table:<tr><td>{{{id}}}</td><td>{{{name}}}</td></tr>}}
 </table>