Managing queries

A Query is a mean to create a set of source resources, and potentially explore the relations between this source set and target artifacts that respect certain given properties / relations.

SECollab lets you create queries to analyse your current engineering data:

We have 2 types of queries

The result of the execution of a Simple query is a flat list of "artifacts", if any.

The result of the execution of a Join query is a set of "source artifacts" mapped to "target artifacts", if any.

Creating queries

To create Queries, go to the Project Administration's "Queries" section:

Creating a Simple Query
Creating a Join Query

A SECollab query (according its type) can then be decomposed from one up to tree separate clauses: source filter, join condition and target filter.

Writing query filters (source & target)

When creating a query, you need to write a clause that fetches relevant resources. Such a query is meant to check if a resource has a given set of properties, or if one of its linked resources has a given set of properties. To access a property, you need to write the namespace prefix and the property name, such as `dcterms:title`. Backquotes are required to express properties. Double quotes (") are used to express strings, and <> are used to express URI.

Writing a query filter is the same as writing a resource type's query. Please check Managing resource types for more details.

Writing join condition

A join condition is typically written as a test that a relationship exists.

Custom Collaborative links and resource types are always prefixed with clm_custom.