Skip to Content

Comindware Expression Language examples

Assigning a task to the manager of a user

Every user record within Comindware Tracker has the ""manager"" property which defines just that - the manager of the user in question. You can specify the manager manually or have this field synced with the manager property in your Active Directory. This is not just a static property though, you can pull it up and use it in your workflows and data... Read More


Auto numbering

In order to pre-populate a certain field with the count of all IDs in the current app +1, thus, getting a unique consecutive number for an item (invoice no, request #, etc.), enter the following expression: @prefix cmw: <http://comindware.com/logics#>. @prefix cmwmath: <http://comindware.com/logics/math#>. @prefix math: <http://... Read More


Calculating custom text field values based on values in other fields

In certain cases you may need to automatically compose text field value using text you already have in other fields.  For example, you may need to auto-generate a workflow task title to contain case id, employee name, date of the request and some custom text so all of your tasks are named using the same format. In this particular sce... Read More


Calculating next recurrence date

In order to calculate next recurrence date for a certain item, enter the following expression: Date format: @prefix cmw: <http://comindware.com/logics#>. @prefix str: <http://www.w3.org/2000/10/swap/string#>. @prefix schedule: <http://comindware.com/ontology/schedule#>. {   ?item cmw:schedule ?scheduleId.   ?schedule... Read More


Capturing comments from triggers

In order to capture comment text to pre-populate certain field or to use in an email use trigger of type “On comment addition” and enter the following expression in the necessary activity:  $$contextComment->cmw.comment.value Read More


Conditions for transitions based on limits

Comindware Tracker provides the ability to configure conditional transitions. In particular, it may be useful in the approval processes to determine whether the approval by a specific employee is needed or not. Usually, approval limits for the required set of employees / roles are set up in some other technical application, and the conditions for t... Read More


Configuring the display of the "Date / Time" attribute

In order to customize the display of the date in a certain format (in this example it is “«1» March 2021"), enter the following expression: FORMAT("«{0}» {1} {2}", LIST( DAY($date), IF ( (MONTH($date) == 1), "January", IF ( (MONTH($date) == 2), "February", IF ( (MONTH($date) == 3), "March", IF ( (MONTH($date) == 4)... Read More


Converting attachments into text

In order to convert attachments into text attribute (for example, to get the list of names of these attachments, or to have clickable links to them), enter the following expression: Attachments from current item only (subtasks attachments not included): Link: @prefix cmw: <http://comindware.com/logics#>. @prefix xsd: <http://www.w3.o... Read More


Converting discussion into text

In order to convert all the comments in the discussions tab of an item to a separate text field (for instance, to use for export), enter the following expression:   @prefix cmw: <http://comindware.com/logics#>. @prefix comment: <http://comindware.com/ontology/comment#>. @prefix sort: <http://comindware.com/ontology/dataset/s... Read More