Change label of column in database view

Neetu2000
Tera Contributor

‎01-01-2024 10:10 PM - edited ‎01-01-2024 10:11 PM

Hello all,
We have one requirement where we need to change column label for database view 
We have created 'Date Fix' field on the case table .
Above field is visible on database view(u_user_cases), but in the database view we want label as 'Date-Fix'.

Is it possible to change column label for database view only?

Any help will be appreciated.
Thank you!!

0 Helpfuls
  • 2,014 Views
7 REPLIES 7

Neetu2000
Tera Contributor
In response to Tai Vu

‎01-02-2024 01:23 AM

Hello @Timi 
I tried above solution but am unable to select table name as name of database view

0 Helpfuls

Tai Vu
Kilo Patron
Kilo Patron
In response to Neetu2000

‎01-02-2024 02:09 AM

Hi @Neetu2000 

Your database view should be there for selection. It's totally fine from my end.

Timi_0-1704190123531.png

 

Can you help to share some screenshot for what you've done to understand the difference?

 

Cheers,

Tai Vu

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron

‎01-02-2024 01:26 AM

Hi @Neetu2000 

 

You can use the variable Prefix

 

LearnNGrowAtul_0-1704187545631.png

 

 

Please have a look OOTB DB:

https://INSTANCENAME.service-now.com/now/nav/ui/classic/params/target/sys_db_view.do%3Fsysparm_nostack%3Dtrue%26sys_id%3D652434f50a0a0b4b00cdc68830f64007%26sysparm_record_target%3Dsys_db_view%26sysparm_record_row%3D7%26sysparm_record_rows%3D98%26sysparm_record_list%3DORDERBYname

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls