smoServer functions are extended functions used to perform different actions and calculations in process steps (workflows and business rules).

Notes

• The names of functions are not case-sensitive.

  example  getSLADelay and GETSLADELAY are identical

• Dates and service hours:
  • Are stored in Universal Time (UT  = GMT + 0:00).
  • Are displayed in the interface in local time based on the location of the logged-in user.
  • Must be expressed in Universal Time (UT  = GMT + 0:00) if they are hard-coded.

Caution

• To avoid updating the entire database inadvertently, and to restrict processing to the current object, a WHERE clause is automatically added in certain cases when this clause is not present in the SQL instruction.
  • Remember to always add this clause manually because it is only added automatically in specific cases.
  • The presence of duplicate WHERE clauses will not generate any error in the system.

Best Practice

• You should always use the syntax below when using a smoServer function in a SELECT instruction.
  SELECT {@ smoServerFunction(parameters) @}
  FROM <TableName>
  WHERE ...

• To identify the current object, you can either use the @ID@ or the @@ID@@ instruction.

• To retrieve the result of the SELECT instruction, use an instance variable.  See the graphic process editor.
  • The result is retrieved via a tag in the following format, #[VAR.My_Variable]#.
  • Based on the type of instance variable, quote marks may be required.
    • Alphanumeric variable or date: Surround the tag using quote marks.
    • Numeric variable: No quote marks required.

List of functions

• getSLADelay:  getSLADelay(Start_Date, End_Date, SLA_ID, Location_ID)

• calculateMaxResolutionDate:  calculateMaxResolutionDate(Request_ID, Submit_Date, SLA_ID, Location_ID)

• getQuestionResult:  getQuestionResult(Question_ID, ID, TableName, Language_Abbr)

• smo_Tree_Get_Path:  smo_Tree_Get_Path(TableName, ID, Separator, IDonly, IfDomain, BeginLevel, EndLevel)

• smoAddTime:  smoAddTime(DateTime, Working_Hours_ID, Increment, Location_ID, SLA_ID)

Procedure: How to use a smoServer function in a process

     See the graphic process editor.

UseFunctionInProcess_Procedure

EndUseFunctionInProcess_Procedure