Hello all Is there any way of searching for issues by amount of tablets issued. I need to find out who is issuing large amounts of Temazepam. I know the amount...
Hi Patrick, There are a number of ways to do this, but the simplest and fastest is to do the drug search with the dosage in the output. This will give you in...
Showing the dosage in the output of a drug node could not show the amount if the dosage field contained a comma. This was caused by a recently introduced new...
Had a few requests lately for a certain type of report and thought it might be worth mentioning here how this can be done. This is counting certain entries in...
Have you got this problem solved? Bart ... issued. I need to find out who is issuing large amounts of Temazepam. I know the amount but do not know who the...
Have had a problem with updating the program and have not had time to look into it. Patrick ... From: bartsmissaert To: ExcelReportingAddin@yahoogroups.com ...
What was the problem? I have now setup up LogMeIn (free remote desktop software), so if it really is an awkward problem then I could fix it via remote access. ...
Bart Thanks for your reply - I had forgotten about this forum! I will use your suggestion at least for now, but I wonder whether it is possible to include as a...
Hi Les, ... I could see if I can squeeze it in, but it is quite simple with a SQL node. If you tell me what you need I can send you a report that will show it....
Bart Thanks for your reply - as unbelievably fast as ever! What I want is to be able to include the presence, or absence, of one (or more) of these attributes...
Hi Les, Try this in a SQL node: select e.patient_id, e.read_code, e.term_text, e.added_date from entry e inner join entry_attribute ea on (e.entry_id =...
If there aren't many patients with that ENT referral you could stick the SQL node on a morbidity node with that ENT referral code and run the SQL node in a...
David, Try a formula like this: =IF(ISERROR(COUNTIF(J2:AG2,"*C&B*")),0,COUNTIF(J2:AG2,"*C&B*")) Bart ... before HasCandB eitherwise get error message - this...
David, It works fine with me. Did you put the formula column before any referral term_text columns? It will have to be. I can make it look till the last column...
Bart In fact I'm not just interested in ENT referrrals: the read code parameter is RepAid is 8H#8HP,8HA,8HQ,8HT9,8H8B,8HV,8H...,8H8..,8H62. I will probably be...
Hi Les, You can always see what a normal node will do in SQL by right-clicking the normal node and do Copy SQL. Paste in the SQL node (or in Notepad or...
Bart I'm having problems running any search with an sql node. Even with the simplest search - an ID node with the following sql node select e.patient_id, ...
Hi Les, Not sure what is going on. Can you send me the report (zipped report file) that shows this error? You will need the Read codes in the SQL nodes as...
Les, I will upload a new file today which will have the option to search for attributes in the normal morbidity node. I can squeeze this in the free text box. ...
Added the option in the morbidity node to search on or just show data that is set under the More tab (when editing the entry), Attributes. This is done in the...
Les, Had another look at this and I think the funny characters must have crept in by the report file somehow being saved on the Unix server or maybe somewhere...
Added some code to avoid a manual login if that can be avoided. This is done in 2 ways: 1. By getting the login details from Synergy if that is running. 2. For...
I am sure this is obvious but I cant see it. How can you take a list of patients from the output of a report and use to add a read code into the patients notes...
John, Make sure that database writing is permitted by doing: Options, Set DB writing permission, type in the box: Allow database writing and do OK. Setup a...
Hi Bart, Is there anyway of getting rid of the last part (checking for logged in users) synergy reports to add an entry don't seem to worry about this. If a ...
Hi Alex, Maybe it is possible to do it safely (that is the whole point here) with other users connected, but I can't be sure it is so I don't dare to do it. ...
Forgot to mention one other important point. I don't think it is possible to add entries linked to a problem when you do it with the Synergy API, so if I used...
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.
