Editing Template:Query/doc (section)

== TemplateData ==

<templatedata>

{

    "params": {

        "table": {

            "label": "Table",

            "description": "The Cargo table to search in. Go to [[Special:CargoTables]] to see all tables.",

            "example": "discord_servers",

            "type": "string",

            "required": true

        },

        "get": {

            "label": "Field to display",

            "description": "The table column from which data should be retrieved and output. For example, if you wanted to find and output Whenthe's status, you would put the \"status\" column here.",

            "example": "status",

            "type": "string",

            "required": true

        },

        "filter_col": {

            "description": "The table column that contains the values you want to filter. If using this parameter, the \"from\" parameter will be ignored, and you MUST also use the filter_col_by parameter.",

            "example": "name",

            "type": "string"

        },

        "filter_col_val": {

            "description": "The value you're searching for from the column defined in the filter_col parameter. Only the data from rows that match this value in the column will be used. This parameter has no effect if filter_col is not defined.",

            "example": "Whenthe",

            "type": "string"

        },

        "from": {

            "label": "From",

            "description": "Filters results by name or ID. If this is in the format of a Discord ID, then only results whose \"id\" column matches this parameter will be used. Otherwise, only results whose \"name\" column matches this parameter will be used. For example, if you wanted to find and output Whenthe's status, you would put Whenthe's name or ID here. If there's a different column you want to filter by, you can use the filter_col and filter_col_val parameters instead.",

            "example": "Whenthe",

            "type": "string",

            "suggested": true

        },

        "limit": {

            "description": "The maximum number of results to get. Many queries only have one result. If there is more, and this parameter is set to a number greater than the default 1, the results will be output in a comma-delimited list.",

            "type": "number",

            "default": "1"

        },

        "default": {

            "description": "What to output if no results are found.",

            "type": "string",

            "default": "(empty string)"

        },

        "has_html": {

            "description": "Set this to \"yes\" if the output you want contains HTML that you want to use.",

            "type": "boolean"

        }

    },

    "description": "Does a simple query for data from a Cargo table. It returns data from one column of one table, by filtering one other column.",

    "paramOrder": [

        "table",

        "get",

        "from",

        "filter_col",

        "filter_col_val",

        "limit",

        "default",

        "has_html"

    ]

}

</templatedata>

<includeonly>

[[Category:Templates that query Cargo]]

</includeonly>

​