How to Create Calculated Fields Using Custom DBFN Function in Smart Reporting |
This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers. AR System administrator can use the AR System JDBC:Generic database functions form to define a database function on the AR System server. The functions can then be used by a Remedy Smart Reporting administrator or a report writer for reporting purposes. In the form, define the database functions by passing arguments to the function and by defining the return type of the function. Only 10 arguments can be included into a function. Note that DBFN is used when creating advanced functions with Freehand SQL option against AR System data as the connection to this information is not created directly to the database. When creating reports based on Smart Reporting repository data (like for Audit Reports) there's a direct connection to the database, hence advanced functions can be used directly without the need of adding "DBFN" in the function syntax. Perform the following steps to define a function in Remedy AR System server for a particular database:
5. To make use of this function in Smart Reporting, create a Free Hand SQL Calculated field and define the function as below: |