I’m trying to find datastore information and their configurations, especially the default configuration from the metadata tables/views. Any help would be appreciated!
jrox (BOB member since 2013-01-29)
I’m trying to find datastore information and their configurations, especially the default configuration from the metadata tables/views. Any help would be appreciated!
jrox (BOB member since 2013-01-29)
I should read the post better and then reply…
Johannes Vink (BOB member since 2012-03-20)
AL_LANG Table of Object Type 5 represents the Datastore. However I am not so sure on where the different config of that exist!
ganeshxp (BOB member since 2008-07-17)
Only place that I can find is in the xml tables (not the nicest place to get the info from):
SELECT *
FROM AL_LANGTEXT
WHERE PARENT_OBJID IN (
SELECT OBJECT_KEY FROM AL_LANG
WHERE OBJECT_TYPE = 5
AND NAME <> ‘CD_DS_d0cafae2’
)
ORDER BY 1, 2
;
With a filter you can find:
<DSConfiguration default=“false”
or
<DSConfiguration default=“true”
Johannes Vink (BOB member since 2012-03-20)
That’s great, thanks for the example. As you said it’s not the nicest way but with some hardcore string functions I’ll probably be able to pull out the necessary information
jrox (BOB member since 2013-01-29)
I look for Datastore information in al_langtext. Here is a post I just made with code to parse out the subject matter from al_langtext, specifically for Datastores: https://bobj-board.org/t/217379/1.
eganjp (BOB member since 2007-09-12)