Template:DiskProducerSeriesGallery - Revision history

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

2025-01-03T04:47:54Z

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

← Older revision		Revision as of 04:47, 3 January 2025
Line 18:		Line 18:
	}}		}}

	</noinclude><includeonly>=== {{{3}}} ===		</noinclude><includeonly>=== {{#replace:{{{3}}}\|🦟\|'}} ===
	{{#cargo_query:		{{#cargo_query:
	tables=Disks=D		tables=Disks=D
	\|fields=D.CoverArt, D._pageName = Link, CONCAT('[[', D._pageName, '\|', D.Code, ']]', '<br>', D.Title) = Caption		\|fields=D.CoverArt, D._pageName = Link, CONCAT('[[', D._pageName, '\|', D.Code, ']]', '<br>', D.Title) = Caption
	\|where=D.Type = '{{{1}}}' AND D.Producer = '{{{2}}}' AND COALESCE(D.Series, 'Unsorted') = '{{#replace:{{{3}}}\|'\|''}}'		\|where=D.Type = '{{{1}}}' AND D.Producer = '{{{2}}}' AND COALESCE(D.Series, 'Unsorted') = '{{#replace:{{{3}}}\|🦟\|''}}'
	\|order by=D.SortableTitle, D.Code, D.Title		\|order by=D.SortableTitle, D.Code, D.Title
	\|limit=1000		\|limit=1000

Midiphile: Escape single quotes in series name query condition.

2025-01-03T04:27:39Z

Escape single quotes in series name query condition.

← Older revision		Revision as of 04:27, 3 January 2025
Line 22:		Line 22:
	tables=Disks=D		tables=Disks=D
	\|fields=D.CoverArt, D._pageName = Link, CONCAT('[[', D._pageName, '\|', D.Code, ']]', '<br>', D.Title) = Caption		\|fields=D.CoverArt, D._pageName = Link, CONCAT('[[', D._pageName, '\|', D.Code, ']]', '<br>', D.Title) = Caption
	\|where=D.Type = '{{{1}}}' AND D.Producer = '{{{2}}}' AND COALESCE(D.Series, 'Unsorted') = '{{{3}}}'		\|where=D.Type = '{{{1}}}' AND D.Producer = '{{{2}}}' AND COALESCE(D.Series, 'Unsorted') = '{{#replace:{{{3}}}\|'\|''}}'
	\|order by=D.SortableTitle, D.Code, D.Title		\|order by=D.SortableTitle, D.Code, D.Title
	\|limit=1000		\|limit=1000

Midiphile: Show disks with blank Series field.

2024-03-15T09:17:01Z

Show disks with blank Series field.

← Older revision		Revision as of 09:17, 15 March 2024
Line 1:		Line 1:
	<noinclude>		<noinclude>
	This template creates a gallery for the disks in the given series.		This template creates a gallery for the disks in the given series. To list disks whose <code>Series</code> field is unset, use the special value <code>Unsorted</code> for parameter <code>3</code>.

	'''Usage:'''		'''Usage:'''
Line 22:		Line 22:
	tables=Disks=D		tables=Disks=D
	\|fields=D.CoverArt, D._pageName = Link, CONCAT('[[', D._pageName, '\|', D.Code, ']]', '<br>', D.Title) = Caption		\|fields=D.CoverArt, D._pageName = Link, CONCAT('[[', D._pageName, '\|', D.Code, ']]', '<br>', D.Title) = Caption
	\|where=D.Type = '{{{1}}}' AND D.Producer = '{{{2}}}' AND D.Series = '{{{3}}}'		\|where=D.Type = '{{{1}}}' AND D.Producer = '{{{2}}}' AND COALESCE(D.Series, 'Unsorted') = '{{{3}}}'
	\|order by=D.SortableTitle, D.Code, D.Title		\|order by=D.SortableTitle, D.Code, D.Title
	\|limit=1000		\|limit=1000

Midiphile: Template for disk level of nested gallery view.

2024-03-15T09:04:13Z

Template for disk level of nested gallery view.

New page

<noinclude>
This template creates a gallery for the disks in the given series.

'''Usage:'''
<pre>
{{DiskProducerSeriesGallery
| 1 = Type
| 2 = Producer
| 3 = Series
}}
</pre>

'''Example result:'''
{{DiskProducerSeriesGallery
| 1 = Songs
| 2 = Rittor Music
| 3 = MIDI Game Music Series
}}

</noinclude><includeonly>=== {{{3}}} ===
{{#cargo_query:
tables=Disks=D
|fields=D.CoverArt, D._pageName = Link, CONCAT('[[', D._pageName, '|', D.Code, ']]', '<br>', D.Title) = Caption
|where=D.Type = '{{{1}}}' AND D.Producer = '{{{2}}}' AND D.Series = '{{{3}}}'
|order by=D.SortableTitle, D.Code, D.Title
|limit=1000
|format=gallery|show bytes=0|show dimensions=0|show filename=0|link field=Link|caption field=Caption
|merge similar cells=yes
}}
</includeonly>