How to do table union via database view

[charity_s]

Hi all,

Would like to check how can i unite a few tables using Database View. Basically i wanted to use Task table to extract all tickets. But since not all information is capture by Task table i need to unite it will other tables.

Goal: Report on all Catalog Tasks, related RITM ticket number and location/region of the requested_for user

Table structure:

Request - Requested Item (one to many)

Requested Item - Task (many to many)

1. Task (sc_task) - child ticket of RITM. all tickets (Requests > Requested Item > Catalog Item)

2. RITM (sc_req_item) - child ticket of Request. includes Requested_For filed but reference to Request table (request) 

3. Request (request) - includes information on Requested_For

4. User (sys_user) - includes the location/region of Requested_For

Did a few table connection but no luck, please advise:

[Jane Stone]

You should be able to get this as a report through the Reporting application. You will need to start with the Task table and then dot-walk to the RITM and REQ, and then from the REQ dot-walk to the requested-for's location.

[charity_s]

Thanks,

I was able to make it work in database view and then create the reports from reporting function. 

[maokaiyue]

Could you please share the method of table union via database view