What is the best way to show two serviceNow tables in one table

chanukaV
Tera Contributor
  1. 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.

  2. 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.

 

11 REPLIES 11

AndersBGS
Tera Patron

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

 

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?

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

Hi @AndersBGS,

Can you please respond to the questions below? I frequently need to use a database view to show details to the customers.

  1. If there are 1,000 - 2,000 records in a table, would you recommend using a database view?
  2. If there are 2,000 - 4,000 records in a table, would you recommend using a database view?
  3. If there are 4,000 - 7,000 records in a table, would you recommend using a database view?
  4. If there are 7,000 - 10,000 records in a table, would you recommend using a database view?