CA Service Management

  • 1.  I need a query with the answer of the case?

    Posted Apr 18, 2018 04:55 PM

    I need a query with the answer of the case



  • 2.  Re: I need a query with the answer of the case?
    Best Answer

    Broadcom Employee
    Posted Apr 18, 2018 04:56 PM


  • 3.  Re: I need a query with the answer of the case?

    Posted Apr 18, 2018 05:05 PM

    I need to know which table stores the user's response



  • 4.  Re: I need a query with the answer of the case?

    Broadcom Employee
    Posted Apr 18, 2018 05:28 PM

    John, do you mean the survey answers? Thanks _Chi



  • 5.  Re: I need a query with the answer of the case?

    Broadcom Employee
    Posted Apr 19, 2018 11:32 AM

    John,

     

    I updated the earlier Communities post with information that I think may help you.  The "answer" value you are asking about is stored in the activity log table (act_log table) and I specified a basic query there that should provide you with the information you are seeking.



  • 6.  Re: I need a query with the answer of the case?

    Posted Apr 19, 2018 11:42 AM

    thank you very much for your help in the query