OnDemand User Group

Support Forums => MP Server => Topic started by: yousuf_gani on April 20, 2017, 10:05:08 AM

Title: DOC_TYPE and FIXED_VIEW fields Value from ARSAPP table
Post by: yousuf_gani on April 20, 2017, 10:05:08 AM

Hi,
I need to Query(Oracle Ondemand table ) for the following info
- APPLICATIONs DOC_TYPE and the
- Format (EXTENSION=) from FIXED_VIEW filed if "USER-DEFINED" is Doc_type

I tried from the ARSAPP table I see the DOC_TYPE has the HEX_CODE and FIXED_VIEW is CLOB type

Any Conversion / SELECT query routine to get the Actual DOC_TYPE and EXTENSION detail from this Tables fields.?

Please do the needful help...

Title: Re: DOC_TYPE and FIXED_VIEW fields Value from ARSAPP table
Post by: Norbert Novotny on June 16, 2017, 05:51:35 AM

Hi Yousuf,
This is not a complete answer to your question but could help:

Code: [Select]

ARSAPP.DOC_TYPE
--------------------
41 = AFP
4C = line
42 = BMP
47 = GIF
50 = PCX
54 = TIFF
52 = PDF
4A = JFIF/JPEG
51 = PNG
4D = Metacode
55 = User defined
4E = None
Reading CLOB you can just select with cast, most of CMOD CLOB are relatively small in size.
Parsing the CLOB read the ORACLE reference for regex.

Hope this helps,
 N.

Title: Re: DOC_TYPE and FIXED_VIEW fields Value from ARSAPP table
Post by: yousuf_gani on June 16, 2017, 06:28:44 AM

Thanks you so much Norbert...
I will try with the SQL to get required Data from the OD - Oracle Table based on the mapping HEX code.

Title: Re: DOC_TYPE and FIXED_VIEW fields Value from ARSAPP table
Post by: Justin Derrick on June 19, 2017, 09:15:03 AM

Check out the wiki if you want to learn about IBM CMOD database tables... https://cmod.wiki/index.php?title=Content_Manager_OnDemand_Database_Tables

-JD.