ICT Tip 48 – Socrates – Wildcard search in Drug module

MJ
Michael Joyce
Fri, Dec 10, 2021 3:30 PM

Many of you will know this already but when you search for a new drug, by default the search string searches the first word of the relevant drug only, if you use the generic or trade name option, it will search the first word in each column, trade or generic.
So, in this example:
[Graphical user interface  Description automatically generated]
Searching for benzyl will find Benzyl Benzoate in the trade column and Benzylpencillin in the generic column.  However, if you searched for Benzoate you would actually find nothing.
If on the other hand you click on the wildcard search tick box then it searches for any word that appears anywhere in the drug name.  In fact, it will search anywhere in any word in the drug name.
So, ticking the wildcard and searching for zoate gives you this result
[Graphical user interface, application  Description automatically generated]

This comes into its own when searching for ostomy products for example.  If you know the code for the product, tick the wildcard search and search on the code.  Without the wildcard this search would not find anything.  See example below for Simpla 500ml leg bags, code 2155.  Searching for simpla results in a bewildering array of products but using the code and the wildcard you can quickly find it.

[cid:image003.png@01D7EDDA.CE58D2A0]

Michael

Many of you will know this already but when you search for a new drug, by default the search string searches the first word of the relevant drug only, if you use the generic or trade name option, it will search the first word in each column, trade or generic. So, in this example: [Graphical user interface Description automatically generated] Searching for benzyl will find Benzyl Benzoate in the trade column and Benzylpencillin in the generic column. However, if you searched for Benzoate you would actually find nothing. If on the other hand you click on the wildcard search tick box then it searches for any word that appears anywhere in the drug name. In fact, it will search anywhere in any word in the drug name. So, ticking the wildcard and searching for zoate gives you this result [Graphical user interface, application Description automatically generated] This comes into its own when searching for ostomy products for example. If you know the code for the product, tick the wildcard search and search on the code. Without the wildcard this search would not find anything. See example below for Simpla 500ml leg bags, code 2155. Searching for simpla results in a bewildering array of products but using the code and the wildcard you can quickly find it. [cid:image003.png@01D7EDDA.CE58D2A0] Michael
E
ericyelvo@gmail.com
Sat, Dec 11, 2021 11:19 AM

Fantastic Michael
Thank you

Sent from my iPhone

On 10 Dec 2021, at 15:30, Michael Joyce mjoyce@centrichealthblessington.ie wrote:


Many of you will know this already but when you search for a new drug, by default the search string searches the first word of the relevant drug only, if you use the generic or trade name option, it will search the first word in each column, trade or generic.

So, in this example:

Searching for benzyl will find Benzyl Benzoate in the trade column and Benzylpencillin in the generic column.  However, if you searched for Benzoate you would actually find nothing.

If on the other hand you click on the wildcard search tick box then it searches for any word that appears anywhere in the drug name.  In fact, it will search anywhere in any word in the drug name.

So, ticking the wildcard and searching for zoate gives you this result

This comes into its own when searching for ostomy products for example.  If you know the code for the product, tick the wildcard search and search on the code.  Without the wildcard this search would not find anything.  See example below for Simpla 500ml leg bags, code 2155.  Searching for simpla results in a bewildering array of products but using the code and the wildcard you can quickly find it.

Michael


Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com
To unsubscribe send an email to gpdiscussion-leave@centricgpforum.com

Fantastic Michael Thank you Sent from my iPhone > On 10 Dec 2021, at 15:30, Michael Joyce <mjoyce@centrichealthblessington.ie> wrote: > >  > Many of you will know this already but when you search for a new drug, by default the search string searches the first word of the relevant drug only, if you use the generic or trade name option, it will search the first word in each column, trade or generic. > > So, in this example: > > > > Searching for benzyl will find Benzyl Benzoate in the trade column and Benzylpencillin in the generic column. However, if you searched for Benzoate you would actually find nothing. > > If on the other hand you click on the wildcard search tick box then it searches for any word that appears anywhere in the drug name. In fact, it will search anywhere in any word in the drug name. > > So, ticking the wildcard and searching for zoate gives you this result > > > > > > This comes into its own when searching for ostomy products for example. If you know the code for the product, tick the wildcard search and search on the code. Without the wildcard this search would not find anything. See example below for Simpla 500ml leg bags, code 2155. Searching for simpla results in a bewildering array of products but using the code and the wildcard you can quickly find it. > > > > > > > > Michael > > > > _______________________________________________ > Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com > To unsubscribe send an email to gpdiscussion-leave@centricgpforum.com
DN
Duo Ninja
Sat, Dec 11, 2021 11:28 AM

Michael
I always had huge issues finding all the stoma product. Have to type the
brand name and scroll closely to find the suitable one. It’s great that u
can check using the product number with wildcard search.
Thanks Michael.

On Sat 11 Dec 2021 at 11:20, ericyelvo@gmail.com wrote:

Fantastic Michael
Thank you

Sent from my iPhone

On 10 Dec 2021, at 15:30, Michael Joyce <
mjoyce@centrichealthblessington.ie> wrote:



Many of you will know this already but when you search for a new drug, by
default the search string searches the first word of the relevant drug
only, if you use the generic or trade name option, it will search the first
word in each column, trade or generic.

So, in this example:

[image: Graphical user interface Description automatically generated]

Searching for benzyl will find Benzyl Benzoate in the trade column and
Benzylpencillin in the generic column.  However, if you searched for
Benzoate you would actually find nothing.

If on the other hand you click on the wildcard search tick box then it
searches for any word that appears anywhere in the drug name.  In fact, it
will search anywhere in any word in the drug name.

So, ticking the wildcard and searching for zoate gives you this result

[image: Graphical user interface, application Description automatically
generated]

This comes into its own when searching for ostomy products for example.
If you know the code for the product, tick the wildcard search and search
on the code.  Without the wildcard this search would not find anything.
See example below for Simpla 500ml leg bags, code 2155.  Searching for
simpla results in a bewildering array of products but using the code and
the wildcard you can quickly find it.

Michael


Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com
To unsubscribe send an email to gpdiscussion-leave@centricgpforum.com


Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com
To unsubscribe send an email to gpdiscussion-leave@centricgpforum.com

Michael I always had huge issues finding all the stoma product. Have to type the brand name and scroll closely to find the suitable one. It’s great that u can check using the product number with wildcard search. Thanks Michael. On Sat 11 Dec 2021 at 11:20, <ericyelvo@gmail.com> wrote: > Fantastic Michael > Thank you > > Sent from my iPhone > > On 10 Dec 2021, at 15:30, Michael Joyce < > mjoyce@centrichealthblessington.ie> wrote: > >  > > Many of you will know this already but when you search for a new drug, by > default the search string searches the first word of the relevant drug > only, if you use the generic or trade name option, it will search the first > word in each column, trade or generic. > > So, in this example: > > [image: Graphical user interface Description automatically generated] > > Searching for benzyl will find Benzyl Benzoate in the trade column and > Benzylpencillin in the generic column. However, if you searched for > Benzoate you would actually find nothing. > > If on the other hand you click on the wildcard search tick box then it > searches for any word that appears anywhere in the drug name. In fact, it > will search anywhere in any word in the drug name. > > So, ticking the wildcard and searching for zoate gives you this result > > [image: Graphical user interface, application Description automatically > generated] > > > > This comes into its own when searching for ostomy products for example. > If you know the code for the product, tick the wildcard search and search > on the code. Without the wildcard this search would not find anything. > See example below for Simpla 500ml leg bags, code 2155. Searching for > simpla results in a bewildering array of products but using the code and > the wildcard you can quickly find it. > > > > > > Michael > > > _______________________________________________ > Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com > To unsubscribe send an email to gpdiscussion-leave@centricgpforum.com > > _______________________________________________ > Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com > To unsubscribe send an email to gpdiscussion-leave@centricgpforum.com >
JR
Jose Ribas
Sat, Dec 11, 2021 11:44 AM

Brilliant Michael

Thanks

Enviado desde mi iPhone

El 11 dic 2021, a las 12:28, Duo Ninja nasilemak1978@gmail.com escribió:


Michael
I always had huge issues finding all the stoma product. Have to type the brand name and scroll closely to find the suitable one. It’s great that u can check using the product number with wildcard search.
Thanks Michael.

On Sat 11 Dec 2021 at 11:20, <ericyelvo@gmail.commailto:ericyelvo@gmail.com> wrote:
Fantastic Michael
Thank you

Sent from my iPhone

On 10 Dec 2021, at 15:30, Michael Joyce <mjoyce@centrichealthblessington.iemailto:mjoyce@centrichealthblessington.ie> wrote:


Many of you will know this already but when you search for a new drug, by default the search string searches the first word of the relevant drug only, if you use the generic or trade name option, it will search the first word in each column, trade or generic.
So, in this example:
[Graphical user interface    Description automatically generated]
Searching for benzyl will find Benzyl Benzoate in the trade column and Benzylpencillin in the generic column.  However, if you searched for Benzoate you would actually find nothing.
If on the other hand you click on the wildcard search tick box then it searches for any word that appears anywhere in the drug name.  In fact, it will search anywhere in any word in the drug name.
So, ticking the wildcard and searching for zoate gives you this result
[Graphical user interface, application    Description automatically generated]

This comes into its own when searching for ostomy products for example.  If you know the code for the product, tick the wildcard search and search on the code.  Without the wildcard this search would not find anything.  See example below for Simpla 500ml leg bags, code 2155.  Searching for simpla results in a bewildering array of products but using the code and the wildcard you can quickly find it.

[cid:17da93ebe407605c1153]

Michael


Gpdiscussion mailing list -- gpdiscussion@centricgpforum.commailto:gpdiscussion@centricgpforum.com
To unsubscribe send an email to gpdiscussion-leave@centricgpforum.commailto:gpdiscussion-leave@centricgpforum.com


Gpdiscussion mailing list -- gpdiscussion@centricgpforum.commailto:gpdiscussion@centricgpforum.com
To unsubscribe send an email to gpdiscussion-leave@centricgpforum.commailto:gpdiscussion-leave@centricgpforum.com


Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com
To unsubscribe send an email to gpdiscussion-leave@centricgpforum.com

Brilliant Michael Thanks Enviado desde mi iPhone El 11 dic 2021, a las 12:28, Duo Ninja <nasilemak1978@gmail.com> escribió:  Michael I always had huge issues finding all the stoma product. Have to type the brand name and scroll closely to find the suitable one. It’s great that u can check using the product number with wildcard search. Thanks Michael. On Sat 11 Dec 2021 at 11:20, <ericyelvo@gmail.com<mailto:ericyelvo@gmail.com>> wrote: Fantastic Michael Thank you Sent from my iPhone On 10 Dec 2021, at 15:30, Michael Joyce <mjoyce@centrichealthblessington.ie<mailto:mjoyce@centrichealthblessington.ie>> wrote:  Many of you will know this already but when you search for a new drug, by default the search string searches the first word of the relevant drug only, if you use the generic or trade name option, it will search the first word in each column, trade or generic. So, in this example: [Graphical user interface Description automatically generated] Searching for benzyl will find Benzyl Benzoate in the trade column and Benzylpencillin in the generic column. However, if you searched for Benzoate you would actually find nothing. If on the other hand you click on the wildcard search tick box then it searches for any word that appears anywhere in the drug name. In fact, it will search anywhere in any word in the drug name. So, ticking the wildcard and searching for zoate gives you this result [Graphical user interface, application Description automatically generated] This comes into its own when searching for ostomy products for example. If you know the code for the product, tick the wildcard search and search on the code. Without the wildcard this search would not find anything. See example below for Simpla 500ml leg bags, code 2155. Searching for simpla results in a bewildering array of products but using the code and the wildcard you can quickly find it. [cid:17da93ebe407605c1153] Michael _______________________________________________ Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com<mailto:gpdiscussion@centricgpforum.com> To unsubscribe send an email to gpdiscussion-leave@centricgpforum.com<mailto:gpdiscussion-leave@centricgpforum.com> _______________________________________________ Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com<mailto:gpdiscussion@centricgpforum.com> To unsubscribe send an email to gpdiscussion-leave@centricgpforum.com<mailto:gpdiscussion-leave@centricgpforum.com> _______________________________________________ Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com To unsubscribe send an email to gpdiscussion-leave@centricgpforum.com
DP
Dr Paul O'Reilly
Sat, Dec 11, 2021 5:38 PM

Michael l have no idea what you are talking about. In fact l never have
any idea what you are talking about.                      But you are a
genius anyway.  Not a word l would associate with myself to often, but
genius you are.                                   As stated in my
previous correspondance's elsewhere. Would there be any chance you could
produce a book of computer tips.  A  Ladybird Book of Computer Tips. 
The younger Drs will have to look up the Ladybird Books !!              
They would however be very useful to us doting old fogey's!! love and
kisses O'Reilly.

On 11/12/2021 11:44, Jose Ribas wrote:

Brilliant Michael

Thanks

Enviado desde mi iPhone

El 11 dic 2021, a las 12:28, Duo Ninja nasilemak1978@gmail.com
escribió:


Michael
I always had huge issues finding all the stoma product. Have to type
the brand name and scroll closely to find the suitable one. It’s
great that u can check using the product number with wildcard search.
Thanks Michael.

On Sat 11 Dec 2021 at 11:20, ericyelvo@gmail.com wrote:

 Fantastic Michael
 Thank you

 Sent from my iPhone
 On 10 Dec 2021, at 15:30, Michael Joyce
 <mjoyce@centrichealthblessington.ie> wrote:

 

 Many of you will know this already but when you search for a new
 drug, by default the search string searches the first word of
 the relevant drug only, if you use the generic or trade name
 option, it will search the first word in each column, trade or
 generic.

 So, in this example:

 Graphical user interface Description automatically generated

 Searching for benzyl will find Benzyl Benzoate in the trade
 column and Benzylpencillin in the generic column.  However, if
 you searched for Benzoate you would actually find nothing.

 If on the other hand you click on the wildcard search tick box
 then it searches for any word that appears anywhere in the drug
 name.  In fact, it will search anywhere in any word in the drug
 name.

 So, ticking the wildcard and searching for zoate gives you this
 result

 Graphical user interface, application Description automatically
 generated

 This comes into its own when searching for ostomy products for
 example.  If you know the code for the product, tick the
 wildcard search and search on the code.  Without the wildcard
 this search would not find anything.  See example below for
 Simpla 500ml leg bags, code 2155.  Searching for simpla results
 in a bewildering array of products but using the code and the
 wildcard you can quickly find it.

 Michael

 _______________________________________________
 Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com
 To unsubscribe send an email to
 gpdiscussion-leave@centricgpforum.com
 _______________________________________________
 Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com
 To unsubscribe send an email to gpdiscussion-leave@centricgpforum.com

Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com
To unsubscribe send an email to gpdiscussion-leave@centricgpforum.com


Gpdiscussion mailing list --gpdiscussion@centricgpforum.com
To unsubscribe send an email togpdiscussion-leave@centricgpforum.com

Michael l have no idea what you are talking about. In fact l never have any idea what you are talking about.                      But you are a genius anyway.  Not a word l would associate with myself to often, but genius you are.                                   As stated in my previous correspondance's elsewhere. Would there be any chance you could produce a book of computer tips.  A  Ladybird Book of Computer Tips.  The younger Drs will have to look up the Ladybird Books !!               They would however be very useful to us doting old fogey's!! love and kisses O'Reilly. On 11/12/2021 11:44, Jose Ribas wrote: > Brilliant Michael > > Thanks > > Enviado desde mi iPhone > >> El 11 dic 2021, a las 12:28, Duo Ninja <nasilemak1978@gmail.com> >> escribió: >> >>  >> Michael >> I always had huge issues finding all the stoma product. Have to type >> the brand name and scroll closely to find the suitable one. It’s >> great that u can check using the product number with wildcard search. >> Thanks Michael. >> >> On Sat 11 Dec 2021 at 11:20, <ericyelvo@gmail.com> wrote: >> >> Fantastic Michael >> Thank you >> >> Sent from my iPhone >> >>> On 10 Dec 2021, at 15:30, Michael Joyce >>> <mjoyce@centrichealthblessington.ie> wrote: >>> >>>  >>> >>> Many of you will know this already but when you search for a new >>> drug, by default the search string searches the first word of >>> the relevant drug only, if you use the generic or trade name >>> option, it will search the first word in each column, trade or >>> generic. >>> >>> So, in this example: >>> >>> Graphical user interface Description automatically generated >>> >>> Searching for benzyl will find Benzyl Benzoate in the trade >>> column and Benzylpencillin in the generic column.  However, if >>> you searched for Benzoate you would actually find nothing. >>> >>> If on the other hand you click on the wildcard search tick box >>> then it searches for any word that appears anywhere in the drug >>> name.  In fact, it will search anywhere in any word in the drug >>> name. >>> >>> So, ticking the wildcard and searching for zoate gives you this >>> result >>> >>> Graphical user interface, application Description automatically >>> generated >>> >>> This comes into its own when searching for ostomy products for >>> example.  If you know the code for the product, tick the >>> wildcard search and search on the code.  Without the wildcard >>> this search would not find anything.  See example below for >>> Simpla 500ml leg bags, code 2155.  Searching for simpla results >>> in a bewildering array of products but using the code and the >>> wildcard you can quickly find it. >>> >>> Michael >>> >>> _______________________________________________ >>> Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com >>> To unsubscribe send an email to >>> gpdiscussion-leave@centricgpforum.com >> _______________________________________________ >> Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com >> To unsubscribe send an email to gpdiscussion-leave@centricgpforum.com >> >> _______________________________________________ >> Gpdiscussion mailing list -- gpdiscussion@centricgpforum.com >> To unsubscribe send an email to gpdiscussion-leave@centricgpforum.com > > _______________________________________________ > Gpdiscussion mailing list --gpdiscussion@centricgpforum.com > To unsubscribe send an email togpdiscussion-leave@centricgpforum.com