Define Alfabet queries

The Alfabet query language is a class-oriented query language designed to offer easy access to data from the Alfabet database. Knowledge of the SQL language is not necessary to create or use Alfabet queries. Once an Alfabet query is defined, the Alfabet platform will translate the Alfabet query into native SQL and send it to the database.

The Alfabet query language is limited to returning object information. For example, you cannot add fixed text to a dataset using Alfabet query language. It is sufficient to cover a wide range of configurations in Alfabet. Nevertheless, it is recommended to use native SQL to make use of the full scope of configuration capabilities available for Alfabet. For example, ADIF scheme configuration cannot be performed via Alfabet query language.

If you want to try out building a query, you can define a simple, tabular configured report of the type Query in the Reports tab of Alfabet Expand. Right-click the root node and select Create Report. By default, configured reports alreaady have the settings required to build a tabular report based on a single Alfabet query.