Highlighted
Honored Contributor.
Honored Contributor.
115 views

Updating Closed Records

We created a new field in the location table, "County" in each location record, we populated this field which is based on the City of each location. We have also added this field to contacts, incidents and probsummary. When a new record is created and a contact is filled in, we have the links set to fill the location and County. Users are only able to update the location which will also update the County as the county must be based on the location.

My problem is that I need to be able to run historical reports based on the County so I need to update the closed records.  

 

 

0 Likes
5 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Updating Closed Records

Hello A2drew.

hope you are doing fine today.

I just wanted to let you know that i am making an investigation on how to accomplish this requirement, as soo as i have the complete information i will share it with you.

Carlos Villalobos R
Customer Support Engineer
If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation.
0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Re: Updating Closed Records

Thank you

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Updating Closed Records

Hi, Can you please share if your issue is resolved ? If yes then you can post the answer here, it ll help others too. If not then you can log a case with HP Software support or Professional Services for customization requests.
Regards,
HPE Software Support

0 Likes
Highlighted
Knowledge Partner
Knowledge Partner

Re: Updating Closed Records

My problem is that I need to be able to run historical reports based on the County so I need to update the closed records.  

It's not clear why you need to update close records.. 

I can only see two options: you want to get the country considering the data when the record was closed or the actual data or with the data at specific moment.

If your report:

- Want to use the Country when the ticket was closed you don't need to update the field.

- Want to use the actual Country data based on the tickets contact/location/etc make a join and get the actual data. But this is really strange... during the "lifecicle" of your location the attribute country changes?? 

- Want to use the Country of a specific t ime, create a audit of your Country changes at Location and use it in your report.

 

I also think you should avoid to replicate the same information to all tables.. it's almost always bad design.

Regards,
Breno Abreu

If you feel this was helpful please click the KUDOS! thumb below!
0 Likes
Highlighted
Honored Contributor.. Honored Contributor..
Honored Contributor..

Re: Updating Closed Records

Update your tickets from the database directly.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.