Custom reports via query console

The LUY query console provides a powerful way to analyze your data with iteraQL. Build personalized queries, traverse the meta model, filter by any attribute, and much more.

1. Report category:

   1. Create new report

   2. Load existing report

   3. Save report

   4. Subscribe to current report

2. Filter category:

   1. Filter the result list

3. View category:

   1. Add new columns to the result list

4. Tracking category:

   1. Open the query history

5. Use for category:

   1. Show result as a diagram. Only the resulting elements are transferred and not the filter or columns.

   2. Show result in list view. Only the resulting elements are transferred and not the filter or columns.

   3. Export result as CSV or Excel

   4. Share query with other users

6. Text area input

7. Execute query and show result

8. Result of executed query

The most recently executed query is automatically loaded from the user profile when the query console page is opened.

Result set

The result of the query is shown as a table at the bottom of the page. Depending on the result type, additional actions are possible similar to the building block list.

Query history

The five most recently executed queries are saved for the user in the query history menu. They can be deleted, copied, or directly executed.

Getting started with iteraQL

IteraQL is the internal programming language which can be used in the query console or the query REST API endpoint.

1) The elastic model

The iteraQL environment builds up on the elastic data model in LUY. Therefore, the objects appearing in iteraQL are building blocks, properties, and relations. While building blocks are the main elements, properties enhance building blocks with additional attributes and relations making it possible to have building blocks with relations to each other.

2) IteraQL query

IteraQL is used for building individual queries. The syntax tells LUY what part of the model needs to be shown. The list of operators defined for the iteraQL syntax allows to develop queries returning exactly the desired information.

3) The reference sections

The iteraQL reference provides detailed explanations and examples for every operator.

Building blocks, relations and properties

An iteraQL query uses parts of the meta model and combines them with filters and operators. The LUY meta model consists of certain building blocks and relation types. The iteraQL name of each building block or relation type is almost identical to its English name used in LUY, the only difference being the omission of all spaces. For example, the information system domain building block of LUY is depicted as “InformationSystemDomain”.

The list on this page provides a reference of all building block and relation types including their attributes.