Part Search (Description Contains)

I remember some answerbooks on Epicweb related to searches if you are interested.
Search phrase I used was:  where part description contains
Hi all,

This seems really stupid but how do you search for a part where the description contains 3/4 for example? When I try this it returns zero records. Is there a special wildcard character that needs to be used?

Thanks,

Ted



Is it the ¾ (small one character version) rather than 3 slash 4 (three characters)?  I think the one character version is ASCII 190.

-Todd C.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 19, 2014 2:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Search (Description Contains)

 

 

Hi all,

This seems really stupid but how do you search for a part where the description contains 3/4 for example? When I try this it returns zero records. Is there a special wildcard character that needs to be used?

Thanks,

Ted

 

Progress or SQL?
If I remember "/" can be interpreted as an escape character in Progress.
I had a doc with some examples but sorry.... can't find it right now.

To expand on that ASCII thing.  If you are searching in a screen form you could try holding down the ALT key and entering 0190 then letting off the ALT to insert the ¾ in the search.

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 19, 2014 2:24 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part Search (Description Contains)

 

 

Is it the ¾ (small one character version) rather than 3 slash 4 (three characters)?  I think the one character version is ASCII 190.

-Todd C.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 19, 2014 2:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Search (Description Contains)

 

 

Hi all,

This seems really stupid but how do you search for a part where the description contains 3/4 for example? When I try this it returns zero records. Is there a special wildcard character that needs to be used?

Thanks,

Ted


 

Try putting a tilde ~ before the "slash /" such asÂ
3~/4


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Wed, Nov 19, 2014 at 3:31 PM, Todd Caughey tcaughey@... [vantage] <vantage@yahoogroups.com> wrote:

Â
<div>
  
  
  <p>

To expand on that ASCII thing. If you are searching in a screen form you could try holding down the ALT key and entering 0190 then letting off the ALT to insert the ¾ in the search.

-Todd C.

Â

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 19, 2014 2:24 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part Search (Description Contains)

Â

Â

Is it the ¾ (small one character version) rather than 3 slash 4 (three characters)? I think the one character version is ASCII 190.

-Todd C.

Â

Â

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 19, 2014 2:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Search (Description Contains)

Â

Â

Hi all,

This seems really stupid but how do you search for a part where the description contains 3/4 for example? When I try this it returns zero records. Is there a special wildcard character that needs to be used?

Thanks,

Ted


Â

</div><span class="ygrps-yiv-1862396940">
 


<div style="color:#fff;min-height:0;"></div>


SQL database. Epicor version 10.0.700.3

No, it is stored in the database as 3/4


From: "Todd Caughey tcaughey@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, November 19, 2014 3:24 PM
Subject: RE: [Vantage] Part Search (Description Contains)



Is it the ¾ (small one character version) rather than 3 slash 4 (three characters)?  I think the one character version is ASCII 190.
-Todd C.
 
 
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 19, 2014 2:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Search (Description Contains)
 
 
Hi all,

This seems really stupid but how do you search for a part where the description contains 3/4 for example? When I try this it returns zero records. Is there a special wildcard character that needs to be used?

Thanks,

Ted

 




We’ve converted all of our part descriptions to decimal with no leading zeros, simply for that reason.

 

I’ve also put some quick searches together using the part description “contains” and part number “begins” with.  I added the part description “Contains” several times in one quicksearch so that they can search for multiple things within the description at once.  The user then has to be trained to use an asterisk before and after their search words, but it works out pretty good for us.

 

Sarah Cooley

Database Analyst

Lube-Power, Inc.

PH:  586-247-6500 Ext. 258

scooley@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 19, 2014 3:51 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Part Search (Description Contains)

 

 

SQL database. Epicor version 10.0.700.3

 

No, it is stored in the database as 3/4

 


From: "Todd Caughey tcaughey@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, November 19, 2014 3:24 PM
Subject: RE: [Vantage] Part Search (Description Contains)

 

 

Is it the ¾ (small one character version) rather than 3 slash 4 (three characters)?  I think the one character version is ASCII 190.

-Todd C.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 19, 2014 2:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Search (Description Contains)

 

 

Hi all,

This seems really stupid but how do you search for a part where the description contains 3/4 for example? When I try this it returns zero records. Is there a special wildcard character that needs to be used?

Thanks,

Ted

 

 

 

I found if I do a where clause like this in SQL it works.
WHERE part.partdescription like '%3/4%' AND contains(part.partdescription, 'nylock&zinc')


From: "Sarah Cooley scooley@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, November 19, 2014 4:07 PM
Subject: RE: [Vantage] Part Search (Description Contains)

#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 #ygrps-yiv-1034368617yiv7555007458 --

#ygrps-yiv-1034368617yiv7555007458 .ygrps-yiv-1034368617yiv7555007458ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458photo-title
a,
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458photo-title a:active,
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458photo-title a:hover,
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458attach-table div.ygrps-yiv-1034368617yiv7555007458attach-row {
clear:both;}

#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458attach-table div.ygrps-yiv-1034368617yiv7555007458attach-row div {
float:left;}

#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458ygrp-file {
width:30px;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458attach-table div.ygrps-yiv-1034368617yiv7555007458attach-row div div a {
text-decoration:none;}

#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458attach-table div.ygrps-yiv-1034368617yiv7555007458attach-row div div span {
font-weight:normal;}

#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 #ygrps-yiv-1034368617yiv7555007458

filtered #ygrps-yiv-1034368617yiv7555007458 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {panose-1:2 11 5 2 2 2 2 2 2 4;}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458
#ygrps-yiv-1034368617yiv7555007458 p.ygrps-yiv-1034368617yiv7555007458MsoNormal, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 li.ygrps-yiv-1034368617yiv7555007458MsoNormal, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 a:link, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 span.ygrps-yiv-1034368617yiv7555007458MsoHyperlink
{color:blue;text-decoration:underline;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 a:visited, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 span.ygrps-yiv-1034368617yiv7555007458MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 code
{}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 pre
{margin:0in;margin-bottom:.0001pt;font-size:10.0pt;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 tt
{}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 p.ygrps-yiv-1034368617yiv7555007458MsoAcetate, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 li.ygrps-yiv-1034368617yiv7555007458MsoAcetate, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 span.ygrps-yiv-1034368617yiv7555007458cat
{}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 span.ygrps-yiv-1034368617yiv7555007458ct
{}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 span.ygrps-yiv-1034368617yiv7555007458HTMLPreformattedChar
{font-family:Consolas;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 p.ygrps-yiv-1034368617yiv7555007458attach, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 li.ygrps-yiv-1034368617yiv7555007458attach, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458attach
{margin-right:0in;margin-left:0in;font-size:9.0pt;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 p.ygrps-yiv-1034368617yiv7555007458bold, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 li.ygrps-yiv-1034368617yiv7555007458bold, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458bold
{margin-right:0in;margin-left:0in;font-size:10.0pt;font-weight:bold;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 p.ygrps-yiv-1034368617yiv7555007458green, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 li.ygrps-yiv-1034368617yiv7555007458green, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458green
{margin-right:0in;margin-left:0in;font-size:12.0pt;color:#628C2A;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 p.ygrps-yiv-1034368617yiv7555007458replbq, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 li.ygrps-yiv-1034368617yiv7555007458replbq, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458replbq
{margin:3.0pt;font-size:12.0pt;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 p.ygrps-yiv-1034368617yiv7555007458ad, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 li.ygrps-yiv-1034368617yiv7555007458ad, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458ad
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 p.ygrps-yiv-1034368617yiv7555007458underline, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 li.ygrps-yiv-1034368617yiv7555007458underline, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458underline
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 span.ygrps-yiv-1034368617yiv7555007458yshortcuts
{}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 p.ygrps-yiv-1034368617yiv7555007458ad1, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 li.ygrps-yiv-1034368617yiv7555007458ad1, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458ad1
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 p.ygrps-yiv-1034368617yiv7555007458ad2, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 li.ygrps-yiv-1034368617yiv7555007458ad2, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458ad2
{margin-right:0in;margin-bottom:7.5pt;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 p.ygrps-yiv-1034368617yiv7555007458underline1, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 li.ygrps-yiv-1034368617yiv7555007458underline1, #ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458underline1
{margin-right:0in;margin-left:0in;font-size:12.0pt;text-decoration:underline;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 span.ygrps-yiv-1034368617yiv7555007458yshortcuts1
{font-weight:bold;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 span.ygrps-yiv-1034368617yiv7555007458yshortcuts2
{font-weight:normal;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 span.ygrps-yiv-1034368617yiv7555007458EmailStyle36
{color:#1F497D;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 span.ygrps-yiv-1034368617yiv7555007458BalloonTextChar
{}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 .ygrps-yiv-1034368617yiv7555007458MsoChpDefault
{font-size:10.0pt;}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 div.ygrps-yiv-1034368617yiv7555007458WordSection1
{}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458
filtered #ygrps-yiv-1034368617yiv7555007458 {}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {font-family:Symbol;}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {font-family:Wingdings;}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {font-family:Wingdings;}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {font-family:Wingdings;}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {font-family:Wingdings;}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {font-family:Wingdings;}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {font-family:Wingdings;}
#ygrps-yiv-1034368617 filtered #ygrps-yiv-1034368617yiv7555007458 {font-family:Wingdings;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 ol
{margin-bottom:0in;}
#ygrps-yiv-1034368617 #ygrps-yiv-1034368617yiv7555007458 ul
{margin-bottom:0in;}
#ygrps-yiv-1034368617



We’ve converted all of our part descriptions to decimal with no leading zeros, simply for that reason.
 
I’ve also put some quick searches together using the part description “contains” and part number “begins” with.  I added the part description “Contains” several times in one quicksearch so that they can search for multiple things within the description at once.  The user then has to be trained to use an asterisk before and after their search words, but it works out pretty good for us.
 
Sarah Cooley
Database Analyst
Lube-Power, Inc.
PH:  586-247-6500 Ext. 258
scooley@...
 


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 19, 2014 3:51 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Part Search (Description Contains)
 
 
SQL database. Epicor version 10.0.700.3
 
No, it is stored in the database as 3/4
 

From: "Todd Caughey tcaughey@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, November 19, 2014 3:24 PM
Subject: RE: [Vantage] Part Search (Description Contains)
 
 
Is it the ¾ (small one character version) rather than 3 slash 4 (three characters)?  I think the one character version is ASCII 190.
-Todd C.
 
 
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 19, 2014 2:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Search (Description Contains)
 
 
Hi all,

This seems really stupid but how do you search for a part where the description contains 3/4 for example? When I try this it returns zero records. Is there a special wildcard character that needs to be used?

Thanks,

Ted