Search masters using wildcards

Yahoo Archive
1
Hi Mark,

Thank you for the solution.

Regards,
Deepa



________________________________
From: Mark Wonsil <mark_wonsil@...>
To: vantage@yahoogroups.com
Sent: Tuesday, June 30, 2009 5:29:50 PM
Subject: RE: [Vantage] Search masters using wildcards





vantage@yahoogroups .com wrote:
> Same example, i tried the quick search based on the same
> method you have sent mail yesterday. but that was not helpful.
> i will repeat again: eg: if we search "?a" the search screen
> will show all the parts starting with "a" similiarly for all
> characters.

The "?" is not a valid pattern matching operator in Progress. Page 603 in
the ABL Developer's Reference
(http://www.progress.com/progress/products/documentation/docs/dvref/dvref.pd
f) says that the two matching operators are the period/full- stop ".", which
matches a single character, and the asterix "*", which matches zero or more
characters. The tilde "~" is the escape character in case you want to look
for ".", "*", or "~" within a string.

Given that, if I click on the search button for Part Maintence, click on the
Quick Search tab and select my wildcard quick search I've created and enter
"Q" in the search box, I'll only get part numbers that EQUAL the letter "Q".
If I enter "Q*", I will get a list of parts that begin with Q. If I enter
"*Q", I'll get a list of parts that end with "Q". Finally, if I enter "*Q*",
I'll get a list of parts that have the letter "Q" anywhere in the part
number. The real trick one is *~~.* will find all items that have a
period/full- stop in the part.

Creating a Quick Search Entry does NOT change the behavior of the Basic
search. You can however make a Quick Search Entry the default search when
you click the search button.

Hope that helps,

Mark W.







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

In Epicor 9.04.503B, Is it possible to search masters like customers, suppliers and parts using wildcard such as "?","*".

Thank you & Regards,
Deepa.M




[Non-text portions of this message have been removed]
3
Deepa asks:

> In Epicor 9.04.503B, Is it possible to search masters like
> customers, suppliers and parts using wildcard such as "?","*".

Yes, but you need to setup a QuickSearch by creating a BAQ and adding the
field that you want to wildcard search as your "like" field.

One can search part descriptions using a wildcard search as well. All
portions of strings on the same line are ANDed and each row are Ored.

Mark W.
4
Hi,

I tried by creating one BAQwith with querry "for each Part no-lock where ( Part.PartNum <> '?' ) by Part.PartNum by Part.PartDescription by Part.IUM ." By testing it showing all the parts and i linked it to one Quick search.

This querry is not correct one, since i don't have any part start with "?"

I am looking the querry like if we enter "?a" or "*a" it will show all the part starting with "a"

Is it possible?

Thank you & regards,
Deepa


________________________________
From: Mark Wonsil <mark_wonsil@...>
To: vantage@yahoogroups.com
Sent: Monday, June 29, 2009 2:47:26 PM
Subject: RE: [Vantage] Search masters using wildcards





Deepa asks:

> In Epicor 9.04.503B, Is it possible to search masters like
> customers, suppliers and parts using wildcard such as "?","*".

Yes, but you need to setup a QuickSearch by creating a BAQ and adding the
field that you want to wildcard search as your "like" field.

One can search part descriptions using a wildcard search as well. All
portions of strings on the same line are ANDed and each row are Ored.

Mark W.







[Non-text portions of this message have been removed]
5
Hi Deepa,

> I tried by creating one BAQwith with querry "for each Part
> no-lock where ( Part.PartNum <> '?' ) by Part.PartNum by
> Part.PartDescription by Part.IUM ." By testing it showing
> all the parts and i linked it to one Quick search.

Here's a Part example. Create a BAQ on the Part master and include the
fields you want displayed. Add the PartNumbert as a Like filed in the
BAQSearch tab and save it.

Next, go to the field that you want to search, right-mouse click and go to
QuickSearch Entry (your user ID must be enabled to do this!). Create a Quick
Search based on the BAQ. In the Criteria tab, add a selection for the part
number that "MATCHES" a prompted value. Make the Quick Search Shared and
Save it. (You can test it on the Actions menu too.)

Now the Quick Search is available on the Quick Search tab when you search
that field or you can make it the default search in the search maintenance.

Mark W.
6
? in Progress 4gl means null and I don't even think a BAQ will let you filter on a null. What you want is:

"for each Part no-lock where (Part.PartNum MATCHES 'A*') by Part.PartNum by Part.PartDescription by Part.IUM ."

If you are wanting to filter this in a quick search, then you would leave out the where clause (no filter in the BAQ) and use a "matches" filter in the quick search so that the user can enter what he is looking for.




________________________________
From: Deepa <deepait_10@...>
To: vantage@yahoogroups.com
Sent: Monday, June 29, 2009 7:59:16 AM
Subject: Re: [Vantage] Search masters using wildcards





Hi,

I tried by creating one BAQwith with querry "for each Part no-lock where ( Part.PartNum <> '?' ) by Part.PartNum by Part.PartDescriptio n by Part.IUM ." By testing it showing all the parts and i linked it to one Quick search.

This querry is not correct one, since i don't have any part start with "?"

I am looking the querry like if we enter "?a" or "*a" it will show all the part starting with "a"

Is it possible?

Thank you & regards,
Deepa

____________ _________ _________ __
From: Mark Wonsil <mark_wonsil@ yahoo.com>
To: vantage@yahoogroups .com
Sent: Monday, June 29, 2009 2:47:26 PM
Subject: RE: [Vantage] Search masters using wildcards

Deepa asks:

> In Epicor 9.04.503B, Is it possible to search masters like
> customers, suppliers and parts using wildcard such as "?","*".

Yes, but you need to setup a QuickSearch by creating a BAQ and adding the
field that you want to wildcard search as your "like" field.

One can search part descriptions using a wildcard search as well. All
portions of strings on the same line are ANDed and each row are Ored.

Mark W.

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







[Non-text portions of this message have been removed]
7
Hi Mark,

Thank you for the prompt solution.
I followed the same steps. but i couldnot search using "?". if i enter "?" in the part Quick search, nothing is showing in the search.
Does it prompt anything? I don;t see any prompted value.

Regards,
Deepa



________________________________
From: Mark Wonsil <mark_wonsil@...>
To: vantage@yahoogroups.com
Sent: Monday, June 29, 2009 4:18:50 PM
Subject: RE: [Vantage] Search masters using wildcards





Hi Deepa,

> I tried by creating one BAQwith with querry "for each Part
> no-lock where ( Part.PartNum <> '?' ) by Part.PartNum by
> Part.PartDescriptio n by Part.IUM ." By testing it showing
> all the parts and i linked it to one Quick search.

Here's a Part example. Create a BAQ on the Part master and include the
fields you want displayed. Add the PartNumbert as a Like filed in the
BAQSearch tab and save it.

Next, go to the field that you want to search, right-mouse click and go to
QuickSearch Entry (your user ID must be enabled to do this!). Create a Quick
Search based on the BAQ. In the Criteria tab, add a selection for the part
number that "MATCHES" a prompted value. Make the Quick Search Shared and
Save it. (You can test it on the Actions menu too.)

Now the Quick Search is available on the Quick Search tab when you search
that field or you can make it the default search in the search maintenance.

Mark W.







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

It is showing only parts start with "a" . if i give b* it is not showing part start with "b"

Thank You & Regards,
Deepa.M




________________________________
From: Steven Gotschall <sgotschall@...>
To: vantage@yahoogroups.com
Sent: Monday, June 29, 2009 4:29:32 PM
Subject: Re: [Vantage] Search masters using wildcards





? in Progress 4gl means null and I don't even think a BAQ will let you filter on a null. What you want is:

"for each Part no-lock where (Part.PartNum MATCHES 'A*') by Part.PartNum by Part.PartDescriptio n by Part.IUM ."

If you are wanting to filter this in a quick search, then you would leave out the where clause (no filter in the BAQ) and use a "matches" filter in the quick search so that the user can enter what he is looking for.

____________ _________ _________ __
From: Deepa <deepait_10@yahoo. com>
To: vantage@yahoogroups .com
Sent: Monday, June 29, 2009 7:59:16 AM
Subject: Re: [Vantage] Search masters using wildcards

Hi,

I tried by creating one BAQwith with querry "for each Part no-lock where ( Part.PartNum <> '?' ) by Part.PartNum by Part.PartDescriptio n by Part.IUM ." By testing it showing all the parts and i linked it to one Quick search.

This querry is not correct one, since i don't have any part start with "?"

I am looking the querry like if we enter "?a" or "*a" it will show all the part starting with "a"

Is it possible?

Thank you & regards,
Deepa

____________ _________ _________ __
From: Mark Wonsil <mark_wonsil@ yahoo.com>
To: vantage@yahoogroups .com
Sent: Monday, June 29, 2009 2:47:26 PM
Subject: RE: [Vantage] Search masters using wildcards

Deepa asks:

> In Epicor 9.04.503B, Is it possible to search masters like
> customers, suppliers and parts using wildcard such as "?","*".

Yes, but you need to setup a QuickSearch by creating a BAQ and adding the
field that you want to wildcard search as your "like" field.

One can search part descriptions using a wildcard search as well. All
portions of strings on the same line are ANDed and each row are Ored.

Mark W.

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

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







[Non-text portions of this message have been removed]
9
> It is showing only parts start with "a" . if i give b* it is
> not showing part start with "b"

Right. And if you enter *b*, you'll get all parts with an 'b' somewhere in
it.

Mark W.
10
Is there any customisation possibility?

Regards,
Deepa



----- Forwarded Message ----
From: Deepa <deepait_10@...>
To: vantage@yahoogroups.com
Sent: Monday, June 29, 2009 5:09:24 PM
Subject: Re: [Vantage] Search masters using wildcards





Hi,

It is showing only parts start with "a" . if i give b* it is not showing part start with "b"

Thank You & Regards,
Deepa.M

____________ _________ _________ __
From: Steven Gotschall <sgotschall@yahoo. com>
To: vantage@yahoogroups .com
Sent: Monday, June 29, 2009 4:29:32 PM
Subject: Re: [Vantage] Search masters using wildcards

? in Progress 4gl means null and I don't even think a BAQ will let you filter on a null. What you want is:

"for each Part no-lock where (Part.PartNum MATCHES 'A*') by Part.PartNum by Part.PartDescriptio n by Part.IUM ."

If you are wanting to filter this in a quick search, then you would leave out the where clause (no filter in the BAQ) and use a "matches" filter in the quick search so that the user can enter what he is looking for.

____________ _________ _________ __
From: Deepa <deepait_10@ yahoo. com>
To: vantage@yahoogroups .com
Sent: Monday, June 29, 2009 7:59:16 AM
Subject: Re: [Vantage] Search masters using wildcards

Hi,

I tried by creating one BAQwith with querry "for each Part no-lock where ( Part.PartNum <> '?' ) by Part.PartNum by Part.PartDescriptio n by Part.IUM ." By testing it showing all the parts and i linked it to one Quick search.

This querry is not correct one, since i don't have any part start with "?"

I am looking the querry like if we enter "?a" or "*a" it will show all the part starting with "a"

Is it possible?

Thank you & regards,
Deepa

____________ _________ _________ __
From: Mark Wonsil <mark_wonsil@ yahoo.com>
To: vantage@yahoogroups .com
Sent: Monday, June 29, 2009 2:47:26 PM
Subject: RE: [Vantage] Search masters using wildcards

Deepa asks:

> In Epicor 9.04.503B, Is it possible to search masters like
> customers, suppliers and parts using wildcard such as "?","*".

Yes, but you need to setup a QuickSearch by creating a BAQ and adding the
field that you want to wildcard search as your "like" field.

One can search part descriptions using a wildcard search as well. All
portions of strings on the same line are ANDed and each row are Ored.

Mark W.

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

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

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







[Non-text portions of this message have been removed]
11
vantage@yahoogroups.com wrote:
> Is there any customisation possibility?

What would you like to do?
12
Hi,

For searching masters using wildcards, is there any customisation possibility.

Thank you & Regards,
Deepa



________________________________
From: Mark Wonsil <mark_wonsil@...>
To: vantage@yahoogroups.com
Sent: Tuesday, June 30, 2009 4:01:35 PM
Subject: RE: [Vantage] Search masters using wildcards





vantage@yahoogroups .com wrote:
> Is there any customisation possibility?

What would you like to do?







[Non-text portions of this message have been removed]
13
> For searching masters using wildcards, is there any customisation
> possibility.

Do you mean the Quick Search form? Can you give an example?
14
Same example, i tried the quick search based on the same method you have sent mail yesterday. but that was not helpful.
i will repeat again: eg: if we search "?a" the search screen will show all the parts starting with "a" similiarly for all characters.

Regrads,
Deepa



________________________________
From: Mark Wonsil <mark_wonsil@...>
To: vantage@yahoogroups.com
Sent: Tuesday, June 30, 2009 4:26:44 PM
Subject: RE: [Vantage] Search masters using wildcards





> For searching masters using wildcards, is there any customisation
> possibility.

Do you mean the Quick Search form? Can you give an example?







[Non-text portions of this message have been removed]
15
vantage@yahoogroups.com wrote:
> Same example, i tried the quick search based on the same
> method you have sent mail yesterday. but that was not helpful.
> i will repeat again: eg: if we search "?a" the search screen
> will show all the parts starting with "a" similiarly for all
> characters.

The "?" is not a valid pattern matching operator in Progress. Page 603 in
the ABL Developer's Reference
(http://www.progress.com/progress/products/documentation/docs/dvref/dvref.pd
f) says that the two matching operators are the period/full-stop ".", which
matches a single character, and the asterix "*", which matches zero or more
characters. The tilde "~" is the escape character in case you want to look
for ".", "*", or "~" within a string.

Given that, if I click on the search button for Part Maintence, click on the
Quick Search tab and select my wildcard quick search I've created and enter
"Q" in the search box, I'll only get part numbers that EQUAL the letter "Q".
If I enter "Q*", I will get a list of parts that begin with Q. If I enter
"*Q", I'll get a list of parts that end with "Q". Finally, if I enter "*Q*",
I'll get a list of parts that have the letter "Q" anywhere in the part
number. The real trick one is *~~.* will find all items that have a
period/full-stop in the part.

Creating a Quick Search Entry does NOT change the behavior of the Basic
search. You can however make a Quick Search Entry the default search when
you click the search button.

Hope that helps,

Mark W.