dbReport

DataBase (db) Report placeholder affords the option of retrieving data from the CMS database displaying all the results in a table, including multiple columns and rows.

Example: /playground/dbReport

If you want only one result, review the dbQuery placeholder.

Warning: Potential for abuse exists in the form of an SQL injection attack of someone edits the query.

The dbQuery placeholder has Custom Attributes:

• query – the SQL query
• tableborder – true or false, draw table with border on or off
• tablecaption – optional title string to draw in title portion of table
• tablesummary – optional table summary string
• tablecss – optional css class name to assign to table
• showcoltitles – true or false, draw column names derived from query as column headers.
• combinecol1col2link – true or false, if true, merge link target (col 1) with link name (col 2) and output the first two columns combined in one column.
• sortable - true or false, if set to true and showcoltitles = true then column tops can be clicked to sort table. more then one sortable table may be placed on a single page.
• csvexport - true or false, if set to true, show icon at bottom of table returns a report.csv response that may be used in programs like MS Excel. Table must be loaded and then csvexport url visited in order to obtain .csv.

All tables in the CMS may be queried, including the _Forms.

This demonstrates the render.

<placeholder_dbreport combinecol1col2link="false" csvexport="true" query="SELECT top 10 _FavoriteName, _Name, _CalculatedField, _Money, _Code FROM _aExampleForm" showcoltitles="true" sortable="true" tableborder="false" tablecaption="_aExampleForm 10 most recent entries" tablesummary="summary" />