1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

DB Column for Default Severity for SR template

Discussion in 'Oracle CRM' started by M_Anas_O, Dec 23, 2009.

  1. M_Anas_O

    M_Anas_O Forum Advisor

    Messages:
    95
    Likes Received:
    9
    Trophy Points:
    160
    Location:
    Austria
    Hi,

    Does anybody know where is the Default severity for a SR template stored in Database?
    I mean which table and which column.
    I checked these tables but could not figure it out.
    CS_TP_TEMPLATES_B
    CS_TP_TEMPLATES_TL
    CS_TP_TEMPLATE_ATTRIBUTE

    Regards,
    Mohammed
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    Hi

    Why do you want to find the DB column for Default severity? Sadly, I tried but could not locate it myself too. However I am sure you are aware that From the iSupport Administrator - JTF Administration-->Administration -->Support, when you open a template, you can configure the default severity.
     
  3. M_Anas_O

    M_Anas_O Forum Advisor

    Messages:
    95
    Likes Received:
    9
    Trophy Points:
    160
    Location:
    Austria
    Yes, I am aware of the setup.
    I want to write queries to extract all SR template setups from one instance.
    I could map all other fields except this one.

    So still looking for this mapping in DB.