Functions

Functions can be divided into user and system functions.

User Functions

There are two types of user functions:

QueryFunctionResult – function for getting a specific value;
QueryInFunction – function for getting multiple values, used after the in operation.

The following functions pertain to the QueryFunctionResult type:

DateTime(year, month, day, [hour], [minute], [second], [millisecond]) – date and time. Optional parameters of the function are specified in brackets. This function can include the following parameter values:

Now – current date and time;

Today – the current date and time as <dd:mm:yy>, (00:00:00);

MinValue – minimum allowed value of the "Date/Time" type variable;

MaxValue – maximum allowed value of the "Date/Time" type variable.

CreationDate <= DateTime(2014, 12, 17, 11, 15) – search contractors, whose creation date is less than or equal to 17.12.2014, 11:15.

Guid('UID as a string') – the object ID is passed to the parameter of this function as a string, the function returns the UID as a number. You can compare the value of this function only with similar ID values - either in string or numeric form:

Uid = Guid('27E70DFE-2A76-4F1D-A99A-CDF31C62D618') – search contractors with the specified ID.

TypeReference('object class name') – link to an object type. You can find the object class name in ELMA Designer - object page - Common tab - Data Structure unit:

TypeUid = TypeReference('ContractorLegal') – search all the companies.

Reference(object type ID, object ID) – object value. Both function parameters are required:

DrawnUpContract = Reference('298b2c71-619f-463c-95b2-8e029085680d', 15) – search replies to the question by the specified IDs.

DropDownItem('drop-down list value') – a value of the drop-down list. Select one of the drop-down list values as the parameter of this function (the list of values is specified in the drop-down list property settings on the Common tab in the List Elements field):

ListOfBranchOffices = DropDownItem('Frankfurt Office') – search by the specified branch office.

WorkTime(days, hours, minutes) – working time interval:

Interval > WorkTime(1, 0, 00) – search all the objects, for which the interval of more than 1 business day is specified.

The following functions pertain to the QueryInFunction type:

CurrentUser() – ID of the current user. Function without parameters:

CreationAuthor IN (CurrentUser(), 2) - search contractors, created by the current user or by the user with ID=2.

Enum('enumeration value name') – id of the specified enumeration value:

Contacts IN (Priority IN (Enum('High'), Enum('Low'))) – search contractors whose contacts have high and low priority.

RelativeDateTime('relative period start date', 'relative period end date') - time interval between relative dates. One of the parameters can be empty. In this case, the parameter is set with empty single quotes and the NULL value.

If the first parameter (period start date) is empty, then the time interval will start from minus infinity (minimum allowed value) until the second parameter (period end). If the second parameter (period end date) is empty, then the time interval will start from the first parameter (period start date) until the current date:

CreationDate IN RelativeDateTime('-1m', '-1m') – search all the contractors, created last month.

SubTypes('object class name') – links to object types and child elements. You can find an object class name in ELMA Designer - object page - Common tab - Data Structure unit:

TypeUid in SubTypes('ContractorIndividual') – search all the individuals.

CurrentUserGroups() – returns the current user's groups.
GetChiefByUser() – search all the superiors of the user, according to the organizational structure:

Responsible in GetChiefByUser(1) – search contractors, for which the superiors of the user with ID=1 are responsible.

GetUserSubordinate() – search all the subordinate users according to the organizational structure:

Responsible in GetUserSubordinate(101) – search all the contractors, for which the subordinates of the user with ID=101 are responsible.

GroupUsers() – search all the members of a user group:

Responsible in GroupUsers(109) – search all the contractors, for which the members of the group with ID=109 are responsible.

UserGroups() – search all the user groups, whose member is the user, whose ID is specified in the function:

Id in UserGroups(102) – search all the user groups, whose member is the user with ID=102.

UserOrganisationItems() – search users according to the job positions in the organizational structure:

CreationAuthor in (FROM User SELECT Id WHERE OrganizationItems in UserOrganisationItems(1)) – search all the contractors, created by the user, who occupies a certain job position (with id=1).

System Functions

COUNT() – function for writing complex subqueries, whose result is an integer. System function rules:

COUNT(property) – search by a list-type field, where:

property is a list-type field.

COUNT(Contacts) > 0 – search contractors, which have contacts.

COUNT(query) – subquery, created according to the rule:

FROM entity WHERE expression, where:

entity – is an object the subquery works with;

expression – is an expression for filtering the object instances; can also be a subquery.

COUNT(FROM Contact WHERE NOT Skype IS NULL AND Contractor = PARENT.Id) >= 1 – search contractors, which have at least one contact, with the condition that the Skype field of the contacts is filled in and the contractor's contact matches the searched one.

COUNT(function), where function – QueryInFunction is a function, which returns a list as the result:

COUNT(GroupUsers(1)) – number of users in the group with ID=1.

To learn more about working with the EQL language, see this knowledge base article.