Commerce: Difference between revisions

134 bytes added ,  20:06, 23 July 2019
→‎Items by Commerce Value: added dynamic table that includes page categories to search by category
(→‎Items by Commerce Value: edited so pages in the template/user namespaces are ignored)
(→‎Items by Commerce Value: added dynamic table that includes page categories to search by category)
Line 29: Line 29:


==Items by Commerce Value==
==Items by Commerce Value==
{{#cargo_query:table=Items|fields=_pageName=Page, Commerce=Value|order by=Commerce DESC|where=_pageNamespace <> "10" AND _pageNamespace <> "2"}}
{{#cargo_query:tables=Items,_pageData|join on=Items._pageName = _pageData._pageName|fields=Items._pageName=Page, Commerce=Value, _categories=Categories|order by=Value DESC|where=Items._pageNamespace <> "10" AND Items._pageNamespace <> "2"|format=dynamic table|rows per page=30}}
[[Category:Mechanics]]
[[Category:Mechanics]]