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]
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]