In Xeelo platform, you can reach the issue that you want to get data from request into Notification, Printout, Message or Descriptive Memo (into HTML editor). For this purpose platform contains placeholders that provide such a functionality. There is nothing to set except just type the placeholder into the editor.
Format placeholder
Placeholder | Description |
---|---|
{idXXX} | current value of provided object line will be returned. |
{idXXXp} | this placeholder will return previous value of provided object line. More precisely value of previous version of request (before update was made). |
{idXXXv} | returns value of a reference (Value - Name). Usage only in Combo-box |
{NextUserName} | currently assigned users |
{PrevUserName} | user performing current workflow action |
{RequestLink} | HTTPS link to request |
{Today} | current date |
{TodayTime} | current time |
{TodaySerial} | current date in serial format YYYYMMDD |
{TodayYear} | current date's year in format YYYY |
{TodayMonth} | current date's month in format MM |
{RequestorID} | requestor user ID |
{RequestorName} | requestor user name |
{RequestorLogin} | requestor login |
{RequestorAssigned} | value 1 in case request is assigned to requestor, otherwise value 0 |
{RequestorEmail} | return requestor e-mail |
{RequestorLanguage} | return requestor language |
{NotAssigned} | value 1 in case request is assigned to someone, otherwise value 0 |
{ObjectName} | name of current request object |
{CompanyName} | name of current request company |
{ObjectTypeName} | name of current request object type |
{RequestID} | current request ID |
{RoleName} | current request role name |
{RequestStatus} | current request status name |
{RequestState} | current request state according to Workflow step (status property): Completed, Cancelled or InProgress |
{RequestType} | current request type name (create, update or update empty) |
{RequestPriority} | current request priority name |
{ObjectDefaultID} | current request template id |
{ObjectDefaultName} | current request template name |
{ObjectUpdateActionID} | id of initiated update action |
{ObjectUpdateActionName} | name of initiated update action |
LastActionDate} | date and time of last workflow action for current request |
{CreatedDate} | creation date of current request |
{ModifiedDate} | modification date of current request |
{RequestTag} | new / overdue tag of current reuqest |
{ActionDuration} | duration in minutes between current and previous workflow action |
{TimeInCurrentStep} | duration in minutes in curren step |
{ModifiedByID} | user ID of last modifier |
{ModifiedByName} | user name of last modifier |
{CreatedByID} | user ID of request creator |
{CreatedByName} | user name of request creator |
{LastWorkflowUserID} | last workflow action user ID of current request |
{LastWorkflowUserName} | last workflow action user name of current request |
{LastActionName} | last workflow action name |
{LastActionID} | last workflow action ID |
{LastRoleName} | previous role name of current request |
{LastRequestStatus} | previous status name of current request |
{AssignedUserName} | list of user names currently assigned to request |
{AssignedUserID} | list of user IDs currently assigned to request |
{RequestorLogin} | |
{RequestorEmail} | |
{RequestorLanguage} | |
{RequestorAssigned} | |
{RequestState} | |
{LastRoleName} | |
{LastRequestStatus} | |
{LastComment} | |
{SubLineNext} | returns next subline number in SG according to current count of sub lines |
{id%[0-9]} | |
{OwnerUserID} | |
{OwnerUserName} | |
{WatcherUserID} | |
{WatcherUserName} | |
{Variable,%} | |
{LastComment} | last comment of current request |
{ObjectDefaultID} | template ID of current request |
{OwnerUserID} | owner ID of user assigned in current request |
{OwnerUserName} | owner name of user assigned in current request |
{WatcherUserID} | watcher ID of user assigned in current request |
{WatcherUserName} | watcher name of user assigned in current request |
{Variable,[Variable code]} | general variable |
{TempCalc,[Temporary calculation ID]} | temporary calculation value |
Format HTML placeholder
Placeholder | Description |
---|---|
{BarCode,[Object line ID],[type of code]} {BarCode,[Object line ID],[type of code],[width],[height]} Default width is set to "2" and default height is set to "60". | inserts a barcode regarding provided object line (numerc, alphanumeric) and defined type of code: Sources: http://www.barcodeisland.com, https://www.idautomation.com |
{RequestSubGridNoHeader,[Width],[Object line ID],[idXXX],…,[idZZZ]} | inserts the table with sub-grid details for specific object line with selected object sub-grid lines. Sub-grid table without header
You can set height (2/3) or width (60/100) of barcode. Both values are constants. |
{RequestSubGrid,[Width],[Object line ID],[Sub-Grid idXXX],…,[Sub-Grid idZZZ]} | inserts the table with sub-grid details for specific object line with selected object sub-grid lines. Sub-grid table with header |
{RequestSubGridTotal,[Width],[Object line ID],[Sub-Grid idXXX],…,[Sub-Grid idZZZ]} | sub-grid with header and total. This placeholder will display subgrid details with one extra row (in bold) with totals. |
{ReportResult,100, XXX} | Placeholder inserts the report result according to its definition. XXX is ID of report result |
{RelationGrid,[Width],[Object ID],[idXXX],…,[idZZZ]} | table with the list of related object requests. Inserts the table with requests that are in relation with current request for specific object and selected object lines. |
{RequestDetail,[Width],[idXXX],…,[idZZZ]} | table with details of the request. This table is shown regardless the visibility set-up in Workflow or Object.
idXXX,…,idZZZ - list of object lines where XXX,…,ZZZ is the list of IDs. In case no ID is provided then all lines will be shown. |
{RequestDetailFilter,[Width],[idXXX],…,[idZZZ]} | similar function as above with exception that it provides only non-empty data or data that are changed (in case of update request). idXXX,…,idZZZ - list of object lines where XXX,…,ZZZ is the list of IDs. In case no ID is provided then all lines will be shown. |
{RequestCommentsNew,[Width]} | table with comments added since last workflow action. Inserts table with request comments added since last comment notification was sent. This notification have to be set-up in Scheduler for each object separately. |
{RequestCommentsPrev,[Width]} | table with comments added before last workflow action. Inserts table with request comments for which comment notification was already sent. |
{RequestComment.[Width]} | table with all comments. Inserts table with all request comments ordered chronologically |
{RequestWorkflow,[Width]} | table with request workflow history |
{ProgressBar,[Height],[Label],[Value or Object line ID],[Color or Object line ID]} | progress bar |
{Condition,[Condition],[True statement],[False statement]} | inline condition (online for Printout). The first parameter in brackets must be always the word Condition!
Syntax is almost the same for string and number, except the quotation marks:
|
{Condition2,[Condition ID],[Condition]}{Condition2Else,[Condition ID]}{Condition2End,[Condition ID]} | statement condition (online for Printout). Condition ID is the identifier of the condition. It is highly recommended to change the identifier for different conditions!
|
**Only for notification additionally** | |
{RequestOfflineActions,[Width]} | list of workflow offline actions. This function inserts the block with workflow offline action that can be used in the email approval. Please ensure that offline actions are allowed in the Workflow and proper authorisation level is setup in System settings. This function can be used on for single request notifications. It must be set on WF step. |
{RequestOfflineActionsWithRequestLink,[Width]} | list of workflow offline actions with link to request. Enhancement to workflow offline actions allows to add additional “action” called Request detail to be used in the email approvals, which opens the particular request. It must be set on WF step. |
Tip: Attachment preview can be now displayed in various placeholders that display Request/SubGrid details, detailed info here
Format Summary placeholder
Placeholder | Description |
---|---|
{Variable,[Variable code]} | general variable |
{RequestGrid,[Width],[idXXX],…,[idZZZ]} | table with list of requests. This function can insert the grid with multiple requests with link to each individual request. It can be used only for request summary notification type. |