Book Image

Web Content Management with Documentum

Book Image

Web Content Management with Documentum

Overview of this book

One of the world leaders in Enterprise Content Management, the EMC Documentum family of applications helps you manage all types of content across multiple departments within a single repository. With the Web Content Management suite of applications, you can efficiently manage content and underlying processes for your Web properties, and ensures that they are responsive to business needs. To fully realize the power of this system can seem daunting, but this book will help you achieve that. With easy to follow examples, this book will take you the simplest and most straightforward route to success. Along the way, you will learn insights that only a seasoned professional would know. Packed with practical examples, you will get hands-on with the powerful features of Documentum to grow your skills and confidence. You will see tips and tricks to handle complexities of the system, and avoid the common errors that waste your time. From installing and getting started with Documentum, you will see how to design and develop Documentum applications, before rounding off with deployment.
Table of Contents (33 chapters)
Web Content Management with Documentum
Credits
About the Author
Acknowledgements
Preface
Frequently Asked Questions and Answers

11.4 Querying Registered Tables using DQL for Value Assistance


Create a new attribute cust_news_display_order and fill in the General tab as shown in figure 11.29.

Figure 11.29: cust_news_display_order Attribute General tab

This attribute needs to show the drop-down values: 1, 3, 5, 7 if the value of the attribute cust_news_is_press_rel is true and the values: 0, 2, 4, 6 if the value of the attribute cust_news_is_press_rel is false.

This can be achieved by conditional value assistance and using registered tables as follows:

  1. 1. Create a table in the underlying RDBMS as per the following design:

    • Table name: cust_values_table

    • Column 1 (int): cust_odd_values

    • Column 2 (int): cust_even_values

      Insert values for both the columns as shown in figure 11.30:

    Figure 11.30: cust_values_table database table

  2. 2. Log in to Documentum Administrator as an administrator and register the RDBMS table cust_values_table via the following DQL queries:

    register table dm_dbo.cust_values_table (cust_odd_values int,cust_even_values...