Template:BTDB2 change list by name: Difference between revisions
Created page with "<includeonly>{{autofill}}{{#cargo_query:table=btdb2_changes |fields=version, version_note quote, changes |where=names HOLDS '{{{1|}}}' |order by=(version + 0) |format=template |template=BTDB2 change list row |named args=yes |delimiter=\n |default=No changes found. }}</includeonly><noinclude>{{/doc}}</noinclude>" |
No edit summary |
||
| Line 1: | Line 1: | ||
<includeonly> | <includeonly>{{#cargo_query:table=btdb2_changes | ||
|fields=version, version_note | |fields=CONCAT("<h{{{header level|3}}}>[[", _pageName, "|Version ", version, "]] ", COALESCE(CONCAT("(", version_note, ")"), ""), "</h{{{header level|3}}}>\n", | ||
COALESCE(CONCAT("{", "{quote", "{{!}}", quote, "{{!}}Update notes}", "}\n"), ""), changes) | |||
| | |where=names HOLDS "{{{1|}}}" | ||
| | |order by=version | ||
| | |||
|format=list | |||
|delimiter=\n | |delimiter=\n | ||
}}</includeonly><noinclude>{{/doc}}</noinclude> | }}</includeonly><noinclude>{{/doc}}</noinclude> | ||
Revision as of 19:41, 17 November 2024
Uses Cargo to generate a list of changes that apply to a specific key.
| Parameter | Description | Type | Status | |
|---|---|---|---|---|
| Name | 1 | The key to use for the Cargo query. Will display a list of changes that contain this key in the "names" column with matching capitalization and spacing.
| String | required |
| Name 2 | 2 | A second key to use for the Cargo query. If specified, changes containing both the names will be displayed in the query.
| String | optional |
| Header level | header level | The level of section headers to use for the list.
| Number | optional |
Example usage
{{BTDB2 change list by name|Bot Factory}}
Function: CargoSQLQuery::run Query: SELECT `btdb2_changes`.`_pageID` AS `cargo_backlink_page_id_btdb2_changes`,CONCAT("<h3>Version ", version, " ", COALESCE(CONCAT("(", version_note, ")"), ""), "</h3>\n", COALESCE(CONCAT("{", "{quote", "|", quote, "|Update notes}", "}\n"), ""), changes) AS `CONCAT( <h3>Version , version, , COALESCE(CONCAT( ( , version note, ) ), ), </h3>\n , COALESCE(CONCAT( { , {quote , | , quote, |Update notes} , }\n ), ), changes)` FROM `cargo__btdb2_changes` `btdb2_changes` WHERE `btdb2_changes`.`_ID` IN (SELECT `_rowID` FROM `cargo__btdb2_changes__names` WHERE `_value`= "Bot Factory") ORDER BY `version` LIMIT 100