Template:Query: Difference between revisions

63 bytes added ,  10 months ago
no edit summary
(Simpler way to query Cargo)
 
No edit summary
 
Line 1: Line 1:
{{#cargo_query: tables={{{table|null}}}
{{#cargo_query: tables={{{table|null}}}
|fields={{{get|null}}}
|fields={{{get|null}}}
|where={{#if: {{{filter_col|}}}
|{{#if: {{{filter_col|}}}{{{from|}}}| {{#if: {{{filter_col|}}}
     | {{{table|null}}}.{{{filter_col}}}="{{{filter_col_val| }}}"
     |where={{{table|null}}}.{{{filter_col}}}="{{{filter_col_val| }}}"
     | {{{table|null}}}.{{Is Discord ID|{{{from}}}|ifNo=name|ifYes=id}}="{{{from}}}" }}
     |where={{{table|null}}}.{{Is Discord ID|{{{from}}}|ifNo=name|ifYes=id}}="{{{from}}}" }}}}
|limit={{{limit|1}}}
|limit={{{limit|1}}}
|default={{{default|}}}
|default={{{default|}}}
|format=list
|format=list
|more results text=
|{{#if: {{yesno|{{{has_html|}}}}} ||no html}}
|{{#if: {{yesno|{{{has_html|}}}}} ||no html}}
}}<noinclude>{{documentation}}</noinclude>
}}<noinclude>{{documentation}}</noinclude>