Previous Topic: Example SPsNext Topic: Utilities


Standard SQL Helper Functions

To assist with the development of iConsole searches a library of helper functions is provided. These functions are grouped into collections of related functions with names beginning with WgnWC_.

On Oracle systems these are implemented as Oracle packages so a function call has the form WgnWC_Group.FunctionName

On SQL Server systems there is no equivalent of the Oracle package, so the package name is added as a prefix to the function name along with an underscore. A function call has the form WgnWC_Group_FunctionName.

This section contains the following topics:

Utilities

Logging

Constraints on Custom Searches