Template:Query: Difference between revisions
Simpler way to query Cargo |
fix bug |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{#cargo_query: tables={{{table|null}}} | {{#cargo_query: tables={{{table|null}}} | ||
|fields={{{get|null}}} | |fields={{{get|null}}}=get | ||
| | |{{#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> | ||