BPM Blank Title 70211

Good Afternoon,



Does anyone how in a BPM to set a field equal to a value that is in a
different field. I know who to set a field equal to a static value but
not how to set it to a value in a different field.





Thanks!



Dale



[Non-text portions of this message have been removed]
Is it possible to deine a BAQ with criteria to select against records
that have "null" in the Jobhead.TravelerLastPrinted field?
Set you criteria to compare the field against a know null date field such as Date10.

----- Original Message -----
From: corvette6672
To: vantage@yahoogroups.com
Sent: Wednesday, October 29, 2008 11:27 AM
Subject: [Vantage] BAQ against Jobhead


Is it possible to deine a BAQ with criteria to select against records
that have "null" in the Jobhead.TravelerLastPrinted field?




Charles Carden
IT Manager
Manitex, Inc.


[Non-text portions of this message have been removed]
No support for a null date test. You can however compare to an unpopulated Date## field (that will contain a null date value).

Rob

--- On Wed, 10/29/08, corvette6672 <corvette6672@...> wrote:

From: corvette6672 <corvette6672@...>
Subject: [Vantage] BAQ against Jobhead
To: vantage@yahoogroups.com
Date: Wednesday, October 29, 2008, 12:27 PM






Is it possible to deine a BAQ with criteria to select against records
that have "null" in the Jobhead.TravelerLas tPrinted field?
I used the phrase builder to create the following, but get no records
returned. If I look at the SQL database, both date fileds are null:
any ideas?

for each JobHead where ( JobHead.JobNum = '0000074' AND
JobHead.TravelerLastPrinted = JobHead.Date10) no-lock .

--- In vantage@yahoogroups.com, "Charles Carden" <shadowcar1449@...>
wrote:
>
> Set you criteria to compare the field against a know null date
field such as Date10.
>
> ----- Original Message -----
> From: corvette6672
> To: vantage@yahoogroups.com
> Sent: Wednesday, October 29, 2008 11:27 AM
> Subject: [Vantage] BAQ against Jobhead
>
>
> Is it possible to deine a BAQ with criteria to select against
records
> that have "null" in the Jobhead.TravelerLastPrinted field?
>
>
>
>
> Charles Carden
> IT Manager
> Manitex, Inc.
>
>
> [Non-text portions of this message have been removed]
>
Would a null evaluate to less than a specific dumb date like 01/01/1818?

Just a thought.



Mark



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of corvette6672
Sent: Wednesday, October 29, 2008 3:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ against Jobhead



I used the phrase builder to create the following, but get no records
returned. If I look at the SQL database, both date fileds are null:
any ideas?

for each JobHead where ( JobHead.JobNum = '0000074' AND
JobHead.TravelerLastPrinted = JobHead.Date10) no-lock .

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Charles Carden" <shadowcar1449@...>
wrote:
>
> Set you criteria to compare the field against a know null date
field such as Date10.
>
> ----- Original Message -----
> From: corvette6672
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Sent: Wednesday, October 29, 2008 11:27 AM
> Subject: [Vantage] BAQ against Jobhead
>
>
> Is it possible to deine a BAQ with criteria to select against
records
> that have "null" in the Jobhead.TravelerLastPrinted field?
>
>
>
>
> Charles Carden
> IT Manager
> Manitex, Inc.
>
>
> [Non-text portions of this message have been removed]
>





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



Perhaps you could try

Not > 01/01/1818

So anything that is not a valid date might show up?



Mark



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dupuis, Mark
Sent: Wednesday, October 29, 2008 3:40 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: BAQ against Jobhead





Would a null evaluate to less than a specific dumb date like 01/01/1818?

Just a thought.

Mark

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of corvette6672
Sent: Wednesday, October 29, 2008 3:35 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: BAQ against Jobhead

I used the phrase builder to create the following, but get no records
returned. If I look at the SQL database, both date fileds are null:
any ideas?

for each JobHead where ( JobHead.JobNum = '0000074' AND
JobHead.TravelerLastPrinted = JobHead.Date10) no-lock .

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"Charles Carden" <shadowcar1449@...>
wrote:
>
> Set you criteria to compare the field against a know null date
field such as Date10.
>
> ----- Original Message -----
> From: corvette6672
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Sent: Wednesday, October 29, 2008 11:27 AM
> Subject: [Vantage] BAQ against Jobhead
>
>
> Is it possible to deine a BAQ with criteria to select against
records
> that have "null" in the Jobhead.TravelerLastPrinted field?
>
>
>
>
> Charles Carden
> IT Manager
> Manitex, Inc.
>
>
> [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]
How do I get the "not" into the phrase? Oh how I wish I could just
create my own SQL statement instead of this dorky phrase builder!
--- In vantage@yahoogroups.com, "Dupuis, Mark" <mdupuis@...> wrote:
>
> Another thought
>
>
>
> Perhaps you could try
>
> Not > 01/01/1818
>
> So anything that is not a valid date might show up?
>
>
>
> Mark
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Dupuis, Mark
> Sent: Wednesday, October 29, 2008 3:40 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: BAQ against Jobhead
>
>
>
>
>
> Would a null evaluate to less than a specific dumb date like
01/01/1818?
>
> Just a thought.
>
> Mark
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> Of corvette6672
> Sent: Wednesday, October 29, 2008 3:35 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: BAQ against Jobhead
>
> I used the phrase builder to create the following, but get no
records
> returned. If I look at the SQL database, both date fileds are null:
> any ideas?
>
> for each JobHead where ( JobHead.JobNum = '0000074' AND
> JobHead.TravelerLastPrinted = JobHead.Date10) no-lock .
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> "Charles Carden" <shadowcar1449@>
> wrote:
> >
> > Set you criteria to compare the field against a know null date
> field such as Date10.
> >
> > ----- Original Message -----
> > From: corvette6672
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > Sent: Wednesday, October 29, 2008 11:27 AM
> > Subject: [Vantage] BAQ against Jobhead
> >
> >
> > Is it possible to deine a BAQ with criteria to select against
> records
> > that have "null" in the Jobhead.TravelerLastPrinted field?
> >
> >
> >
> >
> > Charles Carden
> > IT Manager
> > Manitex, Inc.
> >
> >
> > [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]
>
You could just use < 01/01/1818 instead of Not



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
corvette6672
Sent: Wednesday, October 29, 2008 4:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ against Jobhead



How do I get the "not" into the phrase? Oh how I wish I could just
create my own SQL statement instead of this dorky phrase builder!
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Dupuis,
Mark" <mdupuis@...> wrote:
>
> Another thought
>
>
>
> Perhaps you could try
>
> Not > 01/01/1818
>
> So anything that is not a valid date might show up?
>
>
>
> Mark
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Dupuis, Mark
> Sent: Wednesday, October 29, 2008 3:40 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Re: BAQ against Jobhead
>
>
>
>
>
> Would a null evaluate to less than a specific dumb date like
01/01/1818?
>
> Just a thought.
>
> Mark
>
> ________________________________
>
> 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 corvette6672
> Sent: Wednesday, October 29, 2008 3:35 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: BAQ against Jobhead
>
> I used the phrase builder to create the following, but get no
records
> returned. If I look at the SQL database, both date fileds are null:
> any ideas?
>
> for each JobHead where ( JobHead.JobNum = '0000074' AND
> JobHead.TravelerLastPrinted = JobHead.Date10) no-lock .
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> "Charles Carden" <shadowcar1449@>
> wrote:
> >
> > Set you criteria to compare the field against a know null date
> field such as Date10.
> >
> > ----- Original Message -----
> > From: corvette6672
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > Sent: Wednesday, October 29, 2008 11:27 AM
> > Subject: [Vantage] BAQ against Jobhead
> >
> >
> > Is it possible to deine a BAQ with criteria to select against
> records
> > that have "null" in the Jobhead.TravelerLastPrinted field?
> >
> >
> >
> >
> > Charles Carden
> > IT Manager
> > Manitex, Inc.
> >
> >
> > [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]
I tried < 01/01/1818 but it no rows are returned.
--- In vantage@yahoogroups.com, "Jeff Stockard" <jeff.stockard@...>
wrote:
>
> You could just use < 01/01/1818 instead of Not
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> corvette6672
> Sent: Wednesday, October 29, 2008 4:00 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ against Jobhead
>
>
>
> How do I get the "not" into the phrase? Oh how I wish I could just
> create my own SQL statement instead of this dorky phrase builder!
> --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> , "Dupuis,
> Mark" <mdupuis@> wrote:
> >
> > Another thought
> >
> >
> >
> > Perhaps you could try
> >
> > Not > 01/01/1818
> >
> > So anything that is not a valid date might show up?
> >
> >
> >
> > Mark
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> > Of Dupuis, Mark
> > Sent: Wednesday, October 29, 2008 3:40 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] Re: BAQ against Jobhead
> >
> >
> >
> >
> >
> > Would a null evaluate to less than a specific dumb date like
> 01/01/1818?
> >
> > Just a thought.
> >
> > Mark
> >
> > ________________________________
> >
> > 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 corvette6672
> > Sent: Wednesday, October 29, 2008 3:35 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: BAQ against Jobhead
> >
> > I used the phrase builder to create the following, but get no
> records
> > returned. If I look at the SQL database, both date fileds are
null:
> > any ideas?
> >
> > for each JobHead where ( JobHead.JobNum = '0000074' AND
> > JobHead.TravelerLastPrinted = JobHead.Date10) no-lock .
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > "Charles Carden" <shadowcar1449@>
> > wrote:
> > >
> > > Set you criteria to compare the field against a know null date
> > field such as Date10.
> > >
> > > ----- Original Message -----
> > > From: corvette6672
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > Sent: Wednesday, October 29, 2008 11:27 AM
> > > Subject: [Vantage] BAQ against Jobhead
> > >
> > >
> > > Is it possible to deine a BAQ with criteria to select against
> > records
> > > that have "null" in the Jobhead.TravelerLastPrinted field?
> > >
> > >
> > >
> > >
> > > Charles Carden
> > > IT Manager
> > > Manitex, Inc.
> > >
> > >
> > > [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]
>
Progress has a Y2K default setting of 1932 - adjustable, so 1818 is probably
being picked up as 2018.

Are you using a Progress db?

Try a date of 01/01/50 or 01/01/1950 - to be safe

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
corvette6672
Sent: Wednesday, October 29, 2008 4:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ against Jobhead

I tried < 01/01/1818 but it no rows are returned.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Jeff
Stockard" <jeff.stockard@...>
wrote:
>
> You could just use < 01/01/1818 instead of Not
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> corvette6672
> Sent: Wednesday, October 29, 2008 4:00 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: BAQ against Jobhead
>
>
>
> How do I get the "not" into the phrase? Oh how I wish I could just
> create my own SQL statement instead of this dorky phrase builder!
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%
40yahoogroups.com> , "Dupuis,
> Mark" <mdupuis@> wrote:
> >
> > Another thought
> >
> >
> >
> > Perhaps you could try
> >
> > Not > 01/01/1818
> >
> > So anything that is not a valid date might show up?
> >
> >
> >
> > Mark
> >
> >
> >
> > ________________________________
> >
> > 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 Dupuis, Mark
> > Sent: Wednesday, October 29, 2008 3:40 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] Re: BAQ against Jobhead
> >
> >
> >
> >
> >
> > Would a null evaluate to less than a specific dumb date like
> 01/01/1818?
> >
> > Just a thought.
> >
> > Mark
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%
> 40yahoogroups.com> ] On
> > Behalf
> > Of corvette6672
> > Sent: Wednesday, October 29, 2008 3:35 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: BAQ against Jobhead
> >
> > I used the phrase builder to create the following, but get no
> records
> > returned. If I look at the SQL database, both date fileds are
null:
> > any ideas?
> >
> > for each JobHead where ( JobHead.JobNum = '0000074' AND
> > JobHead.TravelerLastPrinted = JobHead.Date10) no-lock .
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > "Charles Carden" <shadowcar1449@>
> > wrote:
> > >
> > > Set you criteria to compare the field against a know null date
> > field such as Date10.
> > >
> > > ----- Original Message -----
> > > From: corvette6672
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > Sent: Wednesday, October 29, 2008 11:27 AM
> > > Subject: [Vantage] BAQ against Jobhead
> > >
> > >
> > > Is it possible to deine a BAQ with criteria to select against
> > records
> > > that have "null" in the Jobhead.TravelerLastPrinted field?
> > >
> > >
> > >
> > >
> > > Charles Carden
> > > IT Manager
> > > Manitex, Inc.
> > >
> > >
> > > [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]
>



[Non-text portions of this message have been removed]
In the phrase builder on the criteria screen you can type "not" into the
andor field and you can enter a left and right parenthesis in the leftp
and rightp fields.



Mark D



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of corvette6672
Sent: Wednesday, October 29, 2008 4:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ against Jobhead



How do I get the "not" into the phrase? Oh how I wish I could just
create my own SQL statement instead of this dorky phrase builder!
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Dupuis, Mark" <mdupuis@...> wrote:
>
> Another thought
>
>
>
> Perhaps you could try
>
> Not > 01/01/1818
>
> So anything that is not a valid date might show up?
>
>
>
> Mark
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Dupuis, Mark
> Sent: Wednesday, October 29, 2008 3:40 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Re: BAQ against Jobhead
>
>
>
>
>
> Would a null evaluate to less than a specific dumb date like
01/01/1818?
>
> Just a thought.
>
> Mark
>
> ________________________________
>
> 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 corvette6672
> Sent: Wednesday, October 29, 2008 3:35 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: BAQ against Jobhead
>
> I used the phrase builder to create the following, but get no
records
> returned. If I look at the SQL database, both date fileds are null:
> any ideas?
>
> for each JobHead where ( JobHead.JobNum = '0000074' AND
> JobHead.TravelerLastPrinted = JobHead.Date10) no-lock .
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> "Charles Carden" <shadowcar1449@>
> wrote:
> >
> > Set you criteria to compare the field against a know null date
> field such as Date10.
> >
> > ----- Original Message -----
> > From: corvette6672
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > Sent: Wednesday, October 29, 2008 11:27 AM
> > Subject: [Vantage] BAQ against Jobhead
> >
> >
> > Is it possible to deine a BAQ with criteria to select against
> records
> > that have "null" in the Jobhead.TravelerLastPrinted field?
> >
> >
> >
> >
> > Charles Carden
> > IT Manager
> > Manitex, Inc.
> >
> >
> > [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]
Here's what you do.

BAQ against just the JobHead table.
Include two filters for Job Complete = false and Job Closed = false

Display columns would be the following
JobHead.JobNum
JobHead.TravelerLastPrinted

Add a calculated field to your query.
The calculation would be as follows:

If JobHead.TravelerLastPrinted <> " "
then "YES"
else "NO"

Format = x(3)
DataType = Character

When you run the query, sort columns for all "NO"
You will still get the "YES" but they will all be to the bottom.
Adding this query to a dashboard will provide you the ability to
FILTER to only see all the "NO"

Thanks
Patty Buechler
UV Color



--- In vantage@yahoogroups.com, "Dupuis, Mark" <mdupuis@...> wrote:
>
> In the phrase builder on the criteria screen you can type "not"
into the
> andor field and you can enter a left and right parenthesis in the
leftp
> and rightp fields.
>
>
>
> Mark D
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of corvette6672
> Sent: Wednesday, October 29, 2008 4:00 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ against Jobhead
>
>
>
> How do I get the "not" into the phrase? Oh how I wish I could just
> create my own SQL statement instead of this dorky phrase builder!
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Dupuis, Mark" <mdupuis@> wrote:
> >
> > Another thought
> >
> >
> >
> > Perhaps you could try
> >
> > Not > 01/01/1818
> >
> > So anything that is not a valid date might show up?
> >
> >
> >
> > Mark
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> > Of Dupuis, Mark
> > Sent: Wednesday, October 29, 2008 3:40 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] Re: BAQ against Jobhead
> >
> >
> >
> >
> >
> > Would a null evaluate to less than a specific dumb date like
> 01/01/1818?
> >
> > Just a thought.
> >
> > Mark
> >
> > ________________________________
> >
> > 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 corvette6672
> > Sent: Wednesday, October 29, 2008 3:35 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: BAQ against Jobhead
> >
> > I used the phrase builder to create the following, but get no
> records
> > returned. If I look at the SQL database, both date fileds are
null:
> > any ideas?
> >
> > for each JobHead where ( JobHead.JobNum = '0000074' AND
> > JobHead.TravelerLastPrinted = JobHead.Date10) no-lock .
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > "Charles Carden" <shadowcar1449@>
> > wrote:
> > >
> > > Set you criteria to compare the field against a know null date
> > field such as Date10.
> > >
> > > ----- Original Message -----
> > > From: corvette6672
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > Sent: Wednesday, October 29, 2008 11:27 AM
> > > Subject: [Vantage] BAQ against Jobhead
> > >
> > >
> > > Is it possible to deine a BAQ with criteria to select against
> > records
> > > that have "null" in the Jobhead.TravelerLastPrinted field?
> > >
> > >
> > >
> > >
> > > Charles Carden
> > > IT Manager
> > > Manitex, Inc.
> > >
> > >
> > > [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]
>
One more thought...

Create the BAQ without the Calculated field.
Add the BAQ to a Dashboard. The Dashboards do allow you to filter by
Constants. One of the available Constants is NULLDATE (near the
bottom of the list).

Thanks
Patty Buechler
UV Color


--- In vantage@yahoogroups.com, "bpbuechler" <pbuechler@...> wrote:
>
> Here's what you do.
>
> BAQ against just the JobHead table.
> Include two filters for Job Complete = false and Job Closed = false
>
> Display columns would be the following
> JobHead.JobNum
> JobHead.TravelerLastPrinted
>
> Add a calculated field to your query.
> The calculation would be as follows:
>
> If JobHead.TravelerLastPrinted <> " "
> then "YES"
> else "NO"
>
> Format = x(3)
> DataType = Character
>
> When you run the query, sort columns for all "NO"
> You will still get the "YES" but they will all be to the bottom.
> Adding this query to a dashboard will provide you the ability to
> FILTER to only see all the "NO"
>
> Thanks
> Patty Buechler
> UV Color
>
>
>
> --- In vantage@yahoogroups.com, "Dupuis, Mark" <mdupuis@> wrote:
> >
> > In the phrase builder on the criteria screen you can type "not"
> into the
> > andor field and you can enter a left and right parenthesis in the
> leftp
> > and rightp fields.
> >
> >
> >
> > Mark D
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of corvette6672
> > Sent: Wednesday, October 29, 2008 4:00 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: BAQ against Jobhead
> >
> >
> >
> > How do I get the "not" into the phrase? Oh how I wish I could
just
> > create my own SQL statement instead of this dorky phrase builder!
> > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ,
> > "Dupuis, Mark" <mdupuis@> wrote:
> > >
> > > Another thought
> > >
> > >
> > >
> > > Perhaps you could try
> > >
> > > Not > 01/01/1818
> > >
> > > So anything that is not a valid date might show up?
> > >
> > >
> > >
> > > Mark
> > >
> > >
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%
> 40yahoogroups.com> ] On
> > Behalf
> > > Of Dupuis, Mark
> > > Sent: Wednesday, October 29, 2008 3:40 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: RE: [Vantage] Re: BAQ against Jobhead
> > >
> > >
> > >
> > >
> > >
> > > Would a null evaluate to less than a specific dumb date like
> > 01/01/1818?
> > >
> > > Just a thought.
> > >
> > > Mark
> > >
> > > ________________________________
> > >
> > > 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 corvette6672
> > > Sent: Wednesday, October 29, 2008 3:35 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: BAQ against Jobhead
> > >
> > > I used the phrase builder to create the following, but get no
> > records
> > > returned. If I look at the SQL database, both date fileds are
> null:
> > > any ideas?
> > >
> > > for each JobHead where ( JobHead.JobNum = '0000074' AND
> > > JobHead.TravelerLastPrinted = JobHead.Date10) no-lock .
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > "Charles Carden" <shadowcar1449@>
> > > wrote:
> > > >
> > > > Set you criteria to compare the field against a know null
date
> > > field such as Date10.
> > > >
> > > > ----- Original Message -----
> > > > From: corvette6672
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > > Sent: Wednesday, October 29, 2008 11:27 AM
> > > > Subject: [Vantage] BAQ against Jobhead
> > > >
> > > >
> > > > Is it possible to deine a BAQ with criteria to select against
> > > records
> > > > that have "null" in the Jobhead.TravelerLastPrinted field?
> > > >
> > > >
> > > >
> > > >
> > > > Charles Carden
> > > > IT Manager
> > > > Manitex, Inc.
> > > >
> > > >
> > > > [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]
> >
>
Try reversing the BAQ criteria statement. Intead of:

JobHead.TravelerLastPrinted <= JobHead.Date10

try:

JobHead.Date10 >= JobHead.TravelerLastPrinted

Shouldn't matter - but it might if your data is recently imported (and perhaps the import inserted " " instead of null in some fields) or if you have a customization or BPM populating similarly odd data unbeknownst to you.

We use this technique in many BAQs and it has worked fine from 403 thru 405a.

Rob

--- On Wed, 10/29/08, corvette6672 <corvette6672@...> wrote:

From: corvette6672 <corvette6672@...>
Subject: [Vantage] Re: BAQ against Jobhead
To: vantage@yahoogroups.com
Date: Wednesday, October 29, 2008, 4:00 PM






How do I get the "not" into the phrase? Oh how I wish I could just
create my own SQL statement instead of this dorky phrase builder!
--- In vantage@yahoogroups .com, "Dupuis, Mark" <mdupuis@... > wrote:
>
> Another thought
>
>
>
> Perhaps you could try
>
> Not > 01/01/1818
>
> So anything that is not a valid date might show up?
>
>
>
> Mark
>
>
>
> ____________ _________ _________ __
>
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
> Of Dupuis, Mark
> Sent: Wednesday, October 29, 2008 3:40 PM
> To: vantage@yahoogroups .com
> Subject: RE: [Vantage] Re: BAQ against Jobhead
>
>
>
>
>
> Would a null evaluate to less than a specific dumb date like
01/01/1818?
>
> Just a thought.
>
> Mark
>
> ____________ _________ _________ __
>
> From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> [mailto:vantage@yahoogroups .com <mailto:vantage%
40yahoogroups. com> ] On
> Behalf
> Of corvette6672
> Sent: Wednesday, October 29, 2008 3:35 PM
> To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> Subject: [Vantage] Re: BAQ against Jobhead
>
> I used the phrase builder to create the following, but get no
records
> returned. If I look at the SQL database, both date fileds are null:
> any ideas?
>
> for each JobHead where ( JobHead.JobNum = '0000074' AND
> JobHead.TravelerLas tPrinted = JobHead.Date10) no-lock .
>
> --- In vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> <mailto:vantage% 40yahoogroups. com> ,
> "Charles Carden" <shadowcar1449@ >
> wrote:
> >
> > Set you criteria to compare the field against a know null date
> field such as Date10.
> >
> > ----- Original Message -----
> > From: corvette6672
> > To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> <mailto:vantage% 40yahoogroups. com>
> > Sent: Wednesday, October 29, 2008 11:27 AM
> > Subject: [Vantage] BAQ against Jobhead
> >
> >
> > Is it possible to deine a BAQ with criteria to select against
> records
> > that have "null" in the Jobhead.TravelerLas tPrinted field?
> >
> >
> >
> >
> > Charles Carden
> > IT Manager
> > Manitex, Inc.
> >
> >
> > [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]
>
I got it to work using a calculated field on a dashboard! Thank you
everyone for you assistance on this!
--- In vantage@yahoogroups.com, "bpbuechler" <pbuechler@...> wrote:
>
> Here's what you do.
>
> BAQ against just the JobHead table.
> Include two filters for Job Complete = false and Job Closed = false
>
> Display columns would be the following
> JobHead.JobNum
> JobHead.TravelerLastPrinted
>
> Add a calculated field to your query.
> The calculation would be as follows:
>
> If JobHead.TravelerLastPrinted <> " "
> then "YES"
> else "NO"
>
> Format = x(3)
> DataType = Character
>
> When you run the query, sort columns for all "NO"
> You will still get the "YES" but they will all be to the bottom.
> Adding this query to a dashboard will provide you the ability to
> FILTER to only see all the "NO"
>
> Thanks
> Patty Buechler
> UV Color
>
>
>
> --- In vantage@yahoogroups.com, "Dupuis, Mark" <mdupuis@> wrote:
> >
> > In the phrase builder on the criteria screen you can type "not"
> into the
> > andor field and you can enter a left and right parenthesis in the
> leftp
> > and rightp fields.
> >
> >
> >
> > Mark D
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of corvette6672
> > Sent: Wednesday, October 29, 2008 4:00 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: BAQ against Jobhead
> >
> >
> >
> > How do I get the "not" into the phrase? Oh how I wish I could
just
> > create my own SQL statement instead of this dorky phrase builder!
> > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ,
> > "Dupuis, Mark" <mdupuis@> wrote:
> > >
> > > Another thought
> > >
> > >
> > >
> > > Perhaps you could try
> > >
> > > Not > 01/01/1818
> > >
> > > So anything that is not a valid date might show up?
> > >
> > >
> > >
> > > Mark
> > >
> > >
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%
> 40yahoogroups.com> ] On
> > Behalf
> > > Of Dupuis, Mark
> > > Sent: Wednesday, October 29, 2008 3:40 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: RE: [Vantage] Re: BAQ against Jobhead
> > >
> > >
> > >
> > >
> > >
> > > Would a null evaluate to less than a specific dumb date like
> > 01/01/1818?
> > >
> > > Just a thought.
> > >
> > > Mark
> > >
> > > ________________________________
> > >
> > > 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 corvette6672
> > > Sent: Wednesday, October 29, 2008 3:35 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: BAQ against Jobhead
> > >
> > > I used the phrase builder to create the following, but get no
> > records
> > > returned. If I look at the SQL database, both date fileds are
> null:
> > > any ideas?
> > >
> > > for each JobHead where ( JobHead.JobNum = '0000074' AND
> > > JobHead.TravelerLastPrinted = JobHead.Date10) no-lock .
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > "Charles Carden" <shadowcar1449@>
> > > wrote:
> > > >
> > > > Set you criteria to compare the field against a know null
date
> > > field such as Date10.
> > > >
> > > > ----- Original Message -----
> > > > From: corvette6672
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > > Sent: Wednesday, October 29, 2008 11:27 AM
> > > > Subject: [Vantage] BAQ against Jobhead
> > > >
> > > >
> > > > Is it possible to deine a BAQ with criteria to select against
> > > records
> > > > that have "null" in the Jobhead.TravelerLastPrinted field?
> > > >
> > > >
> > > >
> > > >
> > > > Charles Carden
> > > > IT Manager
> > > > Manitex, Inc.
> > > >
> > > >
> > > > [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]
> >
>