Follow

Info: Where are the Certificate custom fields stored in the Database?

Question:

Where are custom fields stored in the Database? Is there a way to track who created them or when?

Answer:

They are in Config_Objects under the Metadata Root:

SELECT * FROM config_objects where parent = '\VED\Metadata Root'

With a little creativity, we can find out what each of these are called and when they were created:

Select cc.AttributeValue, co.CreatedOn
from config_contains cc join config_objects co on cc.objectID = co.id
where co.parent = '\VED\Metadata Root' and cc.Attribute = 'Label Text'
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments