Template:Belle By Map Query: Difference between revisions

From Victory Belles Community Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 8: Line 8:
{{#cargo_query:
{{#cargo_query:
tables=MAINMap, MAINBelle
tables=MAINMap, MAINBelle
|fields=MAINMap.INT_MapHQLevel=HQ Level, MAINMap.TXT_MapName=Map Name
|fields=MAINMap.INT_MapHQLevel=HQ Level, MAINMap.TXT_MapName=Map Name, MAINMap.TXT_MapType=MapType, MAINMap.DATE_IRLStart=IRLStart, MAINMap.DATE_IRLEnd=IRLEnd
|where=MAINBelle.TXT_CharName = "{{#replace:{{{SearchTerm|}}}|'|\'}}"
|where=MAINBelle.TXT_CharName = "{{#replace:{{{SearchTerm|}}}|'|\'}}"
|join on=MAINMap.TXT_BOIList HOLDS MAINBelle.TXT_ID
|join on=MAINMap.TXT_BOIList HOLDS MAINBelle.TXT_ID

Revision as of 19:41, 17 July 2023

This is the 'Belle By Map Query' template. It should be called via the Form:Belle By Map Query form.