Hi Experts,How to covert UTC date and time to my local date and time.UTC date and time - "2023-04-07 06:25:31"Locat date and time - "07-04-2023 14:25:31"system time format- HH:mm:ssSystem date format- dd-MM-yyyySystem timezone- Australia/West Any lea...
How to attach images on additional comments (journal field)?
I have a requirement to create a report on change request table for planned start and planned end date.The planned schedule start and end date changes every week. Planned schedule start : Monday to Sunday of the current week and end date is at or aft...
am trying to get the number of re-opened tickets for the month of February. And also, with the user IDs, who has worked on those.i tried to do with thebelow Definition is MRIM AssignedTo Value is one of << user1, user2, user3 >> but its showing me...
Hi Team, My Inbound email attachment is not automatically attaching to its related records.After investigating I was able to find that in the sys_email logs table the 'email attachments' related list has all the attachments stored but the action fie...
Hi all,I have created the below database view and need some help with the where clauses. The requirement is to view all security incidents Opened by "x" . It should contain information on the user that is assigned to this incident. and also should...
Hello All, I need to make the State field on change_request tickets editable only by the admin when in a list view. Right now, it's blocked even as an admin... I was able to get that to editable for the change_task tickets by adjusting some ACLs, b...
if i am using " g_form.disableAttachments" I am getting this error : in portal it was saying : g_form) [DEPRECATED] Method disableAttachments is deprecated and unsupported on mobilecan any one suggest me what is the best way to do
Hi all, I was wondering whether this was possible - I'd like to be able see how many related problem tasks there to each problem (like the related incidents field in Problem) I've created a database view that links problem ID to problem task but the ...
Hi Team, I have one custom catalog form called "abc", and having one variable "Requested for(u_requested_for)" while submitting the form I have changed the Requested for to another name "Rahul" Opened by name is "Jessy" but While opening my Request r...
Hi All, I want to make Header in Bold. I have created it as of Label Type and I am not able to make it bold and big. Could any one please help me in making this text bold. Below is the screenshot for the reference. customization is header here. I wan...
Hi,Could any one help me on this!! When i try to edit the start and end date of the existing change request, corresponding dates are not updated in the change task. Instead it is creating the change task newly. Below is the code i am using :BR( after...
Hi, I am trying to build a report that shows RITMs that have breached the SLAs and associated SC tasks. So far I am only able to build a report that show RITMs that have breached SLAs using the sc_req_item_sla table but not able to pull the sc_task i...
Hi All, Actually Basically when we open a dashboard, we click on share option, then we can see, All, Groups and users, But i cannot see the "Role" to share based on the role in Dev , but in UAT i can see Please see the attachment please help me to a...
Hi All,I have created one category and 4 catalog items in the service portal so, as a process owner, The request from these items should flow to the group members of the group "XXX" for approval so as to grant the requester an ITIL License. How to do...
