How do you tell the last date/time a LookupTable (LUT) was updated?

Question

Question

Kirsten Whatley · Feb 21

#Health Connect #InterSystems IRIS for Health

(In HealthConnect)

Discussion (7)4

Log in or sign up to continue

Enrico Parisi · Feb 21

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.

0 0

score 1 · Answer 1 · 2024-02-21T13:31:54-05:00

Enrico Parisi · Feb 21

I don't think this information is stored in Lookup Tables.

Only table name, key and value are stored.

1 0

score 0 · Answer 2 · 2024-02-21T14:39:53-05:00

Kirsten Whatley · Feb 21

Is it stored anywhere? In an audit log, or ?

0 0

score 4 · Answer 3 · 2024-02-22T13:35:26-05:00

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.

score 0 · Answer 4 · 2024-02-22T16:52:25-05:00

Ben Spead · Feb 22

This is definitely the answer!

0 0

score 0 · Answer 5 · 2024-02-23T07:35:01-05:00

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.

score 2 · Answer 6 · 2024-02-25T10:28:19-05:00

Source control is a recommendation to track such changes. I recommend git-source-control package by @Timothy Leavitt