Incident Location time zone in a report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-10-2024 12:58 AM
Hi,
the requestor would like to see the Incident Location's time zone in a separate column in a list report. Any ideas on how to solve this without implementing a new custom field? Thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-10-2024 08:34 AM
Please be clear on what is desired, what do you mean by "Incident Location's time zone"? I don't see how that would be determined unless you want the time zone of one of the incident fields that is a reference to the sys_user table, where there is a 'time_zone' field. If so you can Dot Walking.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-12-2024 11:53 PM
Incidents (all Tasks, actually) have a reference to Location [cmn_location], and Location also has a Time Zome field. I'd need to calculate the dates based on that information.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2024 06:53 AM
@Community Alums ,
This all depends on your definition of incident location. Is this the location set on the incident form or is it the location associated to the affected user.
In both cases the tables that those fields reference both have time zone on them. I will use the location as the example. If you navigate to Locations (cmn_location) and pick any location then on that form you may or may not have time zone as an available field to fill in. If it is not on the form then add via Configure > Form Layout or Design, find Time Zone and add to the form where you would like it.
Then on the report you have set up you can click on location followed by the expand symbol above the arrows and find time zone and add to your selected columns where you would like it.
Please mark my answer correct and helpful if this works for you
Many Thanks,
Rob
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-30-2024 02:16 AM
Hi @Community Alums,
Did you solve this issue or do you still need any further assistance with it?
Please mark my answer correct and helpful if this works for you
Many Thanks,
Rob