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= | + | |where=_pageName="{{#replace:{{{book}}}|'|\'}}/contents") |
|order by=subject,start_page | |order by=subject,start_page | ||
|group by=subject | |group by=subject | ||
Revision as of 21:12, 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 ') GROUP BY `subject` ORDER BY `subject`,`start_page` LIMIT 100' 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 ') 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 ') GROUP BY `subject` ORDER BY `subject`,`start_page` LIMIT 100' 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"