Can I extract a list of all custom fields in a configuration?
Yes, this is possible via SQL code.
The CFIELDS table holds all the user defined custom fields.
USR_ denotes these fields, so a custom query such as the one below
will extract the count of all the fields.
SELECT COUNT(STNAME) AS "custom fields"
FROM CFIELDS
WHERE (STNAME LIKE "%Usr_%")
If you need to return the names of the custom fields, you run
the following code:
SELECT STNAME
FROM CFIELDS
WHERE (STNAME LIKE "%Usr_%")
Support
Documentation
Learning Services
Partner Programs