Search found 2 matches
- Fri Dec 09, 2016 12:32 pm
- Forum: Advanced Topics
- Topic: ProcNote Stored Historical Change
- Replies: 4
- Views: 11134
Re: ProcNote Stored Historical Change
Thank you for your help! I do looking for a query that can shown the active note in the chart module. Just discovered that MAX(EntryDateTime) is not accurate if there are more than one note in the same procedure. Is there a field that should help identify whether it is active or not?
- Fri Dec 09, 2016 11:40 am
- Forum: Advanced Topics
- Topic: ProcNote Stored Historical Change
- Replies: 4
- Views: 11134
ProcNote Stored Historical Change
Hi,
I noticed that ProcNote table will saved the changes of the procedure note, and when I try to pull out the raw data, it appear multiple times, I am guessing it will saved the change / delete note. Is there any way we can identified which note is the active one?
Thank you!
I noticed that ProcNote table will saved the changes of the procedure note, and when I try to pull out the raw data, it appear multiple times, I am guessing it will saved the change / delete note. Is there any way we can identified which note is the active one?
Thank you!