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
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?
Do you still require assistance on this topic/thread?
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
Retrieving data ...