How to write clauses to merge 4 tables in database view
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2025 08:37 AM
I want to merge idea demand story and label entry tables for database view. I have create where clauses as shown in screenshot however its not working. Please let me know anything to update ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2025 09:28 PM
There is some OOB database view already present in the system for three tables like change_request_metric .
Check that as the reference point to work on your case.
Also below link shows similar case of four tables check that , it will be good reference point for you.
I hope this helps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-27-2025 11:10 PM
Hi @Ct111
Good Morning
I have same requirement. But which you provided link is only 3 tables. If possible Could you please provide me where clauses code for 4 tables?