14.34.1 Adding Views

To add views, follow these steps:

  1. Make an entry in the KDD_QUEUE_MASTER table.

    Table 14-6 KDD_QUEUE_MASTER table

    QUEUE_SEQ_ID QUEUE_CD QUEUE_DISPLAY_NM QUEUE_TYPE
    Unique sequence ID Unique Queue Code The name of the view that will be displayed in the UI ECM: If the view is related to Cases
  2. Make the entries in the KDD_QUEUE_FILTER table for each filter for respective views.

    Table 14-7 KDD_QUEUE_FILTER table

    QUEUE_SEQ_ID ATTRBT_ID ATTRBT_VAL_TX
    Unique sequence ID Unique Attribute ID. ATTRBT_ID will be referred from KDD_CASEATTRBT_M ASTER This Attribute value is the actual value used for the attribute of filter. In this, you can give hardcoded values (for example, put a filter condition on the status attribute for the cases which are in New status). The possible value for this is, NW. You can also specify session attributes for your filter. The session attributes are enclosed in curly brackets {}. For example: {userSeqId}, {userPool} You can define the SYSDATE value for the filter. Date filter requires the following two inputs:
    • From Date
    • To Date
    For example: #NS#, #SYSDATE# You should specify the date values in enclosed # Use #NS# to mention the date filter as blank.
  3. Map Queue in the KDD_QUEUE_ROLE_MAP table.

    Table 14-8 KDD_QUEUE_ROLE_MAP table

    QUEUE_SEQ_ID ROLE_CD
    Queue sequence id as given in the above table Role code