BPM Question - Date Comparison

Sorry no clue on that one you will have to let some one else field that
question.



Take that rowmod = a out maybe cuz obviously you aren't adding one.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
melissa hietala
Sent: Monday, March 09, 2009 4:36 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM Question - Date Comparison



Charlie,

Thanks for the response. This was my original plan of action as well,
however I am running into a problem with this. I am putting the following
code in the query:

for each ttJobHead where (ttJobHead.RowMod = 'U' or ttJobhead.RowMod = 'A')
,
each JobHead where JobHead.JobNum = ttjobhead.JobNum and
jobhead.ReqDueDate < ttjobhead.reqduedate no-lock

But when I go into Job Entry, change the reqduedate, and attempt to save the
record I get an error message that states:
"The field ttJobHead.AnalysisCdDescription does not have a valid data type."

This message does not come up if the BPM is disabled, so for some reason the
BPM is triggering this response. It appears to be choosing the first field
(chronological order) in the JobHead table and triggering this error
message.

Any thoughts on why this would be????

Thanks again,

Dustin Biniek
UMC, Inc.
DustinB@ultramc. <mailto:DustinB%40ultramc.com> com

________________________________
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Monday, March 9, 2009 2:57:29 PM
Subject: RE: [Vantage] BPM Question - Date Comparison

for each ttJobHead

where (ttJobHead.RowMod = 'U' or ttJobhead..RowMod = 'A')

each JobHead

where JobHead.JobNum = ttjobhead.JobNum and

jobhead.date < ttjobhead.date

put this in for your query on a "number of rows in the 'query' is more than
0

you will have to adjust accordingly but hopefully this gets you on the right
path.

Basically this compares the old entry to the new entry. and returns rows
that qualify and if one quals the results will be more than 0 rows so it
will kick off your email.

Good luck

~Charlie

_____

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of
melissa hietala
Sent: Monday, March 09, 2009 3:48 PM
To: vantage@yahoogroups .com
Subject: [Vantage] BPM Question - Date Comparison

I currently have a BPM setup that sends an email out when the
"JobHead....ReqDueDa t e" changes. I now have a request to modify this BPM
so
that the email is only sent when the RequiredByDate moves forward in time.
For instance, if the ReqByDate was originally 5/1/2009 and has been pulled
forward to 4/1/2009, an email would be sent. But if the ReqByDate was
originally 4/1/2009 and has been pushed back to 5/1/2009, an email would NOT
be sent. Anyone been able to do something like this?

Thanks,

Dustin Biniek
UMC, Inc.
DustinB@ultramc. <mailto:DustinB% 40ultramc. com> com

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

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.9/1991 - Release Date: 03/09/09
07:14:00

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

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



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.9/1991 - Release Date: 03/09/09
07:14:00




[Non-text portions of this message have been removed]
I currently have a BPM setup that sends an email out when the "JobHead..ReqDueDate" changes. I now have a request to modify this BPM so that the email is only sent when the RequiredByDate moves forward in time. For instance, if the ReqByDate was originally 5/1/2009 and has been pulled forward to 4/1/2009, an email would be sent. But if the ReqByDate was originally 4/1/2009 and has been pushed back to 5/1/2009, an email would NOT be sent.  Any ideas on how I can accomplish this?

Thanks
Â
Dustin Biniek
UMC, Inc.
DustinB@...




[Non-text portions of this message have been removed]
I currently have a BPM setup that sends an email out when the "JobHead..ReqDueDate" changes. I now have a request to modify this BPM so that the email is only sent when the RequiredByDate moves forward in time. For instance, if the ReqByDate was originally 5/1/2009 and has been pulled forward to 4/1/2009, an email would be sent. But if the ReqByDate was originally 4/1/2009 and has been pushed back to 5/1/2009, an email would NOT be sent.  Any ideas on how I can accomplish this?

Thanks
Â
Dustin Biniek
UMC, Inc.
DustinB@...




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

If you were using a BAM instead of a BPM, I *think* you could use:

"if oldJobHead.ReqDueDate < JobHead.ReqDueDate"

Prefixing "old" to any field holds the data before any change was
made.

I'm not sure if you can use this in a BPM though.


Might be of some help.

Nigel.



--- In vantage@yahoogroups.com, melissa hietala <kevmel822@...> wrote:
>
> I currently have a BPM setup that sends an email out when the
"JobHead..ReqDueDate" changes. I now have a request to modify this
BPM so that the email is only sent when the RequiredByDate moves
forward in time. For instance, if the ReqByDate was originally
5/1/2009 and has been pulled forward to 4/1/2009, an email would be
sent. But if the ReqByDate was originally 4/1/2009 and has
been pushed back to 5/1/2009, an email would NOT be sent.  Any ideas
on how I can accomplish this?
>
> Thanks
> Â
> Dustin Biniek
> UMC, Inc.
> DustinB@...
>
>
>
>
> [Non-text portions of this message have been removed]
>
Thanks for the response Nigel. Unfortunately I wasn't able to get this to work. Are there any other ideas on how I can get this scenario to work? Any thoughts would be greatly appreciated!

Thanks,
Â
Dustin Biniek
UMC, Inc.
DustinB@...




________________________________
From: Nigel Kerley <nigel.kerley@...>
To: vantage@yahoogroups.com
Sent: Tuesday, February 10, 2009 11:39:56 AM
Subject: [Vantage] Re: BPM Question - Date Comparison


Hi Dustin,

If you were using a BAM instead of a BPM, I *think* you could use:

"if oldJobHead.ReqDueDa te < JobHead.ReqDueDate"

Prefixing "old" to any field holds the data before any change was
made.

I'm not sure if you can use this in a BPM though.

Might be of some help.

Nigel.

--- In vantage@yahoogroups .com, melissa hietala <kevmel822@. ..> wrote:
>
> I currently have a BPM setup that sends an email out when the
"JobHead..ReqDueDat e" changes. I now have a request to modify this
BPM so that the email is only sent when the RequiredByDate moves
forward in time. For instance, if the ReqByDate was originally
5/1/2009 and has been pulled forward to 4/1/2009, an email would be
sent. But if the ReqByDate was originally 4/1/2009 and has
been pushed back to 5/1/2009, an email would NOT be sent.  Any ideas
on how I can accomplish this?
>
> Thanks
> Â
> Dustin Biniek
> UMC, Inc.
> DustinB@...
>
>
>
>
> [Non-text portions of this message have been removed]
>







[Non-text portions of this message have been removed]
The only other thing I can think of would be to try and put a BPM in
place that actions on the loading of a Job, maybe using
JobEntry.GetByID. You could copy the ReqDueDate into a UD date field.

Then put another BPM in place on the Update BO that compares these
two dates and send your email based on the results.


Nigel.


--- In vantage@yahoogroups.com, melissa hietala <kevmel822@...> wrote:
>
> Thanks for the response Nigel. Unfortunately I wasn't able to get
this to work. Are there any other ideas on how I can get this
scenario to work? Any thoughts would be greatly appreciated!
>
> Thanks,
> Â
> Dustin Biniek
> UMC, Inc.
> DustinB@...
>
>
>
>
> ________________________________
> From: Nigel Kerley <nigel.kerley@...>
> To: vantage@yahoogroups.com
> Sent: Tuesday, February 10, 2009 11:39:56 AM
> Subject: [Vantage] Re: BPM Question - Date Comparison
>
>
> Hi Dustin,
>
> If you were using a BAM instead of a BPM, I *think* you could use:
>
> "if oldJobHead.ReqDueDa te < JobHead.ReqDueDate"
>
> Prefixing "old" to any field holds the data before any change was
> made.
>
> I'm not sure if you can use this in a BPM though.
>
> Might be of some help.
>
> Nigel.
>
> --- In vantage@yahoogroups .com, melissa hietala <kevmel822@ ..>
wrote:
> >
> > I currently have a BPM setup that sends an email out when the
> "JobHead..ReqDueDat e" changes. I now have a request to modify
this
> BPM so that the email is only sent when the RequiredByDate moves
> forward in time. For instance, if the ReqByDate was originally
> 5/1/2009 and has been pulled forward to 4/1/2009, an email would be
> sent. But if the ReqByDate was originally 4/1/2009 and has
> been pushed back to 5/1/2009, an email would NOT be
sent.  Any ideas
> on how I can accomplish this?
> >
> > Thanks
> > Â
> > Dustin Biniek
> > UMC, Inc.
> > DustinB@
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I currently have a BPM setup that sends an email out when the "JobHead...ReqDueDat e" changes. I now have a request to modify this BPM so that the email is only sent when the RequiredByDate moves forward in time. For instance, if the ReqByDate was originally 5/1/2009 and has been pulled forward to 4/1/2009, an email would be sent. But if the ReqByDate was originally 4/1/2009 and has been pushed back to 5/1/2009, an email would NOT be sent.  Anyone been able to do something like this?

Thanks,

Dustin Biniek
UMC, Inc.
DustinB@...




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

where (ttJobHead.RowMod = 'U' or ttJobhead.RowMod = 'A')

each JobHead

where JobHead.JobNum = ttjobhead.JobNum and

jobhead.date < ttjobhead.date



put this in for your query on a "number of rows in the 'query' is more than
0



you will have to adjust accordingly but hopefully this gets you on the right
path.



Basically this compares the old entry to the new entry. and returns rows
that qualify and if one quals the results will be more than 0 rows so it
will kick off your email.



Good luck



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
melissa hietala
Sent: Monday, March 09, 2009 3:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM Question - Date Comparison



I currently have a BPM setup that sends an email out when the
"JobHead...ReqDueDat e" changes. I now have a request to modify this BPM so
that the email is only sent when the RequiredByDate moves forward in time.
For instance, if the ReqByDate was originally 5/1/2009 and has been pulled
forward to 4/1/2009, an email would be sent. But if the ReqByDate was
originally 4/1/2009 and has been pushed back to 5/1/2009, an email would NOT
be sent. Anyone been able to do something like this?

Thanks,

Dustin Biniek
UMC, Inc.
DustinB@ultramc. <mailto:DustinB%40ultramc.com> com

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



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.9/1991 - Release Date: 03/09/09
07:14:00




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

Thanks for the response. This was my original plan of action as well, however I am running into a problem with this. I am putting the following code in the query:

for each ttJobHead where (ttJobHead.RowMod = 'U' or ttJobhead.RowMod = 'A') ,
each JobHead where JobHead.JobNum = ttjobhead.JobNum and
jobhead.ReqDueDate < ttjobhead.reqduedate no-lock

But when I go into Job Entry, change the reqduedate, and attempt to save the record I get an error message that states:
"The field ttJobHead.AnalysisCdDescription does not have a valid data type."
Â
This message does not come up if the BPM is disabled, so for some reason the BPM is triggering this response. It appears to be choosing the first field (chronological order) in the JobHead table and triggering this error message.
Â
Any thoughts on why this would be????
Â
Thanks again,
Â
Dustin Biniek
UMC, Inc.
DustinB@...




________________________________
From: Charlie Wilson <foamdesigncsw@...>
To: vantage@yahoogroups.com
Sent: Monday, March 9, 2009 2:57:29 PM
Subject: RE: [Vantage] BPM Question - Date Comparison


for each ttJobHead

where (ttJobHead.RowMod = 'U' or ttJobhead..RowMod = 'A')

each JobHead

where JobHead.JobNum = ttjobhead.JobNum and

jobhead.date < ttjobhead.date

put this in for your query on a "number of rows in the 'query' is more than
0

you will have to adjust accordingly but hopefully this gets you on the right
path.

Basically this compares the old entry to the new entry. and returns rows
that qualify and if one quals the results will be more than 0 rows so it
will kick off your email.

Good luck

~Charlie

_____

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
melissa hietala
Sent: Monday, March 09, 2009 3:48 PM
To: vantage@yahoogroups .com
Subject: [Vantage] BPM Question - Date Comparison

I currently have a BPM setup that sends an email out when the
"JobHead....ReqDueDa t e" changes. I now have a request to modify this BPM so
that the email is only sent when the RequiredByDate moves forward in time.
For instance, if the ReqByDate was originally 5/1/2009 and has been pulled
forward to 4/1/2009, an email would be sent. But if the ReqByDate was
originally 4/1/2009 and has been pushed back to 5/1/2009, an email would NOT
be sent. Anyone been able to do something like this?

Thanks,

Dustin Biniek
UMC, Inc.
DustinB@ultramc. <mailto:DustinB% 40ultramc. com> com

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

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.9/1991 - Release Date: 03/09/09
07:14:00

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







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