Template:Scrap Navbox: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
m (Update to use new Cargo table) |
||
Line 5: | Line 5: | ||
| state = {{{state|autocollapse}}} | | state = {{{state|autocollapse}}} | ||
| group1 = Scrap | | group1 = Scrap | ||
| list1 = {{#cargo_query:tables= | | list1 = {{#cargo_query:tables=ArtifactData=AD,GeneralData=GD | ||
| join on= | | join on=AD.JoinKey=GD.JoinKey | ||
| where=GD.ParentObject WITHIN 'Scrap' AND GD.ObjectID NOT LIKE "Med%" | | where=GD.ParentObject WITHIN 'Scrap' AND GD.ObjectID NOT LIKE "Med%" | ||
| fields=CONCAT('{{((}}favilink page{{!}}',GD._pageName,'{{))}}'), CONCAT('{{((}}bits{{!}}', | | fields=CONCAT('{{((}}favilink page{{!}}',GD._pageName,'{{))}}'), CONCAT('{{((}}bits{{!}}',AD.Bits, '{{))}}')= | ||
| order by= | | order by=AD.Bits | ||
| format=list | | format=list | ||
| delimiter = -  | | delimiter = -  | ||
Line 15: | Line 15: | ||
| group2 = Medical Scrap | | group2 = Medical Scrap | ||
| list2 = {{#cargo_query:tables= | | list2 = {{#cargo_query:tables=ArtifactData=AD,GeneralData=GD | ||
| join on= | | join on=AD.JoinKey=GD.JoinKey | ||
| where=GD.ParentObject WITHIN 'Scrap' AND GD.ObjectID LIKE "Med%" | | where=GD.ParentObject WITHIN 'Scrap' AND GD.ObjectID LIKE "Med%" | ||
| fields=CONCAT('{{((}}favilink page{{!}}',GD._pageName,'{{))}}'), CONCAT('{{((}}bits{{!}}', | | fields=CONCAT('{{((}}favilink page{{!}}',GD._pageName,'{{))}}'), CONCAT('{{((}}bits{{!}}',AD.Bits, '{{))}}')= | ||
| order by= | | order by=AD.Bits | ||
| format=list | | format=list | ||
| delimiter = -  | | delimiter = -  | ||
}} | }} | ||
}}<noinclude>[[Category:Navigation]]</noinclude> | }}<noinclude>[[Category:Navigation]]</noinclude> |
Latest revision as of 16:28, 7 October 2021
|