BAQ's Blank Title 58985

Yahoo Archive
1
The query shouldn't stop working when you add other tables... If you put the
query here we may be able to tell you what's wrong.
*
*
*
*
*
*
*Jose C Gomez*



Software Engineer
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Sun, May 8, 2011 at 4:32 AM, Mark Kamsika <m.kamsika@...> wrote:

>
>
> I used matches like you suggested.
> Unfortunately the query stops working when adding other tables to the
> query.
> Luckily enough we use the field needed in abbreviated form in the part
> search So
> this will do for now
>
> Mark
>
> ________________________________
> From: Jose Gomez <jose@...>
> To: vantage@yahoogroups.com
> Sent: Fri, 6 May, 2011 15:36:46
>
> Subject: Re: [Vantage] BAQ's
>
> How'd you solve it?
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez
> >
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
> On Fri, May 6, 2011 at 10:02 AM, Mark Kamsika <m.kamsika@...>
> wrote:
>
> >
> >
> > Please Ignore,
> >
> > I have got this working
> >
> > ________________________________
> > From: Mark Kamsika <m.kamsika@...>
> > To: vantage@yahoogroups.com
> > Sent: Fri, 6 May, 2011 14:59:25
> >
> > Subject: Re: [Vantage] BAQ's
> >
> > Hi,
> >
> > I have used matches but it does not give me any matches. Any Ideas.
> > The SQL query brings up results
> >
> > Mark
> >
> > ________________________________
> > From: Jose Gomez <jose@...>
> > To: vantage@yahoogroups.com
> > Sent: Fri, 6 May, 2011 14:00:17
> > Subject: Re: [Vantage] BAQ's
> >
> > sure use matches
> >
> > select partnum, ud101.character01 from part, ud101 where part.character09
> > like
> > ud101.key1
> > The data types are incompatible so like is used instead of equals
> >
> > for each Part, ud101 where Part.Character09 MATCHES(UD101.Key1)
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez
> > >
> > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> >
> > *Quis custodiet ipsos custodes?*
> >
> > On Fri, May 6, 2011 at 8:27 AM, Mark Kamsika <m.kamsika@...>
> > wrote:
> >
> > >
> > >
> > > Hi all,
> > >
> > > I am trying to write a BAQ which queries a ud table. In sql server the
> > > query
> > > would be:
> > >
> > > select partnum, ud101.character01 from part, ud101 where
> part.character09
> > > like
> > > ud101.key1
> > > The data types are incompatible so like is used instead of equals
> > >
> > > Is it possible to run a BAQ with a like statement.
> > >
> > > Kind Regards
> > > Mark
> > >
> > > [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
> >
> > [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]
>
> ------------------------------------
>
> 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]
>
>
>


[Non-text portions of this message have been removed]
2
If I were looking for a person to write BAQ's, what type of skill set would I be looking for? What language does it require?

Thanks,

Jasper Recto
Director of Information Technology
Loc Performance Products, Inc.
734.927.3835

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />



ITAR Disclaimer

Technical data obtained from Loc through any electronic solicitation are subject to U.S. Export Control Laws including the International Traffic in Arms Regulations. Such technical data may not be disclosed to foreign persons or otherwise exported without first obtaining required U. S. Government export authorization.




[Non-text portions of this message have been removed]
3
Greek... at least it's Greek to me if anyone has any e-learnings,
training manuals, reference guides, etc. it would be much appreciated



Trying to convert from 5.0 to 8.03



Dan Shallbetter

States Electric Mfg.







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Thursday, September 06, 2007 1:24 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] BAQ's



If I were looking for a person to write BAQ's, what type of skill set
would I be looking for? What language does it require?

Thanks,

Jasper Recto
Director of Information Technology
Loc Performance Products, Inc.
734.927.3835

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this in error, please contact the sender and delete the
material from any computer.<?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" />

ITAR Disclaimer

Technical data obtained from Loc through any electronic solicitation are
subject to U.S. Export Control Laws including the International Traffic
in Arms Regulations. Such technical data may not be disclosed to foreign
persons or otherwise exported without first obtaining required U. S.
Government export authorization.

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





[Non-text portions of this message have been removed]
4
Basically anyone who has a decent understanding of relational databases
and have written queries.



The languages behind 8.0 and beyond are progress and visual basic dot
net.



And, Dan, if you haven't gone too far with converting, see if you can
just re-implement...there have been significant changes from version 5
to version 8!







M. Manasa Reddy

manasa@...

P: 630-806-2000

F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dan Shallbetter
Sent: Thursday, September 06, 2007 1:41 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ's



Greek... at least it's Greek to me if anyone has any e-learnings,
training manuals, reference guides, etc. it would be much appreciated

Trying to convert from 5.0 to 8.03

Dan Shallbetter

States Electric Mfg.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Jasper Recto
Sent: Thursday, September 06, 2007 1:24 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] BAQ's

If I were looking for a person to write BAQ's, what type of skill set
would I be looking for? What language does it require?

Thanks,

Jasper Recto
Director of Information Technology
Loc Performance Products, Inc.
734.927.3835

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this in error, please contact the sender and delete the
material from any computer.<?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" />

ITAR Disclaimer

Technical data obtained from Loc through any electronic solicitation are
subject to U.S. Export Control Laws including the International Traffic
in Arms Regulations. Such technical data may not be disclosed to foreign
persons or otherwise exported without first obtaining required U. S.
Government export authorization.

[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]
5
We have just finished an 8.0.3 implementation and are currently
working on some complex BAQ's (for both dashboards and reports). A
couple of thoughts:
1) It is a Business Analyst role who can understand the needs of the
user as well as database/table relationships
2) Experience in writing reports (E.g. crystal)
3) A "critical thinker", there are multiple paths sometimes to a query
and you want someone who can do the pros/cons of each approach.

Good luck

--- In vantage@yahoogroups.com, Jasper Recto <jrecto@...> wrote:
>
> If I were looking for a person to write BAQ's, what type of skill
set would I be looking for? What language does it require?
>
> Thanks,
>
> Jasper Recto
> Director of Information Technology
> Loc Performance Products, Inc.
> 734.927.3835
>
> The information transmitted is intended only for the person or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this
information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the
sender and delete the material from any computer.<?xml:namespace
prefix = o ns = "urn:schemas-microsoft-com:office:office" />
>
>
>
> ITAR Disclaimer
>
> Technical data obtained from Loc through any electronic solicitation
are subject to U.S. Export Control Laws including the International
Traffic in Arms Regulations. Such technical data may not be disclosed
to foreign persons or otherwise exported without first obtaining
required U. S. Government export authorization.
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
Alec,

Do you have any samples of the BAQ's you are creating that you could
share? I keep trying to create BAQ's and am having difficulties with
the Calc and Criteria portions.

If you don't have any BAQ's you can share, could you answer a quick
question. Are you limited to only one Calculated field per BAQ?
Everytime I try to create a BAQ it overwrites the one I've already
created. At the rate I'm going, I can't see the advantage of BAQs
when you appear to be limited to only one calc field and the
inability to use a calc field in setting up criteria.

Any help would be so greatly appreciated.

Thanks,

Debbie Smith
debsmithmich@...
(906) 869-2247

--- In vantage@yahoogroups.com, "Alec Elmore" <aelmore@...> wrote:
>
> We have just finished an 8.0.3 implementation and are currently
> working on some complex BAQ's (for both dashboards and reports). A
> couple of thoughts:
> 1) It is a Business Analyst role who can understand the needs of the
> user as well as database/table relationships
> 2) Experience in writing reports (E.g. crystal)
> 3) A "critical thinker", there are multiple paths sometimes to a
query
> and you want someone who can do the pros/cons of each approach.
>
> Good luck
>
> --- In vantage@yahoogroups.com, Jasper Recto <jrecto@> wrote:
> >
> > If I were looking for a person to write BAQ's, what type of skill
> set would I be looking for? What language does it require?
> >
> > Thanks,
> >
> > Jasper Recto
> > Director of Information Technology
> > Loc Performance Products, Inc.
> > 734.927.3835
> >
> > The information transmitted is intended only for the person or
> entity to which it is addressed and may contain confidential and/or
> privileged material. Any review, retransmission, dissemination or
> other use of, or taking of any action in reliance upon, this
> information by persons or entities other than the intended recipient
> is prohibited. If you received this in error, please contact the
> sender and delete the material from any computer.<?xml:namespace
> prefix = o ns = "urn:schemas-microsoft-com:office:office" />
> >
> >
> >
> > ITAR Disclaimer
> >
> > Technical data obtained from Loc through any electronic
solicitation
> are subject to U.S. Export Control Laws including the International
> Traffic in Arms Regulations. Such technical data may not be
disclosed
> to foreign persons or otherwise exported without first obtaining
> required U. S. Government export authorization.
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
7
Hi Debbie

You can have multiple Calc fields. If you highlight the existing calc
field and select the calc button it opens the existing field. Try
highlighting a different field and selecting the calc button.

Mark



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of debsmithmich
Sent: Sunday, October 28, 2007 6:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ's



Alec,

Do you have any samples of the BAQ's you are creating that you could
share? I keep trying to create BAQ's and am having difficulties with
the Calc and Criteria portions.

If you don't have any BAQ's you can share, could you answer a quick
question. Are you limited to only one Calculated field per BAQ?
Everytime I try to create a BAQ it overwrites the one I've already
created. At the rate I'm going, I can't see the advantage of BAQs
when you appear to be limited to only one calc field and the
inability to use a calc field in setting up criteria.

Any help would be so greatly appreciated.

Thanks,

Debbie Smith
debsmithmich@... <mailto:debsmithmich%40yahoo.com>
(906) 869-2247

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Alec Elmore" <aelmore@...> wrote:
>
> We have just finished an 8.0.3 implementation and are currently
> working on some complex BAQ's (for both dashboards and reports). A
> couple of thoughts:
> 1) It is a Business Analyst role who can understand the needs of the
> user as well as database/table relationships
> 2) Experience in writing reports (E.g. crystal)
> 3) A "critical thinker", there are multiple paths sometimes to a
query
> and you want someone who can do the pros/cons of each approach.
>
> Good luck
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
Jasper Recto <jrecto@> wrote:
> >
> > If I were looking for a person to write BAQ's, what type of skill
> set would I be looking for? What language does it require?
> >
> > Thanks,
> >
> > Jasper Recto
> > Director of Information Technology
> > Loc Performance Products, Inc.
> > 734.927.3835
> >
> > The information transmitted is intended only for the person or
> entity to which it is addressed and may contain confidential and/or
> privileged material. Any review, retransmission, dissemination or
> other use of, or taking of any action in reliance upon, this
> information by persons or entities other than the intended recipient
> is prohibited. If you received this in error, please contact the
> sender and delete the material from any computer.<?xml:namespace
> prefix = o ns = "urn:schemas-microsoft-com:office:office" />
> >
> >
> >
> > ITAR Disclaimer
> >
> > Technical data obtained from Loc through any electronic
solicitation
> are subject to U.S. Export Control Laws including the International
> Traffic in Arms Regulations. Such technical data may not be
disclosed
> to foreign persons or otherwise exported without first obtaining
> required U. S. Government export authorization.
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>





[Non-text portions of this message have been removed]
8
Thanks, I don't know what I was doing wrong before, but it's good to
know that I can do more than one calc. I even got several calcs in.
Now I just have to get the progress code right.

Debbie

--- In vantage@yahoogroups.com, "Dupuis, Mark" <mdupuis@...> wrote:
>
> Hi Debbie
>
> You can have multiple Calc fields. If you highlight the existing
calc
> field and select the calc button it opens the existing field. Try
> highlighting a different field and selecting the calc button.
>
> Mark
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of debsmithmich
> Sent: Sunday, October 28, 2007 6:00 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ's
>
>
>
> Alec,
>
> Do you have any samples of the BAQ's you are creating that you
could
> share? I keep trying to create BAQ's and am having difficulties
with
> the Calc and Criteria portions.
>
> If you don't have any BAQ's you can share, could you answer a quick
> question. Are you limited to only one Calculated field per BAQ?
> Everytime I try to create a BAQ it overwrites the one I've already
> created. At the rate I'm going, I can't see the advantage of BAQs
> when you appear to be limited to only one calc field and the
> inability to use a calc field in setting up criteria.
>
> Any help would be so greatly appreciated.
>
> Thanks,
>
> Debbie Smith
> debsmithmich@... <mailto:debsmithmich%40yahoo.com>
> (906) 869-2247
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Alec Elmore" <aelmore@> wrote:
> >
> > We have just finished an 8.0.3 implementation and are currently
> > working on some complex BAQ's (for both dashboards and reports). A
> > couple of thoughts:
> > 1) It is a Business Analyst role who can understand the needs of
the
> > user as well as database/table relationships
> > 2) Experience in writing reports (E.g. crystal)
> > 3) A "critical thinker", there are multiple paths sometimes to a
> query
> > and you want someone who can do the pros/cons of each approach.
> >
> > Good luck
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ,
> Jasper Recto <jrecto@> wrote:
> > >
> > > If I were looking for a person to write BAQ's, what type of
skill
> > set would I be looking for? What language does it require?
> > >
> > > Thanks,
> > >
> > > Jasper Recto
> > > Director of Information Technology
> > > Loc Performance Products, Inc.
> > > 734.927.3835
> > >
> > > The information transmitted is intended only for the person or
> > entity to which it is addressed and may contain confidential
and/or
> > privileged material. Any review, retransmission, dissemination or
> > other use of, or taking of any action in reliance upon, this
> > information by persons or entities other than the intended
recipient
> > is prohibited. If you received this in error, please contact the
> > sender and delete the material from any computer.<?xml:namespace
> > prefix = o ns = "urn:schemas-microsoft-com:office:office" />
> > >
> > >
> > >
> > > ITAR Disclaimer
> > >
> > > Technical data obtained from Loc through any electronic
> solicitation
> > are subject to U.S. Export Control Laws including the
International
> > Traffic in Arms Regulations. Such technical data may not be
> disclosed
> > to foreign persons or otherwise exported without first obtaining
> > required U. S. Government export authorization.
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
9
Hi all,

I am trying to write a BAQ which queries a ud table. In sql server the query
would be:

select partnum, ud101.character01 from part, ud101 where part.character09 like
ud101.key1
The data types are incompatible so like is used instead of equals

Is it possible to run a BAQ with a like statement.

Kind Regards
Mark

[Non-text portions of this message have been removed]
10
sure use matches

select partnum, ud101.character01 from part, ud101 where part.character09
like
ud101.key1
The data types are incompatible so like is used instead of equals


for each Part, ud101 where Part.Character09 MATCHES(UD101.Key1)




*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Fri, May 6, 2011 at 8:27 AM, Mark Kamsika <m.kamsika@...> wrote:

>
>
> Hi all,
>
> I am trying to write a BAQ which queries a ud table. In sql server the
> query
> would be:
>
> select partnum, ud101.character01 from part, ud101 where part.character09
> like
> ud101.key1
> The data types are incompatible so like is used instead of equals
>
> Is it possible to run a BAQ with a like statement.
>
> Kind Regards
> Mark
>
> [Non-text portions of this message have been removed]
>
>
>


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

I have used matches but it does not give me any matches. Any Ideas.
The SQL query brings up results

Mark



________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Fri, 6 May, 2011 14:00:17
Subject: Re: [Vantage] BAQ's

sure use matches

select partnum, ud101.character01 from part, ud101 where part.character09
like
ud101.key1
The data types are incompatible so like is used instead of equals


for each Part, ud101 where Part.Character09 MATCHES(UD101.Key1)




*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Fri, May 6, 2011 at 8:27 AM, Mark Kamsika <m.kamsika@...> wrote:

>
>
> Hi all,
>
> I am trying to write a BAQ which queries a ud table. In sql server the
> query
> would be:
>
> select partnum, ud101.character01 from part, ud101 where part.character09
> like
> ud101.key1
> The data types are incompatible so like is used instead of equals
>
> Is it possible to run a BAQ with a like statement.
>
> Kind Regards
> Mark
>
> [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



[Non-text portions of this message have been removed]
12
Please Ignore,

I have got this working



________________________________
From: Mark Kamsika <m.kamsika@...>
To: vantage@yahoogroups.com
Sent: Fri, 6 May, 2011 14:59:25
Subject: Re: [Vantage] BAQ's


Hi,

I have used matches but it does not give me any matches. Any Ideas.
The SQL query brings up results

Mark

________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Fri, 6 May, 2011 14:00:17
Subject: Re: [Vantage] BAQ's

sure use matches

select partnum, ud101.character01 from part, ud101 where part.character09
like
ud101.key1
The data types are incompatible so like is used instead of equals

for each Part, ud101 where Part.Character09 MATCHES(UD101.Key1)

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*

On Fri, May 6, 2011 at 8:27 AM, Mark Kamsika <m.kamsika@...> wrote:

>
>
> Hi all,
>
> I am trying to write a BAQ which queries a ud table. In sql server the
> query
> would be:
>
> select partnum, ud101.character01 from part, ud101 where part.character09
> like
> ud101.key1
> The data types are incompatible so like is used instead of equals
>
> Is it possible to run a BAQ with a like statement.
>
> Kind Regards
> Mark
>
> [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

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




[Non-text portions of this message have been removed]
13
How'd you solve it?

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Fri, May 6, 2011 at 10:02 AM, Mark Kamsika <m.kamsika@...> wrote:

>
>
> Please Ignore,
>
> I have got this working
>
> ________________________________
> From: Mark Kamsika <m.kamsika@...>
> To: vantage@yahoogroups.com
> Sent: Fri, 6 May, 2011 14:59:25
>
> Subject: Re: [Vantage] BAQ's
>
> Hi,
>
> I have used matches but it does not give me any matches. Any Ideas.
> The SQL query brings up results
>
> Mark
>
> ________________________________
> From: Jose Gomez <jose@...>
> To: vantage@yahoogroups.com
> Sent: Fri, 6 May, 2011 14:00:17
> Subject: Re: [Vantage] BAQ's
>
> sure use matches
>
> select partnum, ud101.character01 from part, ud101 where part.character09
> like
> ud101.key1
> The data types are incompatible so like is used instead of equals
>
> for each Part, ud101 where Part.Character09 MATCHES(UD101.Key1)
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez
> >
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
> On Fri, May 6, 2011 at 8:27 AM, Mark Kamsika <m.kamsika@...>
> wrote:
>
> >
> >
> > Hi all,
> >
> > I am trying to write a BAQ which queries a ud table. In sql server the
> > query
> > would be:
> >
> > select partnum, ud101.character01 from part, ud101 where part.character09
> > like
> > ud101.key1
> > The data types are incompatible so like is used instead of equals
> >
> > Is it possible to run a BAQ with a like statement.
> >
> > Kind Regards
> > Mark
> >
> > [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
>
> [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]
14
I used matches like you suggested.
Unfortunately the query stops working when adding other tables to the query.
Luckily enough we use the field needed in abbreviated form in the part search So
this will do for now
Mark




________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Fri, 6 May, 2011 15:36:46
Subject: Re: [Vantage] BAQ's

How'd you solve it?

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Fri, May 6, 2011 at 10:02 AM, Mark Kamsika <m.kamsika@...> wrote:

>
>
> Please Ignore,
>
> I have got this working
>
> ________________________________
> From: Mark Kamsika <m.kamsika@...>
> To: vantage@yahoogroups.com
> Sent: Fri, 6 May, 2011 14:59:25
>
> Subject: Re: [Vantage] BAQ's
>
> Hi,
>
> I have used matches but it does not give me any matches. Any Ideas.
> The SQL query brings up results
>
> Mark
>
> ________________________________
> From: Jose Gomez <jose@...>
> To: vantage@yahoogroups.com
> Sent: Fri, 6 May, 2011 14:00:17
> Subject: Re: [Vantage] BAQ's
>
> sure use matches
>
> select partnum, ud101.character01 from part, ud101 where part.character09
> like
> ud101.key1
> The data types are incompatible so like is used instead of equals
>
> for each Part, ud101 where Part.Character09 MATCHES(UD101.Key1)
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez
> >
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
> On Fri, May 6, 2011 at 8:27 AM, Mark Kamsika <m.kamsika@...>
> wrote:
>
> >
> >
> > Hi all,
> >
> > I am trying to write a BAQ which queries a ud table. In sql server the
> > query
> > would be:
> >
> > select partnum, ud101.character01 from part, ud101 where part.character09
> > like
> > ud101.key1
> > The data types are incompatible so like is used instead of equals
> >
> > Is it possible to run a BAQ with a like statement.
> >
> > Kind Regards
> > Mark
> >
> > [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
>
> [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]



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

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]