You can also just use TRUE and FALSE as the constant without quotes.
--- In vantage@yahoogroups.com, Gerard Haviland <g2hav@...> wrote:
>
> What I use in 8.0 for check box's is:
> If I want the boxes that are checked I use ("Y") as the
constant. It requires the " along with either Y or N.
> Here is what one of my BAQ's looks like
>
> for each OrderHed where ( OrderHed.OpenOrder = 'Y' And
OrderHed.CreditOverride = 'N') no-lock , each Customer where (
Customer.CreditHold = 'Y') and (Customer.Company = OrderHed.Company
and Customer.CustNum = OrderHed.CustNum) no-lock by OrderHed.OrderDate
by OrderHed.OrderNum.
>
> Hope this helps.
>
> Have a Happy New Year.
>
> Gerry Haviland
>
>
> ----- Original Message ----
> From: russnewcomer <rnewcomer@...>
> To: vantage@yahoogroups.com
> Sent: Friday, December 29, 2006 7:45:20 AM
> Subject: [Vantage] Re: Asking for some BAQ tips
>
> I would, but I can't do that. Sorry, should have specified that I'm
> on 8.0, they don't allow you to modify your queries directly, unless
> there is something I've missed.
>
> I also tried exporting it and editing the XML to have the "= yes" in
> the query, and when it imports, it strikes the "= yes" from the query.
>
> Thanks
>
> RussN
>
> --- In vantage@yahoogroups .com, "Chris Crosta" <chris@> wrote:
> >
> > Russ,
> >
> > Just add yes after the = in the query statement and it should run.
> >
> >
> >
> > Chris
> >
> >
> >
> > _____
> >
> > From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com]
On Behalf
> > Of russnewcomer
> > Sent: Thursday, December 28, 2006 2:40 PM
> > To: vantage@yahoogroups .com
> > Subject: [Vantage] Asking for some BAQ tips
> >
> >
> >
> > I am trying to create a BAQ that shows jobs that are completed but not
> > shipped. My thought was to grab all jobs where the JobHead.Candidate
> > field is checked, and where we have a JobHead.QtyComplete d >=
> > JobHead.ProdQty
> >
> > Here's what phrase builder built for me :
> >
> > for each JobHead where ( JobHead.Candidate = yes Or
> > JobHead.QtyComplete d >= JobHead.ProdQty) no-lock , each JobProd where
> > (JobProd.Company = JobHead.Company and JobProd.JobNum =
> > JobHead.JobNum) no-lock , each OrderDtl where (OrderDtl.Company =
> > JobProd.Company and OrderDtl.OrderNum = JobProd.OrderNum and
> > OrderDtl.OrderLine = JobProd.OrderLine) no-lock , each ShipDtl
> > outer-join where (ShipDtl.Company = OrderDtl.Company and
> > ShipDtl.OrderNum = OrderDtl.OrderNum and ShipDtl.OrderLine =
> > OrderDtl.OrderLine) no-lock .
> >
> > Notice the JobHead.Candidate = line. No matter what I put in the
> > Constant line in Phrase builder (tried 1, 'Yes', 'YES', YES, True,
> > TRUE, 'TRUE'), I get nothing in the Query Display.
> >
> > I called Tech Support, and they were not immediately able to help me
> > out, so... I'm asking the group. Am I missing something obvious, or
> > is there some little 'must-do' to getting yes/no fields to be
> > searchable using a BAQ?
> >
> > Thanks!
> >
> > Russ Newcomer
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> [Non-text portions of this message have been removed]
>