Defined Related List from multiple tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2016 11:48 PM
Hello,
I have the following setup
On Request Item, I have a field called "Completed by change"
On Incident Table, I have a field called "Caused by Change"
On Problem Table, I have two fields called "Resolved by change" and "Caused by change"
Now I have two create Two related lists called "Items Caused by Change" and "Items Resolved by Change" and show up the above tasks
I am not sure how to created a related list from multiple table, like the "Items Resolved by Change" on change table should show up the Request item and the Problem records that are related to the change under this related list
Any help please:(
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2016 11:59 PM
Hi Padmini,
You can define Relationships (System Definition -> Relationships), and as an example see one out of box called 'Change Requests',
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-18-2016 04:51 PM
With relationships I can only refer data from one table. But here I am looking to get data from multiple tables under one related list
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2016 11:59 PM
You can create a database view and use this database view to create "Related list". Your view should be like below.
select <required cols> form incidents table where <your filter>
UNION ALL
select <required cols> form views table <your filter>
Then you can use this view in "related lists".

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-18-2016 12:27 AM