Introduction to eQL

eQL, which stands for eB Query Language (eB is the former name of AssetWise), is a special language designed to allow users to extract information from AssetWise for reporting. eQL is used by Report Designer in AssetWise Director and AssetWise Engineering Designer, as well as the quick and extended search interfaces in all AssetWise client applications (including AssetWise Web).

eQL resembles SQL, the database query language, but is simpler to work with than SQL, and is tailored for AssetWise objects and their relationships. eQL provides great flexibility in constructing queries, and is used as the basis for all searching and reporting in AssetWise.

The result of an eQL query is a set of records. Each record has information about one object, and each field in the record is a piece of information related to that object. Together, the records can be represented as a table, where each row in the table is a record, and each column heading in the table describes the information in each field of the records.

Here is an example eQL query and a sample of the results it returns from a hypothetical database:

START WITH Document
SELECT
  Code,
  Name,
  Class.Name,
  Files.Name
WHERE
  Name LIKE '%Maintenance%'
ORDER BY
  Code