Populating Full Location Field in Incident Record with full Hierarchy

Ebrunken · ‎03-09-2023

Hello!

I'm currently working on improving the data reported to our incident records for our facilities department but am hitting a road block. I have established child locations within a venue and was able to have the fields populate respectively in the service catalog, however I am not sure how to get the data into the record. I took a look in the forum and found a post about changing the Sys Definition Dictionary for full name of the cmn_location but it only gave me the first two in the hierarchy. Currently my record shows this:

When I look at the portal I see the information from the City, Building, Venue, Zone, Room populated but trying to see if I can either add another field into the incident record or maybe do an OnSubmit and have it output that into the work notes as an option if the former isn't possible.

Any direction would be appreciated?

Thanks,

Evan

Allen Andreas · ‎03-09-2023

Hi,

Are you saying that on your location records, you want to capture more information than what the out of box fields provide? If so, then yes, you'd have to create custom fields to house that information. Then, when I talked about configuring the form, I meant the Incident form, and then you can dot-walk to the location field and pull in 4,5,6 fields from it and add it to the incident form if they need to be easily shown.

Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

View solution in original post

Allen Andreas · ‎03-09-2023

Hi,

Do you mind maybe providing some screenshot of the relationships involved here?

Such as a screenshot of a location (even if you censor it, if needed) and what field there that takes you into the next relationship and another screenshot (censored, as needed), and so on.

I'm trying to gain an understanding of what all the pieces are so we can give you the best advice.

Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

Ebrunken · ‎03-13-2023

Hi Allen,

Thank you again for your help. After taking a step back and getting fresh eyes I located the problem in the incident record producer limiting to my venues rather than allowing anything in the 4th and 5th chain of hierarchy. Following that I added another field and dot-walked my way to the information I needed.

Thanks again for the help!