The query editor

The query editor allows you to search for already created content instances. You can formulate complex queries on structures and their properties, it's like building SQL statements visually.

The elements of the query result set can be attached to the content tree or saved into a briefcase, which can be shared among users. A query can also be saved.

To access the query editor go to the Search tab of the [fleXive] backend administration. It is also accessible via the FxSQL / Search menu item in the Administration tab. Open the query editor and rightclick on nodes of the content tree and structure tree to formulate your query. You can add as many nodes as you want. You can also search on structure properties.

Select the chosen query elements with Shift or Ctrl and rightclick on them to use the context menu to create subqueries with con/disjunctions.

The following screen shows a formulated query in the query editor. You can nest your subqueries infinitely.

The following comparison operators are available:

=

Expression is equal

not equal

Expression is not equal

is empty

Expression is empty

is not empty

Expression is not empty

like

Partial match. Use the % character, meaning any character(s), to build your expression. Mind that the term any character(s) implies no character. Expression is case insensitive.

The following examples illustrate the usage of like in sql statements and the [fleXive] query editor. Assuming a user with first name John exists in the database, you could search for him (and all other matching names) using the following patterns.

%oh%

Search for oh preceded and followed by any character(s), meaning all words containing oh.

jo%

Search for jo followed by any character(s), meaning all words starting with jo.