Help:Creating SQL-queries

This page is a knowledge crystal of subtype method. The page identifier is Op_en2559
Moderator:Nobody (see all) Click here to sign up.
Upload data {{#opasnet_base_link:Op_en2559}}

It is possible to create SQL-queries as links to Result Database using sql-query -tag.

Usage

Place your SQL-query between <sql-query> and </sql-query> -tags.

Example:

<sql-query>select * from Variable
</sql-query>

Generates: <sql-query>select * from Variable </sql-query>

It is also possible use additional parameters:

• display (if set to "1" SQL-query is displayed in wikipage as preformatted text)
• name (name of the link, default is "Run query")

Example:

<sql-query display="1" name="What a great query">select * from Variable
</sql-query>

Generates: <sql-query display="1" name="What a great query">select * from Variable </sql-query>

Note: Length of the query is limited to 255 characters