Custom Queries

With administrative access rights, SQL queries can be made directly to the Projetex database. This feature is recommended for system administrators and IT specialists since it requires basic knowledge of SQL.

Structured Query Language (SQL) is a language of structured requests. It is intended for working with relational databases, which constitute the sets of interrelated data, stored in tables.

Nowadays SQL is a part of a large number of programs, executed on various types of computers. "Owing to its elegance and machine independence, as well as to the industrial leaders support in relational base technology, SQL was acknowledged the standard language and will keep this position in the foreseeable future."[2000, Mastering SQL, Martin Grubber]

Custom queries can be accessed in the Queries section of the Corporate Settings tab in Projetex Server Administrator.

 

 

 

See also:

Queries

Query Building Tutorial