searching for patient by thier wireless Number/Mobile

For users or potential users.
Post Reply
alhalwachi
Posts: 74
Joined: Fri Apr 02, 2010 2:26 pm

searching for patient by thier wireless Number/Mobile

Post by alhalwachi » Wed Feb 16, 2011 12:58 pm

Hi everyone

In the "Select Patient" form, how can i search for patients with thier wirelss numbers/Mobile numbers? In other words, how can i add an extra seach filtering field such as the patient WirelessPh PatDetails into the form?

Thanks

drtmz
Posts: 84
Joined: Thu May 29, 2008 4:27 pm

Re: searching for patient by thier wireless Number/Mobile

Post by drtmz » Wed Feb 16, 2011 2:06 pm

How about this little down and dirty query?

SELECT PatNum, WirelessPhone from Patient
WHERE WirelessPhone = '(###)-### ####'
# add phone number above


drtmz

User avatar
Hersheydmd
Posts: 700
Joined: Sun May 03, 2009 9:12 pm

Re: searching for patient by thier wireless Number/Mobile

Post by Hersheydmd » Thu Feb 17, 2011 2:14 pm

alhalwachi wrote:Hi everyone

In the "Select Patient" form, how can i search for patients with thier wirelss numbers/Mobile numbers? In other words, how can i add an extra seach filtering field such as the patient WirelessPh PatDetails into the form?

Thanks
You don't need to. The phone field in the Search for Patients window will search all phone numbers, home, work & wireless.
Robert M Hersh DMD, FAGD
Univ. of Penn 1982
Brooklyn, NY 11234
https://www.facebook.com/pages/Robert-M ... 1471599429

alhalwachi
Posts: 74
Joined: Fri Apr 02, 2010 2:26 pm

Re: searching for patient by thier wireless Number/Mobile

Post by alhalwachi » Wed Mar 30, 2011 2:53 pm

Thankssssssss really :P

User avatar
irfan
Posts: 216
Joined: Thu Oct 21, 2010 9:09 am

Re: searching for patient by thier wireless Number/Mobile

Post by irfan » Wed Mar 30, 2011 4:30 pm

yep.. its nice when the phone rings and i wanna know who the front desk is talking to.. just look at the caller id, punch in #, voila.

Post Reply