EQL365 (ELMA365 Query Language) is a language for querying data stored in the ELMA365 system. EQL queries are based on the developed syntax and extend the basic search capabilities. They allow you to create complex data selections based on specified parameters, taking into account several conditions.
You can assign specific values to the app properties, compare them with each other, or calculate the values using functions. To check several conditions in one query, you can use logical connectives—operators. For example, the search result can display all companies with orders for a certain amount and with contracts in a specified status.
Using EQL search
Search on the app page
You can use EQL search to find items in apps. To do this, click the icon in the search bar on the app page. In the EQL search field, compose a query according to EQL365 syntax. You can use the autocomplete options in the query field:
- Select the variables of the current app;
- Add the following functions to the query:
Datetime
,Time
,CurrentUser
,Refitem
; - Specify any app from other workspaces of the system;
- Add logical operators for combining multiple conditions:
AND
,OR
,NOT
, etc.
Click Search or save the query as a filter to use it again later.
Data selections in Web API
EQL queries can be used in the Web API, for example, they can be added to the structure of a query to get lists of app items in the filter
construction. Several EQL queries can be used. When composing a query, the "eql"
value is used for the description key. For the body of the query, the construction from the "query"
subkey and the text of the selection condition are specified.
For example, for the Goods app, we get all items with a unit price (price
variable code) equal to 400:
{
"filter": {
"eql":{
"query":"[price] = 400"
}
}
}
To test the composed query, go to the app settings, select the API item, and open the Item List tab. For more information about Web API, see API in apps and Introduction to Web API.
Found a typo? Highlight the text, press ctrl + enter and notify us