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.
In a report, identify the cell of BODY > TABLE > ROW where you want to use the operator and make the cell text.
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.
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.
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.
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.
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.
OPERATOR_COLUMNS
OPERATOR_NAME
In the Cell > Properties > Advanced tab, locate the two properties:
In OPERATOR_NAME, type the name of the operator. For example, FormatPersonFullName
In OPERATOR_COLUMNS type the names of the parameters, in the order described in the table, and separated by columns. For example, FormatPersonFullName requires First Name, Last Name, and MI in that order. If, in the binding, they are FNAME, LNAME, and MI, then type FNAME:LNAME:MI in OPERATOR_COLUMNS
In Event handler class, type: com.plateau.common.reportservice.impl.PlateauTextItemEventHandler
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.
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 Name | Parameter Type |
|---|---|
| firstName | String |
| lastName | String |
| middleName | String |
Return Parameters and type
| Parameter Name | Parameter Type |
|---|---|
| fullName | String |