This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

cm_history

does anyone have schema documenation for cm_history table?  We're interested in following column definition.

·         History_type

·         Action_number

Parents
  • Verified Answer

    +1  

    Hello. We do not document the Dimensions CM schema and instead encourage users to use the Published Views for any reporting which are fully documented. Is there something you feel is missing from the Published Views to want to query the schema?

    https://admhelp.microfocus.com/dimensionscm/en/14.5.3/online_help/Content/PDFs/dmcm_reports_guide.pdf

  • Suggested Answer

    0 in reply to   

    Thanks for the location of the documentation.

    The type of history entry. Values are 'null' for action, ’A’ for archived, 'D' for delegation, 'E' for extracted, 'M' for merged, 'U' for update, 'C' for create.  Would you happen to know the table name that has this information?  We would like to do a join to pull the information automatically.

    was not clear but, the action number wasn't reference like the history type.  For example, action number 5. Would you happen to know where the action code are stored on a table?

  • Verified Answer

    +1   in reply to 

    The history_type for a request is A for action, D for delegation and U for update. I think you were looking at the item published views rather than requests. Take a look at the description of the pcms_chdoc_history published view. 

    The action_no field details the action number of the request. The action number is incremented whenever the request is actioned from one state to another.

  • 0 in reply to   
    The action number is incremented whenever the request is actioned from one state to another

    does the number go back to 0 or 1 the next day?

Reply Children