Database Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
Anybody have any idea how to make the last 2 tables in my database views as unique records? So I have sn-hr_core_case table, question_answer and sc_multi_row_question_answer inside the database view. The last 2 tables reference sn_hr_core_case but I want to get unique records for each and not join them. What happens is I have 11 expected records in question_answer and 6 expected records in sc_multi_row_question_answer for an HR case but in database view I'm getting 66 records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11m ago
that's OOTB thing.
see this link
database view showing duplicate records
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
