Database Views

MPNSC
Tera Contributor

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

1 REPLY 1

Ankur Bawiskar
Tera Patron

@MPNSC 

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! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader