Stuart Torres-Catmur Posted May 5, 2022 Share Posted May 5, 2022 Went to the list today and wanted to sort it by most recently updated. Problem - no dates! When will this be fixed please? https://live.hornbill.com/[instance ID]/admin/platform/email/templates/ Link to comment Share on other sites More sharing options...
James Ainsworth Posted May 5, 2022 Share Posted May 5, 2022 Hi @Stuart Torres-Catmur The development team are aware of this. The turn around for this type of fix is relatively fast. I can't see this being longer than a week to get this to the live environment. I'll let you know once there has been a confirmation of the fix. 1 Link to comment Share on other sites More sharing options...
James Ainsworth Posted May 6, 2022 Share Posted May 6, 2022 Hi @Stuart Torres-Catmur I just wanted to let you know that this should now be working. An update was applied last night to correct this. Link to comment Share on other sites More sharing options...
Stuart Torres-Catmur Posted May 6, 2022 Author Share Posted May 6, 2022 Hi @James Ainsworth ESP update 3614 applied this morning. No other updates and no email from Announcements about an update from last night. The issue still persists. Link to comment Share on other sites More sharing options...
James Ainsworth Posted May 6, 2022 Share Posted May 6, 2022 Hi @Stuart Torres-Catmur The fix was part of the ESP update 3614. Could you try two things. Could you clear your browser's cache and could you try modifying one or two email templates. I've tested this on a few live instances and the dates appear to be working in each case. Link to comment Share on other sites More sharing options...
Stuart Torres-Catmur Posted May 6, 2022 Author Share Posted May 6, 2022 @James Ainsworth Done that and it shows the Last Updated for the template I just updated. Where is the Last Updated data for all the other templates? Link to comment Share on other sites More sharing options...
James Ainsworth Posted May 6, 2022 Share Posted May 6, 2022 @Stuart Torres-Catmur It is possible that some don't show a date as they may not have had an update since creation. It is also possible that some that were updated in the past were last updated before the feature to capture and store the update date was introduced. Link to comment Share on other sites More sharing options...
Stuart Torres-Catmur Posted May 9, 2022 Author Share Posted May 9, 2022 @James Ainsworth I grabbed the list of email templates on 17th March 2022 and the updated column shows dates for every template going back to March 2017 when we started with Hornbill. Hornbill is now only showing updates made since 28th April 2022 (and these are updated dates, not created dates) So has this functionality has changed in that it only shows a date if the template has been modified since it's creation? If so why is this please? This makes it harder to spot at a glance how old a template is. We have over 1000 templates so being able to sort them for weeding purposes really helps. Can the functionality be reverted to what is was before please? i.e Last Updated Date rather than If Updated Date Link to comment Share on other sites More sharing options...
James Ainsworth Posted May 9, 2022 Share Posted May 9, 2022 Hi @Stuart Torres-Catmur I'm afraid that I'm not familiar with how it worked before. Looking at the column name "last updated" it would suggest to me that this would/should be populated on update, and not creation. I can see that there may be some users that would be interested to know which templates have never had an update since they were created. I will feed this back to the development team. Link to comment Share on other sites More sharing options...
Stuart Torres-Catmur Posted May 10, 2022 Author Share Posted May 10, 2022 @James AinsworthThank you. For us this is a negative change to functionality so your feedback to the development team is appreciated. Link to comment Share on other sites More sharing options...
James Ainsworth Posted June 1, 2022 Share Posted June 1, 2022 Hi @Stuart Torres-Catmur Some additional work has been done that will show the initial creation date under last updated column. We have found through testing that some email templates did not have a creation date stored against them, so it is possible that some template may still show as empty. You should see some additional templates with the updated column being populated, but we are still working on making sure that all templates have a date. Link to comment Share on other sites More sharing options...
Stuart Torres-Catmur Posted June 6, 2022 Author Share Posted June 6, 2022 Hi @James Ainsworth That sounds more promising. I just checked and the earliest update date our templates have is 29/04/2022. We've been creating them since 2017. When will the changes be in a release please? Link to comment Share on other sites More sharing options...
James Ainsworth Posted June 6, 2022 Share Posted June 6, 2022 Hi @Stuart Torres-Catmur I have also just looked at my data and the missing Last Updated fields in my above screenshot are not populated in the database as both the creation date and last updated date are empty. This will explain why I am not seeing any value in the last updated column. Using Database Direct you can browse to the h_sys_entity_email_templates table and have a look to see which of your email templates have a creation date and/or last updated date set. While the code has been updated to set the Last Update to the Creation Date prior to an update, if there is no Creation Date, there is nothing that can be used to do this. If all of your email templates do include a creation date, then this would imply that there is something wrong when it comes to displaying this information. If they are empty, this would suggest that the template was created before these fields were available. I've been told that the creation date and last updated fields were only added this year, on April 7th. This would suggest that any email template created before this date won't have a creation date available and there for the last updated field on templates that have not been updated, won't be populated with the creation date. I hope that makes sense Link to comment Share on other sites More sharing options...
Stuart Torres-Catmur Posted June 7, 2022 Author Share Posted June 7, 2022 Hi @James Ainsworth on 17th March, I copied and pasted the full list of templates into a spreadsheet (i.e. as displayed in the application). Every single one had an Last Updated date. I checked both the application front end and DB Direct and now most don't. Should I log this on the Customer Success portal as an Incident? This would seem to be either loss of data or the data wasn't migrated from the old Last Updated field to the new field added 7th April 2022. Please advise. Link to comment Share on other sites More sharing options...
James Ainsworth Posted June 7, 2022 Share Posted June 7, 2022 Hi @Stuart Torres-Catmur 5 hours ago, Stuart Torres-Catmur said: This would seem to be either loss of data or the data wasn't migrated from the old Last Updated field to the new field added 7th April 2022. Yes, this is possible. The development team have looked into this and may now have something to correct this which will be available in the next platform update. 1 Link to comment Share on other sites More sharing options...
Stuart Torres-Catmur Posted July 7, 2022 Author Share Posted July 7, 2022 On 6/7/2022 at 2:25 PM, James Ainsworth said: Hi @Stuart Torres-Catmur Yes, this is possible. The development team have looked into this and may now have something to correct this which will be available in the next platform update. @James Ainsworth any sign of the platform update that has this please? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now