Happy New Year everyone!
The application I support allows clients to create "custom" fields which do not reside within the pre-built Cognos packages (and we do not get access to the packages)
We are provided with this example SQL script to pull the custom fields clients have configured, and each set of fields are tied to a "normal" table in the database.
My question is; is there a SQL script to pull all such tables (like the one in bold below)? I am trying to report on some specific data and not able to find it without knowing the name of the tables.
SELECT
*
FROM
fn_MP_CustomFields_EmpComp (#sq ($account.parameters.UserContextID)#, #sq ($account.parameters.USER_TYPE)#, NULL,NULL)