Functional Field for Display Value

Ankit Singh4
Tera Contributor

‎07-20-2023 04:36 AM

Hi Experts,

 

I am using functional field in my report to get time on hourly basis as I can't use time series for my report. I have used below substring to get hour and return type is whole number.

glidefunction:substring(sys_created_on,"12","2")

 Now, the problem here is it is giving me hours as 2,3,4,5....22,23 which is system hour of sys_created_on so when I click the total count in report it redirects me on list view of table where created time showing different because it is taking the display value of logged in user time zone.

I am looking for the solution where I can get the display value of functional field substring. Even though I tried to add getDisplayValue and other script there but no luck.

Please suggest.

0 Helpfuls
  • 569 Views
1 REPLY 1

Ankit Singh4
Tera Contributor
In response to rick5050

‎07-20-2023 05:44 AM

Hi Rick,

 

Thanks for your response!!

Agree, on your suggestion but when I create a custom field which stores the display value of sys_created_on field and then I use the same substring for custom field on report with the help of functional field but it is giving me empty. No hours display.

Any thought on this?

Thanks,

Ankit Singh

0 Helpfuls