Oracle WebCenter Content (MOSC)

MOSC Banner

UCM Adding columns to revision_history

edited Dec 8, 2014 11:01AM in Oracle WebCenter Content (MOSC) 8 commentsAnswered ✓

Hi,

We need to store more revision specific data. At this time we get this:

               <ns2:ResultSet name="REVISION_HISTORY">
                  <ns2:Row>
                     <ns2:Field name="dFormat">application/pdf</ns2:Field>
                     <ns2:Field name="dInDate">12/4/14 11:01 AM</ns2:Field>
                     <ns2:Field name="dOutDate"/>
                     <ns2:Field name="dStatus">RELEASED</ns2:Field>
                     <ns2:Field name="dProcessingState">Y</ns2:Field>
                     <ns2:Field name="dRevLabel">7</ns2:Field>
                     <ns2:Field name="dID">7607</ns2:Field>
                     <ns2:Field name="dDocName">WCC_CLUSTER-006401</ns2:Field>
                     <ns2:Field name="dRevisionID">7</ns2:Field>
                     <ns2:Field name="dDocAuthor">EAD V2.0</ns2:Field>
                  </ns2:Row>

We need to add a couple fields here so that they will be specific to each revision. We found it easy to add metadata or to add new fields and views to the top level (doc_info) container but haven't been able to figure out how to add columns and views to the rows in revision_history.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center