Editing Template:Query/doc (section)

== Usage ==
Basic usage:

<code>&#123;&#123;query|table=''table''|get=''column to output data from''|from=''name or ID''}}</code>

or 

<code>&#123;&#123;query|table=''table''|get=''column to output data from''|filter_col=''column to filter''|filter_col_val=''value to filter by''}}</code>

* <code>|table=</code> - The Cargo table to search in. Go to [[Special:CargoTables]] to see all tables.
* <code>|get=</code> - The table column from which data should be retrieved and output.
* <code>|from=</code> - If this parameter is a valid Discord ID (e.g. <code>501310750074077215</code>), then data will only be taken from table rows whose "id" column matches this parameter. If this parameter is ''not'' a valid Discord ID, then the "name" column will be searched instead. If these columns are not present in the table, or you just want to filter by a different column, then use these parameters instead:
** <code>|filter_col=</code> - The column to search. If using this parameter, you must also specify the <code>filter_col_val</code> parameter.
** <code>|filter_col_val=</code> - The value to search for in the column specified in <code>filter_col</code>.

Not all parameters were listed here. For a detailed description of all parameters, see the TemplateData section below.

=== Examples ===
If you want to output the owner of [[Whenthe]], you could use either <code><nowiki>{{query|table=discord_servers|get=owner|from=Whenthe}}</nowiki></code> or <code><nowiki>{{query|table=discord_servers|get=owner|from=501310750074077215}}</nowiki></code>, which would output: {{query|table=discord_servers|get=owner|from=Whenthe}}

If you wanted a list of active servers, you could do something like <code><nowiki>{{query|table=discord_servers|get=name|filter_col=status|filter_col_val=active|limit=25}}</nowiki></code>, which would output: {{query|table=discord_servers|get=name|filter_col=status|filter_col_val=active|limit=25}}