How do you tell the last date/time a LookupTable (LUT) was updated?
How do you tell the last date/time a LookupTable (LUT) was updated?
(In HealthConnect)
Comments
I don't think this information is stored in Lookup Tables.
Only table name, key and value are stored.
Is it stored anywhere? In an audit log, or ?
I would say no.
Lookup Tables are simple and ready to use, if you need more, it's relatively simple to implement a custom functionality with audit, lat modification time, user etc.
Use source control to store lookup tables and update them only through the CICD process.
This way you can have a full visibility over when the change happened.
This is definitely the answer!
I agree that source control is a good way of tackling the "who changed it, when, and why?" questions.
If you haven't already, please take a look at Deltanji from my company, George James Software. LUTs are treated the same way as Classes, Routines, Schemas and many more component types. Deltanji operates natively inside all InterSystems platforms, including HealthConnect, dealing with deployment as well as versioning.
Source control is a recommendation to track such changes. I recommend git-source-control package by @Timothy Leavitt