BAQ: CAN-FIND is a calculated field?

Yahoo Archive
1
Thanks Jose and Patrick.



I guess I was over thinking it.

I'll give Patrick's approach a try.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Winter, Patrick
Sent: Friday, May 10, 2013 4:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ: CAN-FIND is a calculated field?





Join to JobOper

Filter for SUBCONTRACT = True

Use LEFT OUTER in case no Subcontract record, will
return blank fields.

Use FIRST instead of EACH in case of duplicates.

Patrick Winter

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Friday, May 10, 2013 15:23
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ: CAN-FIND is a calculated field?

Hello,

I looking for a way to see if a job number has a sub contract operation
in a BAQ without having the JobOper table as part of the BAQ.

I was hoping I could just create a logical calculated field that used
CAN-FIND but the editor doesn't seem to like it.

I tried these two approaches:

CAN-FIND(JobOper WHERE JobOper.Company = JobHead.Company and
JobOper.JobNum = JobHead.JobNum and JobOper.SubContract = true)

And

If CAN-FIND(JobOper WHERE JobOper.Company = JobHead.Company and
JobOper.JobNum = JobHead.JobNum and JobOper.SubContract = true) then

true

else

false

The editor complains about a syntax error, which I guess I'm not too
surprised.

Can I do what I'm trying to do with a calculated field?

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.

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

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










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


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



I looking for a way to see if a job number has a sub contract operation
in a BAQ without having the JobOper table as part of the BAQ.

I was hoping I could just create a logical calculated field that used
CAN-FIND but the editor doesn't seem to like it.



I tried these two approaches:



CAN-FIND(JobOper WHERE JobOper.Company = JobHead.Company and
JobOper.JobNum = JobHead.JobNum and JobOper.SubContract = true)



And



If CAN-FIND(JobOper WHERE JobOper.Company = JobHead.Company and
JobOper.JobNum = JobHead.JobNum and JobOper.SubContract = true) then

true

else

false



The editor complains about a syntax error, which I guess I'm not too
surprised.

Can I do what I'm trying to do with a calculated field?








Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
3
You can't look at info in a Table without having that table. I don't think
what you want can be done.


*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/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Fri, May 10, 2013 at 4:22 PM, Joe Rojas <jrojas@...> wrote:

> **
>
>
> Hello,
>
> I looking for a way to see if a job number has a sub contract operation
> in a BAQ without having the JobOper table as part of the BAQ.
>
> I was hoping I could just create a logical calculated field that used
> CAN-FIND but the editor doesn't seem to like it.
>
> I tried these two approaches:
>
> CAN-FIND(JobOper WHERE JobOper.Company = JobHead.Company and
> JobOper.JobNum = JobHead.JobNum and JobOper.SubContract = true)
>
> And
>
> If CAN-FIND(JobOper WHERE JobOper.Company = JobHead.Company and
> JobOper.JobNum = JobHead.JobNum and JobOper.SubContract = true) then
>
> true
>
> else
>
> false
>
> The editor complains about a syntax error, which I guess I'm not too
> surprised.
>
> Can I do what I'm trying to do with a calculated field?
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and
> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not the
> named addressee you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received this
> e-mail by mistake. Please note that any views or opinions presented in this
> email are solely those of the author and do not necessarily represent those
> of the company.
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
4
Join to JobOper

Filter for SUBCONTRACT = True

Use LEFT OUTER in case no Subcontract record, will
return blank fields.

Use FIRST instead of EACH in case of duplicates.



Patrick Winter



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Friday, May 10, 2013 15:23
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ: CAN-FIND is a calculated field?





Hello,

I looking for a way to see if a job number has a sub contract operation
in a BAQ without having the JobOper table as part of the BAQ.

I was hoping I could just create a logical calculated field that used
CAN-FIND but the editor doesn't seem to like it.

I tried these two approaches:

CAN-FIND(JobOper WHERE JobOper.Company = JobHead.Company and
JobOper.JobNum = JobHead.JobNum and JobOper.SubContract = true)

And

If CAN-FIND(JobOper WHERE JobOper.Company = JobHead.Company and
JobOper.JobNum = JobHead.JobNum and JobOper.SubContract = true) then

true

else

false

The editor complains about a syntax error, which I guess I'm not too
surprised.

Can I do what I'm trying to do with a calculated field?





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.

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





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