Open topic with navigation

TIBCO® BPM Enterprise 5.5.0

# Conventional Database View of a Case Type

In TIBCO BPM Enterprise, it is not always necessary to create a database view of a case type. A database view named "cdm_cases" already exists for the case manager. This lists the cases for different case types created in the TIBCO BPM Enterprise.

The cdm_cases view has the following columns:

Columns | Description
--- | ---
case_identifier | an identifier for a given case
casereference | reference for the case with version
unversioned_casereference | reference for the case without version
type | case type for a given case
version | version for a given case
state | current state for a given case
casedata | data associated with the case
is_active | whether the case type is active
creation_timestamp | time of creation of the case
modification_timestamp | time of modification of the case
completed_case_duration | total time elapsed from the start of the case to its completion
application_name | name or label for the deployed application
application_id | unique id for the deployed application
application_version | the version of the deployed application

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO® BPM Enterprise

Copyright © 2015-2024. Cloud Software Group, Inc. All Rights Reserved.