Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to display columns in list view

Supriya25
Tera Guru

‎07-06-2023 11:36 AM

Hi all,

we have created data base view between two CSM tables

One is Case table

2nd Investments ( which is extended form Case table)

 

I Created Data base view :  All Cases

Now in All Cases Table List 

I want to show Two tables of all OOB fields and Custom fields in List view. 

 

I'm using case reference filed to dot-walking investment table custom fields, but still not coming , more over Case field showing empty when I added in List.

 

Supriya25_0-1688668428633.png

 

 

How to do this. 

0 Helpfuls
  • 532 Views
1 REPLY 1

Jaspal Singh
Mega Patron
Mega Patron

‎07-06-2023 11:42 AM

Hi Supriya,

How is the custom table related to CSM case table. Do you have a field that captures the CSM case number on the custom table? If so, what is the field?

Assuming it is of type reference you can use

csi.csm_number=csm.sys_id

where csm_number is a field on the custom table that is reference to CSM case table. You need to replace csm_number field accordingly

0 Helpfuls