Searching Header Comments

Yahoo Archive
1
Cool. Thanks.
Works beautifully.
Here is a breakdown if anyone else runs up against it:

Vantage 803.407C
I created a BAQ that uses just one table: POHeader and displays just the PONumber and the Comment.
Then I use that in the Quick Search [and dashboard] to return the PONum.
I use
Criteria: POHeader.CommentText
Caption: Comment *query* [to hint at the use of asterisks]
Condition: MATCHES
Criteria: Prompt

Plamen Cheshmedjiev
Art Display Co.
Systems Administrator


--- In vantage@yahoogroups.com, "Gary Wojtowicz" <ajrgary@...> wrote:
>
> I have built quick searches for anywhere that I want to search the comments and it works great and didn't take much time to do.
> when you prompt you just put your string in between *'s eg. *fin*
> refer to 90512 quick search quotes
>
> Gary Wojtowicz
> AJR Industries, Inc.
>
>
> [Non-text portions of this message have been removed]
>
2
I've been asked to create something that would allow our sales people to search the Sales Order Header Comments to be able to find a specific Sales Order. The problem I'm having is that in both Crystal Reports and BAQ/Dashboard, there is no option for a "contains". I'm not sure how to reliably or effectively search the Comments field for a certain word or two...

Anyone have some ideas?
3
I am looking for the same thing for PO header comments. I did a 'begins with' and supposedly he will begin adding comments starting with the word if interest (online supplier, etc). It is somewhat useful, though not as nice as a real search. We are so accustomed to Google-ing it is annoying not to be able to search a database.

Plamen Cheshmedjiev
Systems Administrator
Art Display Co.

--- In vantage@yahoogroups.com, "brad.ebright" <bebright@...> wrote:
>
> I've been asked to create something that would allow our sales people to search the Sales Order Header Comments to be able to find a specific Sales Order. The problem I'm having is that in both Crystal Reports and BAQ/Dashboard, there is no option for a "contains". I'm not sure how to reliably or effectively search the Comments field for a certain word or two...
>
> Anyone have some ideas?
>
4
MATCHES *xyz*

--- In vantage@yahoogroups.com, "plamen21" <plamen21@...> wrote:
>
> I am looking for the same thing for PO header comments. I did a 'begins with' and supposedly he will begin adding comments starting with the word if interest (online supplier, etc). It is somewhat useful, though not as nice as a real search. We are so accustomed to Google-ing it is annoying not to be able to search a database.
>
> Plamen Cheshmedjiev
> Systems Administrator
> Art Display Co.
>
> --- In vantage@yahoogroups.com, "brad.ebright" <bebright@> wrote:
> >
> > I've been asked to create something that would allow our sales people to search the Sales Order Header Comments to be able to find a specific Sales Order. The problem I'm having is that in both Crystal Reports and BAQ/Dashboard, there is no option for a "contains". I'm not sure how to reliably or effectively search the Comments field for a certain word or two...
> >
> > Anyone have some ideas?
> >
>
5
Is that for use in the crystal report or dashboard?

Sent from my iPhone.

On Jun 9, 2010, at 12:44 PM, "bw2868bond" <bwalker@...>
wrote:

> MATCHES *xyz*
>
> --- In vantage@yahoogroups.com, "plamen21" <plamen21@...> wrote:
> >
> > I am looking for the same thing for PO header comments. I did a
> 'begins with' and supposedly he will begin adding comments starting
> with the word if interest (online supplier, etc). It is somewhat
> useful, though not as nice as a real search. We are so accustomed to
> Google-ing it is annoying not to be able to search a database.
> >
> > Plamen Cheshmedjiev
> > Systems Administrator
> > Art Display Co.
> >
> > --- In vantage@yahoogroups.com, "brad.ebright" <bebright@> wrote:
> > >
> > > I've been asked to create something that would allow our sales
> people to search the Sales Order Header Comments to be able to find
> a specific Sales Order. The problem I'm having is that in both
> Crystal Reports and BAQ/Dashboard, there is no option for a
> "contains". I'm not sure how to reliably or effectively search the
> Comments field for a certain word or two...
> > >
> > > Anyone have some ideas?
> > >
> >
>
>


[Non-text portions of this message have been removed]
6
Dashboard (and BAQ)

--- In vantage@yahoogroups.com, Brad Ebright <bebright@...> wrote:
>
> Is that for use in the crystal report or dashboard?
>
> Sent from my iPhone.
>
> On Jun 9, 2010, at 12:44 PM, "bw2868bond" <bwalker@...>
> wrote:
>
> > MATCHES *xyz*
> >
> > --- In vantage@yahoogroups.com, "plamen21" <plamen21@> wrote:
> > >
> > > I am looking for the same thing for PO header comments. I did a
> > 'begins with' and supposedly he will begin adding comments starting
> > with the word if interest (online supplier, etc). It is somewhat
> > useful, though not as nice as a real search. We are so accustomed to
> > Google-ing it is annoying not to be able to search a database.
> > >
> > > Plamen Cheshmedjiev
> > > Systems Administrator
> > > Art Display Co.
> > >
> > > --- In vantage@yahoogroups.com, "brad.ebright" <bebright@> wrote:
> > > >
> > > > I've been asked to create something that would allow our sales
> > people to search the Sales Order Header Comments to be able to find
> > a specific Sales Order. The problem I'm having is that in both
> > Crystal Reports and BAQ/Dashboard, there is no option for a
> > "contains". I'm not sure how to reliably or effectively search the
> > Comments field for a certain word or two...
> > > >
> > > > Anyone have some ideas?
> > > >
> > >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
7
Sorry that I am not getting this, but where does it allow you to type that
in within the BAQ/Dashbord? I'm using Vantage 8.0.



Thank You,



Brad Ebright
MGS Inc.
178 Muddy Creek Church Rd.
Denver, PA 17517
(717)336-7528

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bw2868bond
Sent: Wednesday, June 09, 2010 1:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Searching Header Comments





Dashboard (and BAQ)

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Brad
Ebright <bebright@...> wrote:
>
> Is that for use in the crystal report or dashboard?
>
> Sent from my iPhone.
>
> On Jun 9, 2010, at 12:44 PM, "bw2868bond" <bwalker@...>
> wrote:
>
> > MATCHES *xyz*
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"plamen21" <plamen21@> wrote:
> > >
> > > I am looking for the same thing for PO header comments. I did a
> > 'begins with' and supposedly he will begin adding comments starting
> > with the word if interest (online supplier, etc). It is somewhat
> > useful, though not as nice as a real search. We are so accustomed to
> > Google-ing it is annoying not to be able to search a database.
> > >
> > > Plamen Cheshmedjiev
> > > Systems Administrator
> > > Art Display Co.
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"brad.ebright" <bebright@> wrote:
> > > >
> > > > I've been asked to create something that would allow our sales
> > people to search the Sales Order Header Comments to be able to find
> > a specific Sales Order. The problem I'm having is that in both
> > Crystal Reports and BAQ/Dashboard, there is no option for a
> > "contains". I'm not sure how to reliably or effectively search the
> > Comments field for a certain word or two...
> > > >
> > > > Anyone have some ideas?
> > > >
> > >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
8
When you are in Dashboard Developer mode, right click in the area next to your search word text box and select 'Customize Tracker View'

Once the customization Tools Dialog form has opened, click on your textbox and in the customization tools dialog form properties tab, set the Dashboard Condition property for the textbox to Matches

Save.

--- In vantage@yahoogroups.com, "Brad Ebright" <bebright@...> wrote:
>
> Sorry that I am not getting this, but where does it allow you to type that
> in within the BAQ/Dashbord? I'm using Vantage 8.0.
>
>
>
> Thank You,
>
>
>
> Brad Ebright
> MGS Inc.
> 178 Muddy Creek Church Rd.
> Denver, PA 17517
> (717)336-7528
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> bw2868bond
> Sent: Wednesday, June 09, 2010 1:17 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Searching Header Comments
>
>
>
>
>
> Dashboard (and BAQ)
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Brad
> Ebright <bebright@> wrote:
> >
> > Is that for use in the crystal report or dashboard?
> >
> > Sent from my iPhone.
> >
> > On Jun 9, 2010, at 12:44 PM, "bw2868bond" <bwalker@>
> > wrote:
> >
> > > MATCHES *xyz*
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "plamen21" <plamen21@> wrote:
> > > >
> > > > I am looking for the same thing for PO header comments. I did a
> > > 'begins with' and supposedly he will begin adding comments starting
> > > with the word if interest (online supplier, etc). It is somewhat
> > > useful, though not as nice as a real search. We are so accustomed to
> > > Google-ing it is annoying not to be able to search a database.
> > > >
> > > > Plamen Cheshmedjiev
> > > > Systems Administrator
> > > > Art Display Co.
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "brad.ebright" <bebright@> wrote:
> > > > >
> > > > > I've been asked to create something that would allow our sales
> > > people to search the Sales Order Header Comments to be able to find
> > > a specific Sales Order. The problem I'm having is that in both
> > > Crystal Reports and BAQ/Dashboard, there is no option for a
> > > "contains". I'm not sure how to reliably or effectively search the
> > > Comments field for a certain word or two...
> > > > >
> > > > > Anyone have some ideas?
> > > > >
> > > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
9
Thanks! I had tried that earlier but it was not working. I then relized that
I made a stupid mistake was searching the comment field not the
OrderComments. That's why it was not working and I was confused. Thanks for
your help though.



Thank You,



Brad Ebright
MGS Inc.
178 Muddy Creek Church Rd.
Denver, PA 17517
(717)336-7528

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bw2868bond
Sent: Wednesday, June 09, 2010 1:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Searching Header Comments





When you are in Dashboard Developer mode, right click in the area next to
your search word text box and select 'Customize Tracker View'

Once the customization Tools Dialog form has opened, click on your textbox
and in the customization tools dialog form properties tab, set the Dashboard
Condition property for the textbox to Matches

Save.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Brad
Ebright" <bebright@...> wrote:
>
> Sorry that I am not getting this, but where does it allow you to type that
> in within the BAQ/Dashbord? I'm using Vantage 8.0.
>
>
>
> Thank You,
>
>
>
> Brad Ebright
> MGS Inc.
> 178 Muddy Creek Church Rd.
> Denver, PA 17517
> (717)336-7528
>
> _____
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> bw2868bond
> Sent: Wednesday, June 09, 2010 1:17 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Searching Header Comments
>
>
>
>
>
> Dashboard (and BAQ)
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , Brad
> Ebright <bebright@> wrote:
> >
> > Is that for use in the crystal report or dashboard?
> >
> > Sent from my iPhone.
> >
> > On Jun 9, 2010, at 12:44 PM, "bw2868bond" <bwalker@>
> > wrote:
> >
> > > MATCHES *xyz*
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "plamen21" <plamen21@> wrote:
> > > >
> > > > I am looking for the same thing for PO header comments. I did a
> > > 'begins with' and supposedly he will begin adding comments starting
> > > with the word if interest (online supplier, etc). It is somewhat
> > > useful, though not as nice as a real search. We are so accustomed to
> > > Google-ing it is annoying not to be able to search a database.
> > > >
> > > > Plamen Cheshmedjiev
> > > > Systems Administrator
> > > > Art Display Co.
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "brad.ebright" <bebright@> wrote:
> > > > >
> > > > > I've been asked to create something that would allow our sales
> > > people to search the Sales Order Header Comments to be able to find
> > > a specific Sales Order. The problem I'm having is that in both
> > > Crystal Reports and BAQ/Dashboard, there is no option for a
> > > "contains". I'm not sure how to reliably or effectively search the
> > > Comments field for a certain word or two...
> > > > >
> > > > > Anyone have some ideas?
> > > > >
> > > >
> > >
> > >
> >
> >
> > [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]
10
I am trying to create a BAQ/quick search that allows searching the header comments of POs for an arbitrary sting.
1. I create a baq. I get this in Phrase builder:
for each POHeader where ( POHeader.CommentText MATCHES '*xyz*') no-lock .
But this searches for the actual string "xyz", and not for an arbitrary string that the user can type in the quick search.
What is the proper way to do this.

Please help.

Thanks,

Plamen Cheshmedjiev
Systems Administrator
Art Display Co.

--- In vantage@yahoogroups.com, "Brad Ebright" <bebright@...> wrote:
>
> Thanks! I had tried that earlier but it was not working. I then relized that
> I made a stupid mistake was searching the comment field not the
> OrderComments. That's why it was not working and I was confused. Thanks for
> your help though.
>
>
>
> Thank You,
>
>
>
> Brad Ebright
> MGS Inc.
> 178 Muddy Creek Church Rd.
> Denver, PA 17517
> (717)336-7528
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> bw2868bond
> Sent: Wednesday, June 09, 2010 1:42 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Searching Header Comments
>
>
>
>
>
> When you are in Dashboard Developer mode, right click in the area next to
> your search word text box and select 'Customize Tracker View'
>
> Once the customization Tools Dialog form has opened, click on your textbox
> and in the customization tools dialog form properties tab, set the Dashboard
> Condition property for the textbox to Matches
>
> Save.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Brad
> Ebright" <bebright@> wrote:
> >
> > Sorry that I am not getting this, but where does it allow you to type that
> > in within the BAQ/Dashbord? I'm using Vantage 8.0.
> >
> >
> >
> > Thank You,
> >
> >
> >
> > Brad Ebright
> > MGS Inc.
> > 178 Muddy Creek Church Rd.
> > Denver, PA 17517
> > (717)336-7528
> >
> > _____
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> > bw2868bond
> > Sent: Wednesday, June 09, 2010 1:17 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Searching Header Comments
> >
> >
> >
> >
> >
> > Dashboard (and BAQ)
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> , Brad
> > Ebright <bebright@> wrote:
> > >
> > > Is that for use in the crystal report or dashboard?
> > >
> > > Sent from my iPhone.
> > >
> > > On Jun 9, 2010, at 12:44 PM, "bw2868bond" <bwalker@>
> > > wrote:
> > >
> > > > MATCHES *xyz*
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "plamen21" <plamen21@> wrote:
> > > > >
> > > > > I am looking for the same thing for PO header comments. I did a
> > > > 'begins with' and supposedly he will begin adding comments starting
> > > > with the word if interest (online supplier, etc). It is somewhat
> > > > useful, though not as nice as a real search. We are so accustomed to
> > > > Google-ing it is annoying not to be able to search a database.
> > > > >
> > > > > Plamen Cheshmedjiev
> > > > > Systems Administrator
> > > > > Art Display Co.
> > > > >
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "brad.ebright" <bebright@> wrote:
> > > > > >
> > > > > > I've been asked to create something that would allow our sales
> > > > people to search the Sales Order Header Comments to be able to find
> > > > a specific Sales Order. The problem I'm having is that in both
> > > > Crystal Reports and BAQ/Dashboard, there is no option for a
> > > > "contains". I'm not sure how to reliably or effectively search the
> > > > Comments field for a certain word or two...
> > > > > >
> > > > > > Anyone have some ideas?
> > > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> > > [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
Write your BAQ to return all comments. Then use it to create a dashboard where the user can input a string frag

--- Original Message ---
From:"plamen21" <plamen21@...>
Sent:Tue 6/15/10 11:49 am
To:vantage@yahoogroups.com
Subj:[Vantage] Re: Searching Header Comments

I am trying to create a BAQ/quick search that allows searching the header comments of POs for an arbitrary sting.
1. I create a baq. I get this in Phrase builder:
for each POHeader where ( POHeader.CommentText MATCHES '*xyz*') no-lock .
But this searches for the actual string "xyz", and not for an arbitrary string that the user can type in the quick search.
What is the proper way to do this.

Please help.

Thanks,

Plamen Cheshmedjiev
Systems Administrator
Art Display Co.

--- In vantage@yahoogroups.com, "Brad Ebright" <bebright@...> wrote:
>
> Thanks! I had tried that earlier but it was not working. I then relized that
> I made a stupid mistake was searching the comment field not the
> OrderComments. That's why it was not working and I was confused. Thanks for
> your help though.
>
>
>
> Thank You,
>
>
>
> Brad Ebright
> MGS Inc.
> 178 Muddy Creek Church Rd.
> Denver, PA 17517
> (717)336-7528
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> bw2868bond
> Sent: Wednesday, June 09, 2010 1:42 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Searching Header Comments
>
>
>
>
>
> When you are in Dashboard Developer mode, right click in the area next to
> your search word text box and select 'Customize Tracker View'
>
> Once the customization Tools Dialog form has opened, click on your textbox
> and in the customization tools dialog form properties tab, set the Dashboard
> Condition property for the textbox to Matches
>
> Save.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Brad
> Ebright" <bebright@> wrote:
> >
> > Sorry that I am not getting this, but where does it allow you to type that
> > in within the BAQ/Dashbord? I'm using Vantage 8.0.
> >
> >
> >
> > Thank You,
> >
> >
> >
> > Brad Ebright
> > MGS Inc.
> > 178 Muddy Creek Church Rd.
> > Denver, PA 17517
> > (717)336-7528
> >
> > _____
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> > bw2868bond
> > Sent: Wednesday, June 09, 2010 1:17 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Searching Header Comments
> >
> >
> >
> >
> >
> > Dashboard (and BAQ)
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> , Brad
> > Ebright <bebright@> wrote:
> > >
> > > Is that for use in the crystal report or dashboard?
> > >
> > > Sent from my iPhone.
> > >
> > > On Jun 9, 2010, at 12:44 PM, "bw2868bond" <bwalker@>
> > > wrote:
> > >
> > > > MATCHES *xyz*
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "plamen21" <plamen21@> wrote:
> > > > >
> > > > > I am looking for the same thing for PO header comments. I did a
> > > > 'begins with' and supposedly he will begin
12
It didn't work with "matches". Returns nothing. Equals or greater than works.

Plamen

--- In vantage@yahoogroups.com, robertb_versa@... wrote:
>
> Write your BAQ to return all comments. Then use it to create a dashboard where the user can input a string frag
>
> --- Original Message ---
> From:"plamen21" <plamen21@...>
> Sent:Tue 6/15/10 11:49 am
> To:vantage@yahoogroups.com
> Subj:[Vantage] Re: Searching Header Comments
>
> I am trying to create a BAQ/quick search that allows searching the header comments of POs for an arbitrary sting.
> 1. I create a baq. I get this in Phrase builder:
> for each POHeader where ( POHeader.CommentText MATCHES '*xyz*') no-lock .
> But this searches for the actual string "xyz", and not for an arbitrary string that the user can type in the quick search.
> What is the proper way to do this.
>
> Please help.
>
> Thanks,
>
> Plamen Cheshmedjiev
> Systems Administrator
> Art Display Co.
>
> --- In vantage@yahoogroups.com, "Brad Ebright" <bebright@> wrote:
> >
> > Thanks! I had tried that earlier but it was not working. I then relized that
> > I made a stupid mistake was searching the comment field not the
> > OrderComments. That's why it was not working and I was confused. Thanks for
> > your help though.
> >
> >
> >
> > Thank You,
> >
> >
> >
> > Brad Ebright
> > MGS Inc.
> > 178 Muddy Creek Church Rd.
> > Denver, PA 17517
> > (717)336-7528
> >
> > _____
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> > bw2868bond
> > Sent: Wednesday, June 09, 2010 1:42 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Searching Header Comments
> >
> >
> >
> >
> >
> > When you are in Dashboard Developer mode, right click in the area next to
> > your search word text box and select 'Customize Tracker View'
> >
> > Once the customization Tools Dialog form has opened, click on your textbox
> > and in the customization tools dialog form properties tab, set the Dashboard
> > Condition property for the textbox to Matches
> >
> > Save.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Brad
> > Ebright" <bebright@> wrote:
> > >
> > > Sorry that I am not getting this, but where does it allow you to type that
> > > in within the BAQ/Dashbord? I'm using Vantage 8.0.
> > >
> > >
> > >
> > > Thank You,
> > >
> > >
> > >
> > > Brad Ebright
> > > MGS Inc.
> > > 178 Muddy Creek Church Rd.
> > > Denver, PA 17517
> > > (717)336-7528
> > >
> > > _____
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of
> > > bw2868bond
> > > Sent: Wednesday, June 09, 2010 1:17 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Searching Header Comments
> > >
> > >
> > >
> > >
> > >
> > > Dashboard (and BAQ)
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> , Brad
> > > Ebright <bebright@> wrote:
> > > >
> > > > Is that for use in the crystal report or dashboard?
> > > >
> > > > Sent from my iPhone.
> > > >
> > > > On Jun 9, 2010, at 12:44 PM, "bw2868bond" <bwalker@>
> > > > wrote:
> > > >
> > > > > MATCHES *xyz*
> > > > >
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "plamen21" <plamen21@> wrote:
> > > > > >
> > > > > > I am looking for the same thing for PO header comments. I did a
> > > > > 'begins with' and supposedly he will begin
>
13
Don't put any criteria in your BAQ. Your quick search should contain a critiea using the comment field with a condition of MATCHES and a criteria type of PROMPT. When creating a Matches criteria I will usually put an * before and after the caption so the user knows to do the same when they enter the search criteria

I find the Match criteria to work quite well, in fact our users are grateful for that type of search. I even use it for Customer and Supplier names because sometimes we can't quite remember how the name is entered in the system. The key for this type of search is the user must be sure to enter an * before and after the string they are searching for.

Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
----- Original Message -----
From: plamen21
To: vantage@yahoogroups.com
Sent: Tuesday, June 15, 2010 4:02 PM
Subject: [Vantage] Re: Searching Header Comments



It didn't work with "matches". Returns nothing. Equals or greater than works.

Plamen

--- In vantage@yahoogroups.com, robertb_versa@... wrote:
>
> Write your BAQ to return all comments. Then use it to create a dashboard where the user can input a string frag
>
> --- Original Message ---
> From:"plamen21" <plamen21@...>
> Sent:Tue 6/15/10 11:49 am
> To:vantage@yahoogroups.com
> Subj:[Vantage] Re: Searching Header Comments
>
> I am trying to create a BAQ/quick search that allows searching the header comments of POs for an arbitrary sting.
> 1. I create a baq. I get this in Phrase builder:
> for each POHeader where ( POHeader.CommentText MATCHES '*xyz*') no-lock .
> But this searches for the actual string "xyz", and not for an arbitrary string that the user can type in the quick search.
> What is the proper way to do this.
>
> Please help.
>
> Thanks,
>
> Plamen Cheshmedjiev
> Systems Administrator
> Art Display Co.
>
> --- In vantage@yahoogroups.com, "Brad Ebright" <bebright@> wrote:
> >
> > Thanks! I had tried that earlier but it was not working. I then relized that
> > I made a stupid mistake was searching the comment field not the
> > OrderComments. That's why it was not working and I was confused. Thanks for
> > your help though.
> >
> >
> >
> > Thank You,
> >
> >
> >
> > Brad Ebright
> > MGS Inc.
> > 178 Muddy Creek Church Rd.
> > Denver, PA 17517
> > (717)336-7528
> >
> > _____
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> > bw2868bond
> > Sent: Wednesday, June 09, 2010 1:42 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Searching Header Comments
> >
> >
> >
> >
> >
> > When you are in Dashboard Developer mode, right click in the area next to
> > your search word text box and select 'Customize Tracker View'
> >
> > Once the customization Tools Dialog form has opened, click on your textbox
> > and in the customization tools dialog form properties tab, set the Dashboard
> > Condition property for the textbox to Matches
> >
> > Save.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Brad
> > Ebright" <bebright@> wrote:
> > >
> > > Sorry that I am not getting this, but where does it allow you to type that
> > > in within the BAQ/Dashbord? I'm using Vantage 8.0.
> > >
> > >
> > >
> > > Thank You,
> > >
> > >
> > >
> > > Brad Ebright
> > > MGS Inc.
> > > 178 Muddy Creek Church Rd.
> > > Denver, PA 17517
> > > (717)336-7528
> > >
> > > _____
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of
> > > bw2868bond
> > > Sent: Wednesday, June 09, 2010 1:17 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Searching Header Comments
> > >
> > >
> > >
> > >
> > >
> > > Dashboard (and BAQ)
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> , Brad
> > > Ebright <bebright@> wrote:
> > > >
> > > > Is that for use in the crystal report or dashboard?
> > > >
> > > > Sent from my iPhone.
> > > >
> > > > On Jun 9, 2010, at 12:44 PM, "bw2868bond" <bwalker@>
> > > > wrote:
> > > >
> > > > > MATCHES *xyz*
> > > > >
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "plamen21" <plamen21@> wrote:
> > > > > >
> > > > > > I am looking for the same thing for PO header comments. I did a
> > > > > 'begins with' and supposedly he will begin
>





[Non-text portions of this message have been removed]
14
I have built quick searches for anywhere that I want to search the comments and it works great and didn't take much time to do.
when you prompt you just put your string in between *'s eg. *fin*
refer to 90512 quick search quotes

Gary Wojtowicz
AJR Industries, Inc.


[Non-text portions of this message have been removed]
15
They way I got it to work was the way Robert said. Make the BAQ to return
all comments then create the dashboard with a tracker view. Edit the tracker
and set the criteria to Matches. Then to test it go to your inputs and type
in *(type anything here)*



That's what I did and it works well.



Thank You,



Brad Ebright
MGS Inc.
178 Muddy Creek Church Rd.
Denver, PA 17517
(717)336-7528

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
plamen21
Sent: Tuesday, June 15, 2010 5:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Searching Header Comments





It didn't work with "matches". Returns nothing. Equals or greater than
works.

Plamen

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
robertb_versa@... wrote:
>
> Write your BAQ to return all comments. Then use it to create a dashboard
where the user can input a string frag
>
> --- Original Message ---
> From:"plamen21" <plamen21@...>
> Sent:Tue 6/15/10 11:49 am
> To:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subj:[Vantage] Re: Searching Header Comments
>
> I am trying to create a BAQ/quick search that allows searching the header
comments of POs for an arbitrary sting.
> 1. I create a baq. I get this in Phrase builder:
> for each POHeader where ( POHeader.CommentText MATCHES '*xyz*') no-lock .
> But this searches for the actual string "xyz", and not for an arbitrary
string that the user can type in the quick search.
> What is the proper way to do this.
>
> Please help.
>
> Thanks,
>
> Plamen Cheshmedjiev
> Systems Administrator
> Art Display Co.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Brad
Ebright" <bebright@> wrote:
> >
> > Thanks! I had tried that earlier but it was not working. I then relized
that
> > I made a stupid mistake was searching the comment field not the
> > OrderComments. That's why it was not working and I was confused. Thanks
for
> > your help though.
> >
> >
> >
> > Thank You,
> >
> >
> >
> > Brad Ebright
> > MGS Inc.
> > 178 Muddy Creek Church Rd.
> > Denver, PA 17517
> > (717)336-7528
> >
> > _____
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> > bw2868bond
> > Sent: Wednesday, June 09, 2010 1:42 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Searching Header Comments
> >
> >
> >
> >
> >
> > When you are in Dashboard Developer mode, right click in the area next
to
> > your search word text box and select 'Customize Tracker View'
> >
> > Once the customization Tools Dialog form has opened, click on your
textbox
> > and in the customization tools dialog form properties tab, set the
Dashboard
> > Condition property for the textbox to Matches
> >
> > Save.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , "Brad
> > Ebright" <bebright@> wrote:
> > >
> > > Sorry that I am not getting this, but where does it allow you to type
that
> > > in within the BAQ/Dashbord? I'm using Vantage 8.0.
> > >
> > >
> > >
> > > Thank You,
> > >
> > >
> > >
> > > Brad Ebright
> > > MGS Inc.
> > > 178 Muddy Creek Church Rd.
> > > Denver, PA 17517
> > > (717)336-7528
> > >
> > > _____
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of
> > > bw2868bond
> > > Sent: Wednesday, June 09, 2010 1:17 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Searching Header Comments
> > >
> > >
> > >
> > >
> > >
> > > Dashboard (and BAQ)
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> , Brad
> > > Ebright <bebright@> wrote:
> > > >
> > > > Is that for use in the crystal report or dashboard?
> > > >
> > > > Sent from my iPhone.
> > > >
> > > > On Jun 9, 2010, at 12:44 PM, "bw2868bond" <bwalker@>
> > > > wrote:
> > > >
> > > > > MATCHES *xyz*
> > > > >
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "plamen21" <plamen21@> wrote:
> > > > > >
> > > > > > I am looking for the same thing for PO header comments. I did a
> > > > > 'begins with' and supposedly he will begin
>





[Non-text portions of this message have been removed]
16
It works with the asterisks! Thank you.
For some reason I can't enter a caption. I enter it but it doesn't get saved. Not sure if this is a bug. It has worked for me on other dashboards in the past.

Plamen Cheshmedjiev
Systems Administrator
Art Display Co.

--- In vantage@yahoogroups.com, "Charles Carden" <shadowcar1449@...> wrote:
>
> Don't put any criteria in your BAQ. Your quick search should contain a critiea using the comment field with a condition of MATCHES and a criteria type of PROMPT. When creating a Matches criteria I will usually put an * before and after the caption so the user knows to do the same when they enter the search criteria
>
> I find the Match criteria to work quite well, in fact our users are grateful for that type of search. I even use it for Customer and Supplier names because sometimes we can't quite remember how the name is entered in the system. The key for this type of search is the user must be sure to enter an * before and after the string they are searching for.
>
> Charles Carden
> IT Manager
> Manitex, Inc.
> Georgetown, Texas
> ----- Original Message -----
> From: plamen21
> To: vantage@yahoogroups.com
> Sent: Tuesday, June 15, 2010 4:02 PM
> Subject: [Vantage] Re: Searching Header Comments
>
>
>
> It didn't work with "matches". Returns nothing. Equals or greater than works.
>
> Plamen
>
> --- In vantage@yahoogroups.com, robertb_versa@ wrote:
> >
> > Write your BAQ to return all comments. Then use it to create a dashboard where the user can input a string frag
> >
> > --- Original Message ---
> > From:"plamen21" <plamen21@>
> > Sent:Tue 6/15/10 11:49 am
> > To:vantage@yahoogroups.com
> > Subj:[Vantage] Re: Searching Header Comments
> >
> > I am trying to create a BAQ/quick search that allows searching the header comments of POs for an arbitrary sting.
> > 1. I create a baq. I get this in Phrase builder:
> > for each POHeader where ( POHeader.CommentText MATCHES '*xyz*') no-lock .
> > But this searches for the actual string "xyz", and not for an arbitrary string that the user can type in the quick search.
> > What is the proper way to do this.
> >
> > Please help.
> >
> > Thanks,
> >
> > Plamen Cheshmedjiev
> > Systems Administrator
> > Art Display Co.
> >
> > --- In vantage@yahoogroups.com, "Brad Ebright" <bebright@> wrote:
> > >
> > > Thanks! I had tried that earlier but it was not working. I then relized that
> > > I made a stupid mistake was searching the comment field not the
> > > OrderComments. That's why it was not working and I was confused. Thanks for
> > > your help though.
> > >
> > >
> > >
> > > Thank You,
> > >
> > >
> > >
> > > Brad Ebright
> > > MGS Inc.
> > > 178 Muddy Creek Church Rd.
> > > Denver, PA 17517
> > > (717)336-7528
> > >
> > > _____
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> > > bw2868bond
> > > Sent: Wednesday, June 09, 2010 1:42 PM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Re: Searching Header Comments
> > >
> > >
> > >
> > >
> > >
> > > When you are in Dashboard Developer mode, right click in the area next to
> > > your search word text box and select 'Customize Tracker View'
> > >
> > > Once the customization Tools Dialog form has opened, click on your textbox
> > > and in the customization tools dialog form properties tab, set the Dashboard
> > > Condition property for the textbox to Matches
> > >
> > > Save.
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Brad
> > > Ebright" <bebright@> wrote:
> > > >
> > > > Sorry that I am not getting this, but where does it allow you to type that
> > > > in within the BAQ/Dashbord? I'm using Vantage 8.0.
> > > >
> > > >
> > > >
> > > > Thank You,
> > > >
> > > >
> > > >
> > > > Brad Ebright
> > > > MGS Inc.
> > > > 178 Muddy Creek Church Rd.
> > > > Denver, PA 17517
> > > > (717)336-7528
> > > >
> > > > _____
> > > >
> > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > > Behalf Of
> > > > bw2868bond
> > > > Sent: Wednesday, June 09, 2010 1:17 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Re: Searching Header Comments
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Dashboard (and BAQ)
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> , Brad
> > > > Ebright <bebright@> wrote:
> > > > >
> > > > > Is that for use in the crystal report or dashboard?
> > > > >
> > > > > Sent from my iPhone.
> > > > >
> > > > > On Jun 9, 2010, at 12:44 PM, "bw2868bond" <bwalker@>
> > > > > wrote:
> > > > >
> > > > > > MATCHES *xyz*
> > > > > >
> > > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "plamen21" <plamen21@> wrote:
> > > > > > >
> > > > > > > I am looking for the same thing for PO header comments. I did a
> > > > > > 'begins with' and supposedly he will begin
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>