Custom Queries

Projetex 2006 gives the possibility of adding custom variables to the .rtf-reports, and creating additional fields for the main entities – clients, projects, freelancers and corporate experts. And from now on it provides the possibility of creating custom reports and requests as well. To make full use of these innovations you will need the basic knowledge of Structured Query Language, and we shall, of course, help you in that any time when necessary.

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. That is why it will definitely come in handy in the nearest future. "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]

See Also:

User Queries

Query Builder

Example: creating a query within the report