Midiphile: Replace single quote to work around limitation of passing around Cargo template variables.

2025-01-03T04:48:15Z

Replace single quote to work around limitation of passing around Cargo template variables.

← Older revision		Revision as of 04:48, 3 January 2025
Line 19:		Line 19:
	{{#cargo_query:		{{#cargo_query:
	tables=Disks=D		tables=Disks=D
	\|fields=D.Type,D.Producer,COALESCE(NULLIF(TRIM(D.Series), ''), 'Unsorted') = Series		\|fields=D.Type,D.Producer,REPLACE(COALESCE(NULLIF(TRIM(D.Series), ''), 'Unsorted'), '''', '🦟') = Series
	\|where=D.Type = '{{{1}}}' AND D.Producer = '{{{2}}}'		\|where=D.Type = '{{{1}}}' AND D.Producer = '{{{2}}}'
	\|group by=D.Type,D.Producer,D.Series		\|group by=D.Type,D.Producer,D.Series

Midiphile: Template for producer level of nested gallery view.

2024-03-15T09:23:42Z

Template for producer level of nested gallery view.

New page

<noinclude>
This template creates a list of galleries for the disks from the given producer. The galleries as grouped by disk series.

'''Usage:'''
<pre>
{{DiskProducerGallery
| 1 = Type
| 2 = Producer
}}
</pre>

'''Example result:'''
{{DiskProducerGallery
| 1 = Songs
| 2 = Rittor Music
}}

</noinclude><includeonly>== {{{2}}} ==
{{#cargo_query:
tables=Disks=D
|fields=D.Type,D.Producer,COALESCE(NULLIF(TRIM(D.Series), ''), 'Unsorted') = Series
|where=D.Type = '{{{1}}}' AND D.Producer = '{{{2}}}'
|group by=D.Type,D.Producer,D.Series
|order by=D.Series
|limit=1000
|format=template
|template=DiskProducerSeriesGallery
}}
</includeonly>

Template:DiskProducerGallery - Revision history

Midiphile: Replace single quote to work around limitation of passing around Cargo template variables.

Midiphile: Template for producer level of nested gallery view.