 | This is a documentation subpage for Template:Database report. It may contain usage information, categories and other content that is not part of the original template page. |
 | This template uses Lua: |
This template summons a bot to update the page with the results of the provided database query. It must be "closed" with {{Database report end}}; the text between these two templates will be replaced by the bot-generated table. It is possible to have multiple reports in one page.
The table is updated by the bot whenever you click the "Update the table now" button, and can be configured to automatically update periodically by setting |interval=N (one update every N days).
Some formatting options are provided which enable page titles to be wikilinked and article excerpts to be shown. For complex use cases, the row_template or postprocess_js options can be used which allow you to format the query output in arbitrary ways using wikimarkup, Lua or JavaScript.
This template is currently powered by SDZeroBot (source code). It populates Category:SDZeroBot database report subscriptions.
Don't know SQL? No worries. SDZeroBot's AutoSQL will help you get the SQL equivalent of a query written in plain English. It doesn't work all the time, sadly – in which case you can ask for help at WP:RAQ.