User:Teamtoto/Sandbox: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
| Line 39: | Line 39: | ||
<pre> | <pre> | ||
{{#invoke:CargoQuery| compound | {{#invoke:CargoQuery| compound | ||
| 1 | | 1=tables=ItemsTable=IT, GeneralData=GD | ||
; join on = IT.ObjectID = GD.ObjectID | ; join on = IT.ObjectID = GD.ObjectID | ||
; fields= {{favilink format args}} | ; fields= {{favilink format args}} | ||
| Line 48: | Line 48: | ||
</pre> | </pre> | ||
{{#invoke:CargoQuery| compound | {{#invoke:CargoQuery| compound | ||
| 1 | | 1=tables=ItemsTable=IT, GeneralData=GD | ||
; join = IT.ObjectID = GD.ObjectID | ; join = IT.ObjectID = GD.ObjectID | ||
; fields= {{favilink format args}} | ; fields= {{favilink format args}} | ||
| Line 55: | Line 55: | ||
| delimiter = </br> | | delimiter = </br> | ||
|default=None}} | |default=None}} | ||
<!--{{#invoke:cargo_query|main | <!--{{#invoke:cargo_query|main | ||
| table=Factions=F | | table=Factions=F | ||
Revision as of 18:19, 12 April 2021
{{#invoke:CargoQuery| main
| tables=ItemsTable=IT,GeneralData=GD
| join on = IT.ObjectID = GD.ObjectID
| fields={{favilink format args}}
| where= HarvestedInto= "vinewafer"
|template=favilink format
| delimiter = </br>
|default=None}}
None
{{#invoke:CargoQuery| compound
| 1=table=ItemsTable
; fields=ObjectID=Page
; where= HarvestedInto= "vinewafer"
|template=favilink id
| delimiter = </br>
|default=None}}
this one is broken:
{{#invoke:CargoQuery| compound
| 1=tables=ItemsTable=IT, GeneralData=GD
; join on = IT.ObjectID = GD.ObjectID
; fields= {{favilink format args}}
; where= HarvestedInto= "vinewafer"
| template = favilink format
| delimiter = </br>
|default=None}}
Lua error: Error: join conditions must be set for tables..