Notifications
Clear all
Topic starter
Good morning all!,
Our facility uses a call center to field all calls that come in. These employees search for patients in CEMR using date of birth. When you search by date of birth, it mixes up the patient names. Our hope is that the initial search method could be date of birth and then the secondary search could be alphabetical.
We are going to turn in an enhancement request for this, but, wanted to spread the word to see if others would request this also.
The squeakier the better! 🙂
Thanks,
Walda
UAP Clinic EMR Support
Posted : November 25, 2014 5:47 am
Walda,
CEMR Inquiries Tab does not allow any Order By statements.
It also does not allow you to mix AND and OR in the Criteria. Ugh!
Add those to your change request 🙂
BUT - here is a programming Trick.
The EMR sorts are based on ASCII order, and in the ASCII character tables,
@ sign comes before A-Z,a-z.
Here is a link to an ASCII table so you can see for yourself what I mean:
http://web.cs.mun.ca/~michael/c/ascii-table.html
Add to your search:
AND Lastname > @
AND Firstname > @
This will make the results order alphabetically by Lastname
You might also want to limit results based on Date of Last office visit:
AND Date of Last Office Visit on or after <some date>
Let me know (or check this answer), if this solves your query problem
regards,
Beverly
Posted : November 25, 2014 6:19 am
Topic starter
Beverly,
I think something has changed along the way. I do remember a time when the programming above would work. I had forgotten about it but, I definitely do remember it. We tried the above and then we also tried ""8/12/32 and regexp_like(lastname,'^[A-Z]')"" and it also didn't work. I think in the process of changing things over to HTML vs obs terms, etc, something was changed in the search capabilities.
UUGGHH!!!! 🙂
Thank you anyway!
Posted : November 25, 2014 8:29 am
Well, still works in Centricity EMR 9.5 Inquiry Tab. Are you on version 12 then ? - Beverly
Posted : November 25, 2014 10:38 am
Topic starter
Nope, we are on 9.8.6
Thank anyway!
Walda
Posted : November 25, 2014 11:24 am
