CA Service Management

  • Private Community

  • 1.  Location column in Xtraction not giving readable value

    Posted Dec 19, 2018 07:43 AM

    Hi Xtraction team

     

    I have added Location Column named as Region in xtraction dashboard for incidents but the data is coming in different format and cannot be readable.Please help me where is the issue

     

     

     

     

     

     



  • 2.  Re: Location column in Xtraction not giving readable value

    Broadcom Employee
    Posted Dec 19, 2018 07:49 AM

    Hi Asim,

     

    I am not sure about the exact root cause from the screenshot. However, I suspect the underlying table relationship/ column type link to the web page is in appropriate.

     

    You may want to go though this community link for Xtraction customization. Let me know if that was of some help?

     

    https://communities.ca.com/thread/241794133-xtraction-dashboard-customization



  • 3.  Re: Location column in Xtraction not giving readable value

    Broadcom Employee
    Posted Jan 03, 2019 11:14 AM

    Sikander-lasani........

    Do you still require assistance on this topic/thread?



  • 4.  Re: Location column in Xtraction not giving readable value
    Best Answer

    Posted Jan 03, 2019 11:41 AM

    Since ZREGION is a relation table, you need to create a new table in xtraction to reference the LOCATION LIST, make sure to map primary key and name. Also make sure to check "list, filter, groups and other wanted attributes".

     

    You can then MAP the foreign key on REQUEST table, create a left join between request.foreign_key to location_list.primary key.

     

     

     

    To understand, just take a look at how ASSIGNEE is mapped.

     

     

    And to be honest, you should take SQL courses. You clearly don't understand how a relational database works and it will facilitate your life if you have to work with Xtraction and SDM