Adding Database Functions

Using Predefined Database Functions describes all of the IBM OpenPages with Watson database functions that have been exposed to the report author. There are three key functions that you will need to use:

OP_ACTOR_MGR.GET_DISPLAY_NAME

Used to convert userIds to the actual user names.

OP_RPS_AUX.CONVERT_EVID_TO_NAME

Used to convert a single select enumerated string to its text.

OP_RPS_AUX.CONVERT_EVIDLIST_TO_NAME

Used to convert a multi-select enumerated string to a comma separated list of text.

After you create your SQL statement, you will be able to see in the result sets which items are return as IDs and which are returned as text. You will need to convert the strings returned as IDs to readable text to make your report useful. You should verify that the fields you are converting are actual enumerated strings by clicking Administration > Object types and searching the fields on the individual objects.

The GET_DISPLAY_NAME function is used (based upon the requirements of your particular organization) to show user names in reports as opposed to the login name.