Notifications
Clear all
Topic starter
I want to build a report that shows utilization going back more than 2 months. The ApptSlot table gets it's info wiped when the date is < 2 months. How do I get a utilization to show unallocated slots going back a year? Is there a way to "re-create" the info in the ApptSlot table?
thanks!
jeff
Posted : February 18, 2019 1:14 pm
To my knowledge, that information is gone after it's removed. There's an unsupported means to extend the time that slot info is saved, but it has performance implications when using the Scheduing module.
I created some triggers that preserve the data in custom tables. I probably could have come up with a system that was more elegant, but if you're interested, I can share the code with you.
Posted : February 19, 2019 2:59 am
Topic starter
Hi mhogg! that would be awesome if you would share the script to keep it! thank you!
Posted : February 19, 2019 4:33 am
I apologize that I haven't gotten back to you on this yet. I've had a lot of time off lately for family matters. I hope to be able to get you some files with worthwhile documentation next week.
Posted : March 6, 2019 5:57 am
