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

[chanukaV]

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.

[AndersBGS]

Hi @chanukaV ,

It depends on the case value and not the count of records. It is better to do a dot-walk than a database view if possible. If you can't avoid a database view, then limit the data as much as possible so performance is not impacted. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[chanukaV]

Hi @AndersBGS ,

    Sorry I didn't get the meaning of "case value". can you explain this?
 

[AndersBGS]

Hi @chanukaV ,

Sorry - not case value but just case. I just meant that it depends on the single use case according to what would be the recommendation.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[AndersBGS]

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[guruprasadm]

Hi

For requirement 1: You can create a Database view with both tables matching common fields and show table columns in the portal with "https://instance_name.service-now.com/sp?id=list&table=Database_view_table_name.

For 2nd requirement: you can try creating ACL to display relevant records to a specific customer based on customer value on the record.

Regards
Guru

[chanukaV]

Hi @guruprasadm 

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?