Quite a bit of work on this update, hence the jump in the version number. Better handling of phone numbers. The way this is done in Synergy is quite complex,...
Fixed the problem that you can do a multi-select on certain listboxes, for example the Registered GP box in the ID node and this can be saved and it will run...
Attached the report. Bart _____ From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of bartsmissaert Sent: 02...
This is a serious improvement over 20.76 as reports will run some 3 to 4 times faster. This has to do with a bug in the file dhRichClient that was introduced...
Bart I got 20.77 yesterday and can confirm that it is much quicker. The Mental Health Review report I sent you last week runs about six times faster than 20.76...
Hi Paul, Thanks for confirming and telling me it was even a lot more than 3 to 4 times slower. Yes, I was a bit slow to pick this up. In case you were...
Fixed the problem to do with the version of a dll or other helper file going down instead of up. Fixed a rare problem where there was no value (in the report...
Had a request for a report that shows different postcodes for the same address and I thought it might be useful to post that here. This is a plain SQL, so add...
Bart Is it possible to produce a list of patients who have changed registered GP (within the practice) over the last 6 and 12 months. Not looking for new...
Hi Les, Yes, you can do that via the Audit trail search wizard. You will be searching for updates in the table PATIENT. Start the wizard with Options, Search...
Thanks Bart, but it seems to have found all patients who have had something changed in the PATIENT table. How do I weed out those whose registered GP was...
Hi Les, For some reason your zip file is found to be invalid here. What you will have to do though is compare the old PATIENT records with the current ones and...
What you can do for starters is search on the patients found in the audit trail and see who the current GP is. This can be done easily by importing the first...
Les, What you will have to do as well is clear all the duplicate patients from your audit table output. Now you are only interested in the last record per...
Hi Les, OK, I can see that this is getting a bit complex for you and my instructions are not really comprehensive. Give me some time and I will post...
(no author)
(no email address)
Feb 11, 2009 5:28 pm
3525
Thanks Bart - at home now, but I agree it was starting to get complicated. 2009/2/11 <bartsmissaert@...> ... -- Les Les Trewinnard (Practice...
No avoiding that, this is advanced stuff. Will post later and that should work no problem. Bart...
(no author)
(no email address)
Feb 11, 2009 6:26 pm
3527
OK, this should do the job: Run your audit trail report on the table PATIENT and look for Updates. Before running this have a report setup with in the first ID...
I forgot to say that when you run the audit wizard here and it asks if you want to convert the output then say No. This is because you need the user id numbers...
Fixed a potential problem to do with setting the printing margins of reports. Fixed a possible problem that could occur if the local install wasn't done by...
Hi Bart Your blueyonder inbox is full so you must be on your holidays. Re the previous message: I have now found I can load some patients, most Smiths and...
This fixes a bug to do with the topping up of the SQLite tables ENCOUNTER_SDB and PROBLEMS_ALL. A result from that could be that the routine under Options,...
This adds the option to easily see the seen by user of entries produced by any node. To make this possible the table ENCOUNTER_SDB had to change and before...
This SQL will give some information regarding the encounter: select s.patient_id, e.seen_by, e.location_id as surgery_id, e.information_source_type from ...
Just one further tip to do with this. If the node you stick the SQL node on is a node that looks for encounter entries, eg with: 9N11. Seen in GP's surgery ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
