8.03 Wildcard Part Description Search

Yahoo Archive
1
Mr. Johnson writes:
> IF SO EASY WHY DOESN'T EPICOR DO IT?!

There are plenty of things that I want Epicor to do. However, if I can get
around something like this search thing while they spend some time on getting
a Job to Engineer and Release in under a minute, I'd prefer that they worked
on that first. If they can make the system faster, more stable then I'd rather
they work on that. There are a lot of little things I wish they'd fix, like
focusing on the search box when you click on the search buttons, but I'll take
performance and stability when I have a work around.

> ...You haven't told me or anyone else on this blog anything we don't already
> know.

I wasn't so sure that everyone in the newsgroup knows about the Advanced
Search tab which is why I posted it.

Mark W.
2
Vantage 8.03.305F Help says you can enter something like bm* in the Part Search's "Description contains" filter. This should give all parts whose description contains any word that begins with bm. This works on a Progress/OpenEdge database but aborts on SQL. Has any SQL user gotten search wildcards to work?

[Non-text portions of this message have been removed]
3
As noted before in this group, the wildcard search in Epicor's
software is weak. You can only search for words that 'begin with'
characters, not for characters in the middle of end of a word. We have
created dashboards that do have better search techniques either
through the use of MATCHES or other customizations. I wish Epicor
would get on the ball and incorporate these more complete search
techniques into their commonly used fields.

Rich J
ERMC


--- In vantage@yahoogroups.com, "Chris Robisch" <bluewine@...> wrote:
>
> Vantage 8.03.305F Help says you can enter something like bm* in the
Part Search's "Description contains" filter. This should give all
parts whose description contains any word that begins with bm. This
works on a Progress/OpenEdge database but aborts on SQL. Has any SQL
user gotten search wildcards to work?
>
> [Non-text portions of this message have been removed]
>
4
I am under the impression that a 'wildcard' is unecessary in the part
description contains search box. I just tried a search in our
progress db for 8-32 and everything that has 8-32 in the description
was returned regardless of position.

--- In vantage@yahoogroups.com, "ermc_v" <rjohnson@...> wrote:
>
> As noted before in this group, the wildcard search in Epicor's
> software is weak. You can only search for words that 'begin with'
> characters, not for characters in the middle of end of a word. We
have
> created dashboards that do have better search techniques either
> through the use of MATCHES or other customizations. I wish Epicor
> would get on the ball and incorporate these more complete search
> techniques into their commonly used fields.
>
> Rich J
> ERMC
>
>
> --- In vantage@yahoogroups.com, "Chris Robisch" <bluewine@> wrote:
> >
> > Vantage 8.03.305F Help says you can enter something like bm* in
the
> Part Search's "Description contains" filter. This should give all
> parts whose description contains any word that begins with bm. This
> works on a Progress/OpenEdge database but aborts on SQL. Has any
SQL
> user gotten search wildcards to work?
> >
> > [Non-text portions of this message have been removed]
> >
>
5
> I am under the impression that a 'wildcard' is unecessary in the part
> description contains search box. I just tried a search in our
> progress db for 8-32 and everything that has 8-32 in the description
> was returned regardless of position.

Moreover, anything typed on the same line is an AND operation and anything on
the next line is an OR operation. For example:

"SCREW SS" - finds all stainless steel screws
"SCREW 1/2 SS" - finds all 1/2 in, 1-1/2 in, etc. stainless steel screws

"SCREW 1/2" <newline>
"NUT 1/2" - finds all screws and nuts that have a 1/2 in. increment.

Works quite well here, but like Bruce, we're also on Progress.

Mark W.
6
Yes - but try typing *REW, *REW* or REW and you will find no screws!
This is the only database system I have worked with that does not
have functionality like this built into the base GUI.

--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...>
wrote:
>
> > I am under the impression that a 'wildcard' is unecessary in the
part
> > description contains search box. I just tried a search in our
> > progress db for 8-32 and everything that has 8-32 in the
description
> > was returned regardless of position.
>
> Moreover, anything typed on the same line is an AND operation and
anything on
> the next line is an OR operation. For example:
>
> "SCREW SS" - finds all stainless steel screws
> "SCREW 1/2 SS" - finds all 1/2 in, 1-1/2 in, etc. stainless steel
screws
>
> "SCREW 1/2" <newline>
> "NUT 1/2" - finds all screws and nuts that have a 1/2 in.
increment.
>
> Works quite well here, but like Bruce, we're also on Progress.
>
> Mark W.
>
7
> Yes - but try typing *REW, *REW* or REW and you will find no screws!
> This is the only database system I have worked with that does not
> have functionality like this built into the base GUI.

You're right. Out of the box, the "Description Contains" field does not work
in the way that one who works with databases might think. It works on whole
words only and you can only wildcard the beginning of the word. SCR* will
return all of the screws.

But all hope is not lost. Vantage makes it quite easy (via BAQ/Quick Search
entry) to get to the "*REW", "*REW*", and "REW*" non-word-based search that
geeks like us all know and love.

Mark W.
8
(I'm tired of dead-horse beating)
IF SO EASY WHY DOESN'T EPICOR DO IT?! You haven't told me or anyone
else on this blog anything we don't already know. End of story.


--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...>
wrote:
>
> > Yes - but try typing *REW, *REW* or REW and you will find no
screws!
> > This is the only database system I have worked with that does not
> > have functionality like this built into the base GUI.
>
> You're right. Out of the box, the "Description Contains" field
does not work
> in the way that one who works with databases might think. It works
on whole
> words only and you can only wildcard the beginning of the word.
SCR* will
> return all of the screws.
>
> But all hope is not lost. Vantage makes it quite easy (via
BAQ/Quick Search
> entry) to get to the "*REW", "*REW*", and "REW*" non-word-based
search that
> geeks like us all know and love.
>
> Mark W.
>
9
Ask me about my 'consulting conspiracy theory' sometime.

Todd

________________________________

From: vantage@yahoogroups.com on behalf of ermc_v
Sent: Fri 5/4/2007 4:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: 8.03 Wildcard Part Description Search



(I'm tired of dead-horse beating)
IF SO EASY WHY DOESN'T EPICOR DO IT?! You haven't told me or anyone
else on this blog anything we don't already know. End of story.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Mark Wonsil" <mark_wonsil@...>
wrote:
>
> > Yes - but try typing *REW, *REW* or REW and you will find no
screws!
> > This is the only database system I have worked with that does not
> > have functionality like this built into the base GUI.
>
> You're right. Out of the box, the "Description Contains" field
does not work
> in the way that one who works with databases might think. It works
on whole
> words only and you can only wildcard the beginning of the word.
SCR* will
> return all of the screws.
>
> But all hope is not lost. Vantage makes it quite easy (via
BAQ/Quick Search
> entry) to get to the "*REW", "*REW*", and "REW*" non-word-based
search that
> geeks like us all know and love.
>
> Mark W.
>






This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

[Non-text portions of this message have been removed]
10
This would be a good story <chuckle>.



Charlie Smith

Smith Business Services / 2W Technologies LLC

www.vistaconsultant.com <http://www.vistaconsultant.com/> /
www.2wtech.com <http://www.2wtech.com/>







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Friday, May 04, 2007 5:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: 8.03 Wildcard Part Description Search



Ask me about my 'consulting conspiracy theory' sometime.

Todd





[Non-text portions of this message have been removed]
11
Todd writes:
>
> Ask me about my 'consulting conspiracy theory' sometime.
>

I wish you would have said this earlier. Our CAM just quoted us Advanced
Consulting Conspiracy Theory...

;-)