required help @Vasantharajan N @Ankur Bawiskar
As I need to created a database view for the mentioned tables.
1.) interaction_related_record
2.) sn_customerservice_case_its
And all the fields in the " sn_customerservice_case_its" table need to be available.
Based on this I had created a database view as mentioned below
Database View Table: u_end_user_status
Only it is showing count not the records
your join is wrong
I assume "sn_customerservice_case_its" is table extending "sn_customerservice_case" table
So use this
-> task field on interaction related record table holds Task Info so in this case it will hold Case info
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
your join is wrong
I assume "sn_customerservice_case_its" is table extending "sn_customerservice_case" table
So use this
-> task field on interaction related record table holds Task Info so in this case it will hold Case info
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
@Arjun Reddy Yer - As Ankur mentioned,
- You need to first update the "Where clause" and "Variable Prefix" for each table you included to create the DB view
- Add the fields from each table ("View Fields" related list) that you wanted to view in the DB view
Check you have the read access for both tables. The record not visible in the list but shows the row count refer to the article link given below,
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0997137
