Using Report Operators

Talent Management Operators are functions that you can call to handle report tasks such as formatting dates, looking up locale information, and calculating data. All report operators for your system are defined in the REPORT configuration file in System Admin > Configuration > System Configuration.

Like the Talent Management query shortcuts of filtering, security, and order-by, you must import reports to Talent Management in order to test Operators. This is because the operator code is on the server and not in the Plateau Report Designer.

The list of operators is available in the Reporting SDK document.

Calling Operators

  1. In a report, identify the cell of BODY > TABLE > ROW where you want to use the operator and make the cell text.

  2. Find the operator you want to use in the Reporting SDK document and note its inputs and their order. Order is important. These instructions use the example of FormatPersonFullName, which requires the parameters: First Name, Last Name, and Middle Initial of users' names.

  3. If necessary, modify your query to select the inputs necessary for the operator. For example, if you hadn't already selected the name parameters (first, last, and MI) necessary for FormatPersonFullName, do so now. Remember to test your query.

  4. If necessary, modify the binding on the table to bind the inputs as selected to the inputs as used in the table. For example, if you select first name as FIRST_NAME but you want to bind it to FNAME, do so in the table Binding tab.

  5. In the Outline, go to the cell you set aside for the operator. It should be type text. You can call the text something that makes sense to you. It does not have to be the operator name. For example, formattedUserName.

  6. In the Cell > Properties > User Properties tab, add the following properties. The first will contain the parameters to pass, and the second will contain the name of the operator. Both are strings.

  7. In the Cell > Properties > Advanced tab, locate the two properties:

To fully test filtering, you must import the report to Talent Management. When it is unpublished, you can troubleshoot it, but it will not be accessible to most users.

FormatPersonFullName

The following is an example of a report operator. You can read about others in the Reporting SDK. There are too many to list here.

Given the names of a person (first, middle initial, and last), returns the full name, formatted according to label format.LastName.FirstName.MI in the user’s locale.

Input Parameters and type

Parameter NameParameter Type
firstNameString
lastNameString
middleNameString

Return Parameters and type

Parameter NameParameter Type
fullNameString