Part description search

system · September 18, 2012, 5:53am

We have a similar problem using AND with 2 wildcards.

For example we have parts with the description of 'Outer Formed Panels' of
various sizes/colours etc.

In previous versions of E9 (9.04 & 9.05.606A) we were able to search using
OUT* FORM* which returned a load of records, however since moving to
9.05.700B2 this no longer works. This is definitely the case as we still
have 9.05.606A on one of our test servers.

Any suggestions?

The main problem is because users expect results with 2 wildcards, if the
search returns nothing they assume there are no records, when it is the
search that is no longer working as it did.

Thanks,

Darryn

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wonsil
Sent: 12 September 2012 03:14
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Part description search

Try putting * in there too.

On Sep 11, 2012, at 9:20 PM, Neil Buckman
<nbuckman@...>
wrote:

Yes, we get nothing if we enter after the first line and put nothing on the
second.

And if a comma is in the middle of the text we get an error.

- Neil Buckman

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ned
Sent: Wednesday, 12 September 2012 10:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Part description search

Also be warned, you will likely get errors if you hit return and then put
nothing on the second line.

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Neil
Buckman
Sent: Tuesday, September 11, 2012 7:51 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Part description search

Thanks Mark,

I have it working now, but I was perplexed by the AND OR options.

I enter "alum 6500" on one line and I get all the aluminium that has 6500 in
the description. But if I put the same thing on 2 lines finds nothing.

It seems to need at least two words on the second line to work. So "alum
6500" on line one and "post red" on line two give correct OR results, but
"alum 6500" on line one and "post" on line two finds nothing. But reverse
the order ("post" on line one and "alum 6500" on line two) and it works.

Thanks for the tip. It is most useful.

- Neil Buckman

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Mark
Wonsil
Sent: Tuesday, 11 September 2012 12:30 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Re: Part description search

BTW, once you get your indexing set up, the command will AND on one one and
OR each line so:

alum nut

alum bolt

Will find all of your aluminum nuts and bolts.

Mark W.

On Sep 10, 2012, at 7:14 PM, Neil Buckman
<nbuckman@...<mailto:
nbuckman%40gibsonshopfitters.com.au><mailto:
nbuckman@...<mailto:nbuckman%40gibsonshopfitters.com.au

>>
>

wrote:

Thanks Chris,

I will follow this up.

Neil Buckman

Information Technology

[Description: Gibson Shopfitters]

DH Gibson Pty Ltd | 205-231 Fairfield Rd | YENNORA NSW 2161 Office 8724 4600
| Direct 8724 4618 | Fax 8724 4604 | Mobile 0413 125 994
nbuckman@...<mailto:nbuckman%40gibsonshopfitters.com.au

><mailto:nbuckman@...<mailto:

nbuckman%40gibsonshopfitters.com.au><m
ailto:nbuckman@...<mailto:
nbuckman%40gibsonshopfitters.com.au>%3cmailto:nbuckman@gibsonshopfitters.
com.au>>

| www.gibsonshopfitters.com.au<http://www.gibsonshopfitters.com.au>
<http://www.gibsonshopfitters.com.au/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>]<mailto:
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>]> On
Behalf Of

redrhyno13

Sent: Tuesday, 11 September 2012 5:24 AM

To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>

Subject: [Vantage] Re: Part description search

In 905.700b2 I had to run a couple of sql scripts furnished by tech support
to get the where part contains searches to work.

Chris Wineinger

Interior Systems Inc.

--- In
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:
vantage%40yahoogroups.com<mailto:vantage@yaho
ogroups.com%3cmailto:vantage%40yahoogroups.com>>, "nbuckman@
...<mailto:nbuckman@...><mailto:nbuckman@%0b...%3cmailto:nbuckman@...%3e>"
<nbuckman@...<mailto:nbuckman@...<mailto:nbuckman@...%3cmailto:nbuckman@
...<mailto:nbuckman@...%3cmailto:nbuckman@...%3cmailto:nbuckman@
...%3cmailto:nbuckman@...>>

>> wrote:

>

>

> In Epicor 9.05.700C there is a Part Description box in the basic part

search screen headed "Where part description contains..." that seems to
invite entry of a portion of a description to filter search results.

>

> Does anyone know how this works? I can get nothing from it at all. In

> the

engineering section of the Engineering Workbench as similar feature works
brilliantly.

>

> - Neil

>

Notice:This e-mail and any attachments are confidential and are only for the
use of the person to whom they are addressed. If you are not the intended
recipient please advise the sender by return e-mail and delete the message
and any attachments. Any use, interference with, disclosure or copying of
this message or any attachments is unauthorised and prohibited.

The sender does not warrant that the information is free of a virus or any
other defect or error, and any views expressed herein, unless specifically
indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )

(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.<
http://groups.yahoo.com/group/vantage/files/>

(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages

(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

http://groups.yahoo.com/group/vantage/

Individual Email | Traditional

http://groups.yahoo.com/group/vantage/join

(Yahoo! ID required)

vantage-digest@yahoogroups.com<mailto:vantage-digest%40yahoogroups.com

><mailto:vantage-digest@yahoogroups.com<mailto:

vantage-digest%40yahoogroups.com>>

vantage-fullfeatured@yahoogroups.com<mailto:
vantage-fullfeatured%40yahoogroups.com><mailto:
vantage-fullfeatured@yahoogroups
.com>

vantage-unsubscribe@yahoogroups.com<mailto:
vantage-unsubscribe%40yahoogroups.com><mailto:
vantage-unsubscribe@yahoogroups.c<mailto:vantage-unsubscribe%40yahoogroups.c

>

om>

http://docs.yahoo.com/info/terms/

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.<
http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

system · September 10, 2012, 3:55am

In Epicor 9.05.700C there is a Part Description box in the basic part search screen headed "Where part description contains..." that seems to invite entry of a portion of a description to filter search results.

Does anyone know how this works? I can get nothing from it at all. In the engineering section of the Engineering Workbench as similar feature works brilliantly.

- Neil

system · September 10, 2012, 9:11am

If you're SQL you need to turn on full text search in SQL - it's in the install manuals as a post install. If you're SQL2008 you don't need to create the directories first because the catalogs are now stored in the database (the other scripts and incremental update setup are still needed).

We just enabled this again but are re-evaluating how often we update the catalogs. We saw a couple SQL locks the first day we had it enabled when edit lists were running. I could tell the catalog update was hung too. I will probably only update the catalogs once a day after hours as a caution for now.

--- In vantage@yahoogroups.com, "nbuckman@..." <nbuckman@...> wrote:

In Epicor 9.05.700C there is a Part Description box in the basic part search screen headed "Where part description contains..." that seems to invite entry of a portion of a description to filter search results.

Does anyone know how this works? I can get nothing from it at all. In the engineering section of the Engineering Workbench as similar feature works brilliantly.

- Neil

system · September 10, 2012, 3:23pm

In 905.700b2 I had to run a couple of sql scripts furnished by tech support to get the where part contains searches to work.

Chris Wineinger
Interior Systems Inc.

--- In vantage@yahoogroups.com, "nbuckman@..." <nbuckman@...> wrote:
>
>
> In Epicor 9.05.700C there is a Part Description box in the basic part search screen headed "Where part description contains..." that seems to invite entry of a portion of a description to filter search results.
>
> Does anyone know how this works? I can get nothing from it at all. In the engineering section of the Engineering Workbench as similar feature works brilliantly.
>
> - Neil
>

system · September 10, 2012, 7:14pm

Thanks Jennifer,

I will follow this up.

Neil Buckman
Information Technology

[Description: Gibson Shopfitters]

DH Gibson Pty Ltd | 205-231 Fairfield Rd | YENNORA NSW 2161
Office 8724 4600 | Direct 8724 4618 | Fax 8724 4604 | Mobile 0413 125 994
nbuckman@...<mailto:nbuckman@...> | www.gibsonshopfitters.com.au <http://www.gibsonshopfitters.com.au/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jennifer
Sent: Monday, 10 September 2012 11:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Part description search

If you're SQL you need to turn on full text search in SQL - it's in the install manuals as a post install. If you're SQL2008 you don't need to create the directories first because the catalogs are now stored in the database (the other scripts and incremental update setup are still needed).

We just enabled this again but are re-evaluating how often we update the catalogs. We saw a couple SQL locks the first day we had it enabled when edit lists were running. I could tell the catalog update was hung too. I will probably only update the catalogs once a day after hours as a caution for now.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "nbuckman@...<mailto:nbuckman@...>" <nbuckman@...<mailto:nbuckman@...>> wrote:

In Epicor 9.05.700C there is a Part Description box in the basic part search screen headed "Where part description contains..." that seems to invite entry of a portion of a description to filter search results.

Does anyone know how this works? I can get nothing from it at all. In the engineering section of the Engineering Workbench as similar feature works brilliantly.

- Neil

Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.

[Non-text portions of this message have been removed]

system · September 10, 2012, 7:14pm

Thanks Chris,

I will follow this up.

Neil Buckman
Information Technology

[Description: Gibson Shopfitters]

DH Gibson Pty Ltd | 205-231 Fairfield Rd | YENNORA NSW 2161
Office 8724 4600 | Direct 8724 4618 | Fax 8724 4604 | Mobile 0413 125 994
nbuckman@...<mailto:nbuckman@...> | www.gibsonshopfitters.com.au <http://www.gibsonshopfitters.com.au/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of redrhyno13
Sent: Tuesday, 11 September 2012 5:24 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Part description search

In 905.700b2 I had to run a couple of sql scripts furnished by tech support to get the where part contains searches to work.

Chris Wineinger
Interior Systems Inc.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "nbuckman@...<mailto:nbuckman@...>" <nbuckman@...<mailto:nbuckman@...>> wrote:
>
>
> In Epicor 9.05.700C there is a Part Description box in the basic part search screen headed "Where part description contains..." that seems to invite entry of a portion of a description to filter search results.
>
> Does anyone know how this works? I can get nothing from it at all. In the engineering section of the Engineering Workbench as similar feature works brilliantly.
>
> - Neil
>

Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.

[Non-text portions of this message have been removed]

system · September 10, 2012, 10:29pm

BTW, once you get your indexing set up, the command will AND on one one and
OR each line so:

alum nut
alum bolt

Will find all of your aluminum nuts and bolts.

Mark W.

On Sep 10, 2012, at 7:14 PM, Neil Buckman <nbuckman@...>
wrote:

Thanks Chris,

I will follow this up.

Neil Buckman
Information Technology

[Description: Gibson Shopfitters]

DH Gibson Pty Ltd | 205-231 Fairfield Rd | YENNORA NSW 2161
Office 8724 4600 | Direct 8724 4618 | Fax 8724 4604 | Mobile 0413 125 994
nbuckman@...<mailto:nbuckman@...>
| www.gibsonshopfitters.com.au <http://www.gibsonshopfitters.com.au/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
redrhyno13
Sent: Tuesday, 11 September 2012 5:24 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Part description search

In 905.700b2 I had to run a couple of sql scripts furnished by tech support
to get the where part contains searches to work.

Chris Wineinger
Interior Systems Inc.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "nbuckman@
...<mailto:nbuckman@...>" <nbuckman@...<mailto:nbuckman@...>> wrote:

>
>
> In Epicor 9.05.700C there is a Part Description box in the basic part

search screen headed "Where part description contains..." that seems to
invite entry of a portion of a description to filter search results.

>
> Does anyone know how this works? I can get nothing from it at all. In the

engineering section of the Engineering Workbench as similar feature works
brilliantly.

>
> - Neil
>

Notice:This e-mail and any attachments are confidential and are only for
the use of the person to whom they are addressed. If you are not the
intended recipient please advise the sender by return e-mail and delete the
message and any attachments. Any use, interference with, disclosure or
copying of this message or any attachments is unauthorised and prohibited.
The sender does not warrant that the information is free of a virus or any
other defect or error, and any views expressed herein, unless specifically
indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · September 11, 2012, 7:51pm

Thanks Mark,

I have it working now, but I was perplexed by the AND OR options.

I enter "alum 6500" on one line and I get all the aluminium that has 6500 in the description. But if I put the same thing on 2 lines finds nothing.

It seems to need at least two words on the second line to work. So "alum 6500" on line one and "post red" on line two give correct OR results, but "alum 6500" on line one and "post" on line two finds nothing. But reverse the order ("post" on line one and "alum 6500" on line two) and it works.

Thanks for the tip. It is most useful.

- Neil Buckman

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: Tuesday, 11 September 2012 12:30 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Part description search

BTW, once you get your indexing set up, the command will AND on one one and OR each line so:

alum nut

alum bolt

Will find all of your aluminum nuts and bolts.

Mark W.

On Sep 10, 2012, at 7:14 PM, Neil Buckman <nbuckman@...<mailto:nbuckman@...>>

wrote:

Thanks Chris,

I will follow this up.

Neil Buckman

Information Technology

[Description: Gibson Shopfitters]

DH Gibson Pty Ltd | 205-231 Fairfield Rd | YENNORA NSW 2161 Office 8724 4600 | Direct 8724 4618 | Fax 8724 4604 | Mobile 0413 125 994 nbuckman@...<mailto:nbuckman@...<mailto:nbuckman@...%3cmailto:nbuckman@...>>

| www.gibsonshopfitters.com.au<http://www.gibsonshopfitters.com.au> <http://www.gibsonshopfitters.com.au/>

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]<mailto:[mailto:vantage@yahoogroups.com]> On Behalf Of

redrhyno13

Sent: Tuesday, 11 September 2012 5:24 AM

To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>

Subject: [Vantage] Re: Part description search

In 905.700b2 I had to run a couple of sql scripts furnished by tech support to get the where part contains searches to work.

Chris Wineinger

Interior Systems Inc.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage%40yahoogroups.com>>, "nbuckman@ ...<mailto:nbuckman@...>" <nbuckman@...<mailto:nbuckman@...<mailto:nbuckman@...%3cmailto:nbuckman@...>>> wrote:

>

>

> In Epicor 9.05.700C there is a Part Description box in the basic part

search screen headed "Where part description contains..." that seems to invite entry of a portion of a description to filter search results.

>

> Does anyone know how this works? I can get nothing from it at all. In

> the

engineering section of the Engineering Workbench as similar feature works brilliantly.

>

> - Neil

>

Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited.

The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )

(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.

(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages

(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

http://groups.yahoo.com/group/vantage/

Individual Email | Traditional

http://groups.yahoo.com/group/vantage/join

(Yahoo! ID required)

vantage-digest@yahoogroups.com<mailto:vantage-digest@yahoogroups.com>

vantage-fullfeatured@yahoogroups.com<mailto:vantage-fullfeatured@yahoogroups.com>

vantage-unsubscribe@yahoogroups.com<mailto:vantage-unsubscribe@yahoogroups.com>

http://docs.yahoo.com/info/terms/

[Non-text portions of this message have been removed]

system · September 11, 2012, 8:48pm

Also be warned, you will likely get errors if you hit return and then put
nothing on the second line.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Neil Buckman
Sent: Tuesday, September 11, 2012 7:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Part description search

Thanks Mark,

I have it working now, but I was perplexed by the AND OR options.

I enter "alum 6500" on one line and I get all the aluminium that has 6500 in
the description. But if I put the same thing on 2 lines finds nothing.

It seems to need at least two words on the second line to work. So "alum
6500" on line one and "post red" on line two give correct OR results, but
"alum 6500" on line one and "post" on line two finds nothing. But reverse
the order ("post" on line one and "alum 6500" on line two) and it works.

Thanks for the tip. It is most useful.

- Neil Buckman

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wonsil
Sent: Tuesday, 11 September 2012 12:30 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Part description search

BTW, once you get your indexing set up, the command will AND on one one and
OR each line so:

alum nut

alum bolt

Will find all of your aluminum nuts and bolts.

Mark W.

On Sep 10, 2012, at 7:14 PM, Neil Buckman
<nbuckman@...<mailto:nbuckman@...>

>

wrote:

Thanks Chris,

I will follow this up.

Neil Buckman

Information Technology

[Description: Gibson Shopfitters]

DH Gibson Pty Ltd | 205-231 Fairfield Rd | YENNORA NSW 2161 Office 8724 4600
| Direct 8724 4618 | Fax 8724 4604 | Mobile 0413 125 994
nbuckman@...<mailto:nbuckman@...<m
ailto:nbuckman@...%3cmailto:nbuckman@gibsonshopfitters.
com.au>>

| www.gibsonshopfitters.com.au<http://www.gibsonshopfitters.com.au>
<http://www.gibsonshopfitters.com.au/>

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
[mailto:vantage@yahoogroups.com]<mailto:[mailto:vantage@yahoogroups.com]> On
Behalf Of

redrhyno13

Sent: Tuesday, 11 September 2012 5:24 AM

To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>

Subject: [Vantage] Re: Part description search

In 905.700b2 I had to run a couple of sql scripts furnished by tech support
to get the where part contains searches to work.

Chris Wineinger

Interior Systems Inc.

--- In
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com<mailto:vantage@yaho
ogroups.com%3cmailto:vantage%40yahoogroups.com>>, "nbuckman@
...<mailto:nbuckman@...>"
<nbuckman@...<mailto:nbuckman@...<mailto:nbuckman@...%3cmailto:nbuckman@...>

>> wrote:

>

>

> In Epicor 9.05.700C there is a Part Description box in the basic part

search screen headed "Where part description contains..." that seems to
invite entry of a portion of a description to filter search results.

>

> Does anyone know how this works? I can get nothing from it at all. In

> the

engineering section of the Engineering Workbench as similar feature works
brilliantly.

>

> - Neil

>

Notice:This e-mail and any attachments are confidential and are only for the
use of the person to whom they are addressed. If you are not the intended
recipient please advise the sender by return e-mail and delete the message
and any attachments. Any use, interference with, disclosure or copying of
this message or any attachments is unauthorised and prohibited.

The sender does not warrant that the information is free of a virus or any
other defect or error, and any views expressed herein, unless specifically
indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )

(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.

(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages

(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

http://groups.yahoo.com/group/vantage/

Individual Email | Traditional

http://groups.yahoo.com/group/vantage/join

(Yahoo! ID required)

vantage-digest@yahoogroups.com<mailto:vantage-digest@yahoogroups.com>

vantage-fullfeatured@yahoogroups.com<mailto:vantage-fullfeatured@yahoogroups
.com>

vantage-unsubscribe@yahoogroups.com<mailto:vantage-unsubscribe@yahoogroups.c
om>

http://docs.yahoo.com/info/terms/

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

system · September 11, 2012, 9:20pm

Yes, we get nothing if we enter after the first line and put nothing on the second.

And if a comma is in the middle of the text we get an error.

- Neil Buckman

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
Sent: Wednesday, 12 September 2012 10:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Part description search

Also be warned, you will likely get errors if you hit return and then put
nothing on the second line.

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Neil Buckman
Sent: Tuesday, September 11, 2012 7:51 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Part description search

Thanks Mark,

I have it working now, but I was perplexed by the AND OR options.

I enter "alum 6500" on one line and I get all the aluminium that has 6500 in
the description. But if I put the same thing on 2 lines finds nothing.

It seems to need at least two words on the second line to work. So "alum
6500" on line one and "post red" on line two give correct OR results, but
"alum 6500" on line one and "post" on line two finds nothing. But reverse
the order ("post" on line one and "alum 6500" on line two) and it works.

Thanks for the tip. It is most useful.

- Neil Buckman

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Mark Wonsil
Sent: Tuesday, 11 September 2012 12:30 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Re: Part description search

BTW, once you get your indexing set up, the command will AND on one one and
OR each line so:

alum nut

alum bolt

Will find all of your aluminum nuts and bolts.

Mark W.

On Sep 10, 2012, at 7:14 PM, Neil Buckman
<nbuckman@...<mailto:nbuckman%40gibsonshopfitters.com.au><mailto:nbuckman@...<mailto:nbuckman%40gibsonshopfitters.com.au>>

>

wrote:

Thanks Chris,

I will follow this up.

Neil Buckman

Information Technology

[Description: Gibson Shopfitters]

DH Gibson Pty Ltd | 205-231 Fairfield Rd | YENNORA NSW 2161 Office 8724 4600
| Direct 8724 4618 | Fax 8724 4604 | Mobile 0413 125 994
nbuckman@...<mailto:nbuckman%40gibsonshopfitters.com.au><mailto:nbuckman@...<mailto:nbuckman%40gibsonshopfitters.com.au><m
ailto:nbuckman@...<mailto:nbuckman%40gibsonshopfitters.com.au>%3cmailto:nbuckman@gibsonshopfitters.
com.au>>

| www.gibsonshopfitters.com.au<http://www.gibsonshopfitters.com.au>
<http://www.gibsonshopfitters.com.au/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>]<mailto:[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>]> On
Behalf Of

redrhyno13

Sent: Tuesday, 11 September 2012 5:24 AM

To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>

Subject: [Vantage] Re: Part description search

In 905.700b2 I had to run a couple of sql scripts furnished by tech support
to get the where part contains searches to work.

Chris Wineinger

Interior Systems Inc.

--- In
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com<mailto:vantage@yaho
ogroups.com%3cmailto:vantage%40yahoogroups.com>>, "nbuckman@
...<mailto:nbuckman@...><mailto:nbuckman@%0b...%3cmailto:nbuckman@...%3e>"
<nbuckman@...<mailto:nbuckman@...<mailto:nbuckman@...%3cmailto:nbuckman@...<mailto:nbuckman@...%3cmailto:nbuckman@...%3cmailto:nbuckman@...%3cmailto:nbuckman@...>>

>> wrote:

>

>

> In Epicor 9.05.700C there is a Part Description box in the basic part

search screen headed "Where part description contains..." that seems to
invite entry of a portion of a description to filter search results.

>

> Does anyone know how this works? I can get nothing from it at all. In

> the

engineering section of the Engineering Workbench as similar feature works
brilliantly.

>

> - Neil

>

Notice:This e-mail and any attachments are confidential and are only for the
use of the person to whom they are addressed. If you are not the intended
recipient please advise the sender by return e-mail and delete the message
and any attachments. Any use, interference with, disclosure or copying of
this message or any attachments is unauthorised and prohibited.

The sender does not warrant that the information is free of a virus or any
other defect or error, and any views expressed herein, unless specifically
indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )

(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>

(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages

(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

http://groups.yahoo.com/group/vantage/

Individual Email | Traditional

http://groups.yahoo.com/group/vantage/join

(Yahoo! ID required)

vantage-digest@yahoogroups.com<mailto:vantage-digest%40yahoogroups.com><mailto:vantage-digest@yahoogroups.com<mailto:vantage-digest%40yahoogroups.com>>

vantage-fullfeatured@yahoogroups.com<mailto:vantage-fullfeatured%40yahoogroups.com><mailto:vantage-fullfeatured@yahoogroups
.com>

vantage-unsubscribe@yahoogroups.com<mailto:vantage-unsubscribe%40yahoogroups.com><mailto:vantage-unsubscribe@yahoogroups.c<mailto:vantage-unsubscribe%40yahoogroups.c>
om>

http://docs.yahoo.com/info/terms/

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]

system · September 11, 2012, 9:24pm

There might be bugs Ned? Wha...?

:-|

On Sep 11, 2012, at 8:47 PM, Ned <TechnoBabbly@...> wrote:

Also be warned, you will likely get errors if you hit return and then put
nothing on the second line.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Neil Buckman
Sent: Tuesday, September 11, 2012 7:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Part description search

Thanks Mark,

I have it working now, but I was perplexed by the AND OR options.

I enter "alum 6500" on one line and I get all the aluminium that has 6500 in
the description. But if I put the same thing on 2 lines finds nothing.

It seems to need at least two words on the second line to work. So "alum
6500" on line one and "post red" on line two give correct OR results, but
"alum 6500" on line one and "post" on line two finds nothing. But reverse
the order ("post" on line one and "alum 6500" on line two) and it works.

Thanks for the tip. It is most useful.

- Neil Buckman

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wonsil
Sent: Tuesday, 11 September 2012 12:30 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Part description search

BTW, once you get your indexing set up, the command will AND on one one and
OR each line so:

alum nut

alum bolt

Will find all of your aluminum nuts and bolts.

Mark W.

On Sep 10, 2012, at 7:14 PM, Neil Buckman
<nbuckman@...<mailto:nbuckman@...>
>

wrote:

Thanks Chris,

I will follow this up.

Neil Buckman

Information Technology

[Description: Gibson Shopfitters]

DH Gibson Pty Ltd | 205-231 Fairfield Rd | YENNORA NSW 2161 Office 8724 4600
| Direct 8724 4618 | Fax 8724 4604 | Mobile 0413 125 994
nbuckman@...<mailto:nbuckman@...<m
ailto:nbuckman@...%3cmailto:nbuckman@gibsonshopfitters.
com.au>>

| www.gibsonshopfitters.com.au<http://www.gibsonshopfitters.com.au>
<http://www.gibsonshopfitters.com.au/>

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
[mailto:vantage@yahoogroups.com]<mailto:[mailto:vantage@yahoogroups.com]> On
Behalf Of

redrhyno13

Sent: Tuesday, 11 September 2012 5:24 AM

To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>

Subject: [Vantage] Re: Part description search

In 905.700b2 I had to run a couple of sql scripts furnished by tech support
to get the where part contains searches to work.

Chris Wineinger

Interior Systems Inc.

--- In
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com<mailto:vantage@yaho
ogroups.com%3cmailto:vantage%40yahoogroups.com>>, "nbuckman@
...<mailto:nbuckman@...>"
<nbuckman@...<mailto:nbuckman@...<mailto:nbuckman@...%3cmailto:nbuckman@...>
>> wrote:

>

>

> In Epicor 9.05.700C there is a Part Description box in the basic part

search screen headed "Where part description contains..." that seems to
invite entry of a portion of a description to filter search results.

>

> Does anyone know how this works? I can get nothing from it at all. In

> the

engineering section of the Engineering Workbench as similar feature works
brilliantly.

>

> - Neil

>

Notice:This e-mail and any attachments are confidential and are only for the
use of the person to whom they are addressed. If you are not the intended
recipient please advise the sender by return e-mail and delete the message
and any attachments. Any use, interference with, disclosure or copying of
this message or any attachments is unauthorised and prohibited.

The sender does not warrant that the information is free of a virus or any
other defect or error, and any views expressed herein, unless specifically
indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )

(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.

(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages

(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

http://groups.yahoo.com/group/vantage/

Individual Email | Traditional

http://groups.yahoo.com/group/vantage/join

(Yahoo! ID required)

vantage-digest@yahoogroups.com<mailto:vantage-digest@yahoogroups.com>

vantage-fullfeatured@yahoogroups.com<mailto:vantage-fullfeatured@yahoogroups
.com>

vantage-unsubscribe@yahoogroups.com<mailto:vantage-unsubscribe@yahoogroups.c
om>

http://docs.yahoo.com/info/terms/

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]

system · September 11, 2012, 10:14pm

Try putting * in there too.

On Sep 11, 2012, at 9:20 PM, Neil Buckman <nbuckman@...>
wrote:

Yes, we get nothing if we enter after the first line and put nothing on the
second.

And if a comma is in the middle of the text we get an error.

- Neil Buckman

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ned
Sent: Wednesday, 12 September 2012 10:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Part description search

Also be warned, you will likely get errors if you hit return and then put
nothing on the second line.

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Neil Buckman
Sent: Tuesday, September 11, 2012 7:51 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Part description search

Thanks Mark,

I have it working now, but I was perplexed by the AND OR options.

I enter "alum 6500" on one line and I get all the aluminium that has 6500 in
the description. But if I put the same thing on 2 lines finds nothing.

It seems to need at least two words on the second line to work. So "alum
6500" on line one and "post red" on line two give correct OR results, but
"alum 6500" on line one and "post" on line two finds nothing. But reverse
the order ("post" on line one and "alum 6500" on line two) and it works.

Thanks for the tip. It is most useful.

- Neil Buckman

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Mark Wonsil
Sent: Tuesday, 11 September 2012 12:30 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Re: Part description search

BTW, once you get your indexing set up, the command will AND on one one and
OR each line so:

alum nut

alum bolt

Will find all of your aluminum nuts and bolts.

Mark W.

On Sep 10, 2012, at 7:14 PM, Neil Buckman
<nbuckman@...<mailto:
nbuckman%40gibsonshopfitters.com.au><mailto:
nbuckman@...<mailto:nbuckman%40gibsonshopfitters.com.au

>>
>

wrote:

Thanks Chris,

I will follow this up.

Neil Buckman

Information Technology

[Description: Gibson Shopfitters]

DH Gibson Pty Ltd | 205-231 Fairfield Rd | YENNORA NSW 2161 Office 8724 4600
| Direct 8724 4618 | Fax 8724 4604 | Mobile 0413 125 994
nbuckman@...<mailto:nbuckman%40gibsonshopfitters.com.au

><mailto:nbuckman@...<mailto:

nbuckman%40gibsonshopfitters.com.au><m
ailto:nbuckman@...<mailto:
nbuckman%40gibsonshopfitters.com.au>%3cmailto:nbuckman@gibsonshopfitters.
com.au>>

| www.gibsonshopfitters.com.au<http://www.gibsonshopfitters.com.au>
<http://www.gibsonshopfitters.com.au/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>]<mailto:
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>]> On
Behalf Of

redrhyno13

Sent: Tuesday, 11 September 2012 5:24 AM

To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>

Subject: [Vantage] Re: Part description search

In 905.700b2 I had to run a couple of sql scripts furnished by tech support
to get the where part contains searches to work.

Chris Wineinger

Interior Systems Inc.

--- In
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:
vantage%40yahoogroups.com<mailto:vantage@yaho
ogroups.com%3cmailto:vantage%40yahoogroups.com>>, "nbuckman@
...<mailto:nbuckman@...><mailto:nbuckman@%0b...%3cmailto:nbuckman@...%3e>"
<nbuckman@...<mailto:nbuckman@...<mailto:nbuckman@...%3cmailto:nbuckman@
...<mailto:nbuckman@...%3cmailto:nbuckman@...%3cmailto:nbuckman@
...%3cmailto:nbuckman@...>>

>> wrote:

>

>

> In Epicor 9.05.700C there is a Part Description box in the basic part

search screen headed "Where part description contains..." that seems to
invite entry of a portion of a description to filter search results.

>

> Does anyone know how this works? I can get nothing from it at all. In

> the

engineering section of the Engineering Workbench as similar feature works
brilliantly.

>

> - Neil

>

Notice:This e-mail and any attachments are confidential and are only for the
use of the person to whom they are addressed. If you are not the intended
recipient please advise the sender by return e-mail and delete the message
and any attachments. Any use, interference with, disclosure or copying of
this message or any attachments is unauthorised and prohibited.

The sender does not warrant that the information is free of a virus or any
other defect or error, and any views expressed herein, unless specifically
indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )

(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.<
http://groups.yahoo.com/group/vantage/files/>

(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages

(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

http://groups.yahoo.com/group/vantage/

Individual Email | Traditional

http://groups.yahoo.com/group/vantage/join

(Yahoo! ID required)

vantage-digest@yahoogroups.com<mailto:vantage-digest%40yahoogroups.com

><mailto:vantage-digest@yahoogroups.com<mailto:

vantage-digest%40yahoogroups.com>>

vantage-fullfeatured@yahoogroups.com<mailto:
vantage-fullfeatured%40yahoogroups.com><mailto:
vantage-fullfeatured@yahoogroups
.com>

vantage-unsubscribe@yahoogroups.com<mailto:
vantage-unsubscribe%40yahoogroups.com><mailto:
vantage-unsubscribe@yahoogroups.c<mailto:vantage-unsubscribe%40yahoogroups.c

>

om>

http://docs.yahoo.com/info/terms/

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.<
http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]