What is the best way to show two serviceNow tables in one table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-13-2024 03:40 AM
My requirement is as follows: I need to retrieve fields from two tables and display them in a single table on a ServiceNow portal. It's not necessary to obtain all fields from the two tables; I only need to select some fields from both. To make the connection between the two tables, I have to match two fields that are not sys_id fields.
Another requirement involves filtering records to display only those that are relevant to a specific customer. It's hard to use default filter in ServiceNow to complete my requirement.
Please suggest the best way to accomplish these tasks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-13-2024 04:55 AM
Hi @chanukaV ,
To combine the two tables you need to utilize a database view even though sysid is not utilized. According to the filtration of records it's really depending on the use case.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-13-2024 09:10 PM
Hi @AndersBGS
If one of the tables has lots of records, it may reduce the performance of ServiceNow, right? Can you suggest any other way to complete my task?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-14-2024 05:25 AM
Hi @chanukaV ,
I would still recommend the database view - just limit the column selection. See the product documentation here: https://docs.servicenow.com/bundle/utah-application-development/page/use/reporting/concept/c_Specify...
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-18-2024 06:04 AM
Hi @AndersBGS,
Can you please respond to the questions below? I frequently need to use a database view to show details to the customers.
- If there are 1,000 - 2,000 records in a table, would you recommend using a database view?
- If there are 2,000 - 4,000 records in a table, would you recommend using a database view?
- If there are 4,000 - 7,000 records in a table, would you recommend using a database view?
- If there are 7,000 - 10,000 records in a table, would you recommend using a database view?
