CA Service Management

  • 1.  CR Property Values DB Link

    Posted Nov 23, 2018 01:57 PM

    I am trying to see where in SQL the custom Property Values (under the Properties tab) and their responses are linked to the Call Request record. I see in the schema the different fields that identify where they are created and acceptable values; however, I don't see where they are linked to the Request/Incident in the database. Can someone help?



  • 2.  Re: CR Property Values DB Link
    Best Answer

    Posted Nov 24, 2018 06:58 PM

    The table for properties is cr_prp and the linking attribute is owning_cr back to the persid attribute of the call_req table.