How can we add field from other tables in "Ticket Fields" widget?

Narayan K · Wednesday

Hi there,

I want to add field from "task_sla" table to "Ticket Fields" widget.

for example " Business Time left".

Thanks!

Ankur Bawiskar · Wednesday

@Dr Atul G- LNG

I agree that SLA information is not necessary for end users on portal.

But the requirement is achievable and I was able to achieve that.

The link I shared simply tells the server side script which needs to be enhanced and would help person with developer skills to know what change and where change is required.

@Narayan K I was able to show that, see below

Output:

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Ankur Bawiskar · Wednesday

@Narayan K

check my above response.

I was able to achieve and show business time left for the INC in Tickets Field widget.

You will have to play around in the server side and add the value in the JSON object using GlideRecord which then will be rendered by System automatically.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader