Difference between revisions of "Template:RPGBook TOC Query"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
tables=RPGBook_TOC_Entry | tables=RPGBook_TOC_Entry | ||
|fields= '{{{department|}}}'=ShowDepartment, GROUP_CONCAT(DISTINCT _pageName) = book, subject, '{{{ShowAuthor|}}}'=ShowAuthor | |fields= '{{{department|}}}'=ShowDepartment, GROUP_CONCAT(DISTINCT _pageName) = book, subject, '{{{ShowAuthor|}}}'=ShowAuthor | ||
| − | |where=_pageName=CONCAT( | + | |where=_pageName=CONCAT({{#replace:{{{book}}}|'|''}}, '/contents') |
|order by=subject,start_page | |order by=subject,start_page | ||
|group by=subject | |group by=subject | ||
Revision as of 21:10, 22 September 2024
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{{book}}}, '/contents') GROUP BY `subject` ORDER BY `subject`,`start_page` L...' at line 1
| Chapter | Author | Pages |
|---|
[[{{{book}}}/contents|c]]
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '25, '/contents') GROUP BY `subject` ORDER BY `subject`,`start_page` LIMIT 100' at line 1
| Department | Article | Author | Pages |
|---|
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'the Travellers Aid Society volume 1, '/contents') GROUP BY `subject` ORDER...' at line 1
| Article | Author | Pages |
|---|
This is a Cargo query template. This template queries data from the RPGBook TOC Entry table. The data for this table is entered by using the Template:RPGBook TOC Entry.
Parameters:
- book: The article title for this table of contents.
- department : Set to include the Department column in the table
- heading : Set the heading for the chapter title or publication article name, defaults to "Chapter"