BAM Alert Blank Title 82891

Yahoo Archive
1
Aaron,

Thanks for the help. Your suggestion work with one change, I had to use OldJobOper.Number01 instead of Old.JobOper.Number01.

Thanks again.


Thanks,



Rich Wagner



[cid:image001.jpg@01CA3785.8AC16A70]





412-384-3100

rwagner@...<mailto:rwagner@...>

www.bawplastics.com<http://www.bawplastics.com/>


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Aaron Hoyt
Sent: Thursday, September 17, 2009 9:29 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAM Alert



Rich,
Use the Old.Table.Field format to compare (in your case
Old.JobOper.Number01>0).
You will have to execute this through a .p file, but there is a ton of
history in this very list about .p files and BAMs (not an insignificant
portion directly from me).
I don't work much with .p files anymore, but I still am writing progress
code in BPMs in 8.x, so I can offer more assistance if needed.
Aaron Hoyt

RICH WAGNER wrote:
>
>
> We are on 6.1 so a BPM is not an option right now. Do you mean I would
> write the old value to JobOper.Number02 and the new value would be in
> JobOper.Number01?
>
> Thanks,
>
> Rich Wagner
>
> 412-384-3100
>
> rwagner@...<mailto:rwagner%40bawplastics.com>
> <mailto:rwagner%40bawplastics.com><mailto:rwagner@...<mailto:rwagner%40bawplastics.com>
> <mailto:rwagner%40bawplastics.com>>
>
> www.bawplastics.com<http://www.bawplastics.com/
> <http://www.bawplastics.com/>>
>
> ________________________________
> 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 Steven Gotschall
> Sent: Thursday, September 17, 2009 8:50 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] BAM Alert
>
> You could do this with a BPM, but with a BAM I think you are going to
> have to have two BAMS. One would execute a .p procedure that would set
> JobOper.Number02 = JobOper.Number01 whenever Number01 changes. The
> other one would have to execute first and would send the email when
> JobOper.Number01 changes and JobOper.Number02 <> 0. The order here
> would be very important. I haven't tried it, but it should work.
>
> ________________________________
> From: RICH WAGNER <rwagner@...<mailto:rwagner%40bawplastics.com>
> <mailto:rwagner%40bawplastics.com><mailto:rwagner%40bawplastics.com>>
> To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>"
> <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>>
> Sent: Thursday, September 17, 2009 8:25:46 AM
> Subject: [Vantage] BAM Alert
>
> I am trying to setup a BAM to send an email when a change occurs to
> the JobOper.Number01 field, but I only want to send the email when the
> original value was something other than 0.
>
> Is this even possible?
>
> Thanks,
>
> Rich Wagner
>
> [cid:image002.jpg@ 01CA3770. 74A86BE0]
>
> 412-384-3100
>
> rwagner@bawplastics .com<mailto:rwagner@bawplastics .com>
>
> www.bawplastics. com<http://www.bawplastics.com/
> <http://www.bawplastics.com/>>
>
> [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]
2
I am trying to setup a BAM to send an email when a change occurs to the JobOper.Number01 field, but I only want to send the email when the original value was something other than 0.

Is this even possible?


Thanks,



Rich Wagner



[cid:image002.jpg@01CA3770.74A86BE0]





412-384-3100

rwagner@...<mailto:rwagner@...>

www.bawplastics.com<http://www.bawplastics.com/>




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

So you mean if the number is anything other than 0 send an email?




________________________________
From: RICH WAGNER <rwagner@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thursday, 17 September, 2009 13:25:46
Subject: [Vantage] BAM Alert

Â
I am trying to setup a BAM to send an email when a change occurs to the JobOper.Number01 field, but I only want to send the email when the original value was something other than 0.

Is this even possible?

Thanks,

Rich Wagner

[cid:image002.jpg@ 01CA3770. 74A86BE0]

412-384-3100

rwagner@bawplastics .com<mailto:rwagner@bawplastics .com>

www.bawplastics. com<http://www.bawplast ics.com/>

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







[Non-text portions of this message have been removed]
4
You could do this with a BPM, but with a BAM I think you are going to have to have two BAMS. One would execute a .p procedure that would set JobOper.Number02 = JobOper.Number01 whenever Number01 changes. The other one would have to execute first and would send the email when JobOper.Number01 changes and JobOper.Number02 <> 0. The order here would be very important. I haven't tried it, but it should work.




________________________________
From: RICH WAGNER <rwagner@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thursday, September 17, 2009 8:25:46 AM
Subject: [Vantage] BAM Alert

Â
I am trying to setup a BAM to send an email when a change occurs to the JobOper.Number01 field, but I only want to send the email when the original value was something other than 0.

Is this even possible?

Thanks,

Rich Wagner

[cid:image002.jpg@ 01CA3770. 74A86BE0]

412-384-3100

rwagner@bawplastics .com<mailto:rwagner@bawplastics .com>

www.bawplastics. com<http://www.bawplastics.com/>

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







[Non-text portions of this message have been removed]
5
I mean if the current number is 2 and I change it to 3 I want to send an email. I don't want to send an email if the number was 0 and changed to 3.


Thanks,



Rich Wagner



[cid:image001.jpg@01CA3775.939DE3E0]





412-384-3100

rwagner@...<mailto:rwagner@...>

www.bawplastics.com<http://www.bawplastics.com/>


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Thursday, September 17, 2009 8:47 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAM Alert



Hi,

So you mean if the number is anything other than 0 send an email?

________________________________
From: RICH WAGNER <rwagner@...<mailto:rwagner%40bawplastics.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Thursday, 17 September, 2009 13:25:46
Subject: [Vantage] BAM Alert


I am trying to setup a BAM to send an email when a change occurs to the JobOper.Number01 field, but I only want to send the email when the original value was something other than 0.

Is this even possible?

Thanks,

Rich Wagner

[cid:image002.jpg@ 01CA3770. 74A86BE0]

412-384-3100

rwagner@bawplastics .com<mailto:rwagner@bawplastics .com>

www.bawplastics. com<http://www.bawplast ics.com/>

[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]
6
We are on 6.1 so a BPM is not an option right now. Do you mean I would write the old value to JobOper.Number02 and the new value would be in JobOper.Number01?


Thanks,



Rich Wagner





412-384-3100

rwagner@...<mailto:rwagner@...>

www.bawplastics.com<http://www.bawplastics.com/>


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Thursday, September 17, 2009 8:50 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAM Alert



You could do this with a BPM, but with a BAM I think you are going to have to have two BAMS. One would execute a .p procedure that would set JobOper.Number02 = JobOper.Number01 whenever Number01 changes. The other one would have to execute first and would send the email when JobOper.Number01 changes and JobOper.Number02 <> 0. The order here would be very important. I haven't tried it, but it should work.

________________________________
From: RICH WAGNER <rwagner@...<mailto:rwagner%40bawplastics.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Thursday, September 17, 2009 8:25:46 AM
Subject: [Vantage] BAM Alert


I am trying to setup a BAM to send an email when a change occurs to the JobOper.Number01 field, but I only want to send the email when the original value was something other than 0.

Is this even possible?

Thanks,

Rich Wagner

[cid:image002.jpg@ 01CA3770. 74A86BE0]

412-384-3100

rwagner@bawplastics .com<mailto:rwagner@bawplastics .com>

www.bawplastics. com<http://www.bawplastics.com/>

[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]
7
Right, so you would have to check Number02 first when Number01 changes and send the email if required. Then you would set Number02 equal to Number01. So if you look at Number01 and Number02 they should always be the same, its only that brief moment when Number 01 changes and your first BAM is triggered that they are different. The trigger would always be Number01.




________________________________
From: RICH WAGNER <rwagner@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thursday, September 17, 2009 9:08:07 AM
Subject: RE: [Vantage] BAM Alert

Â
We are on 6.1 so a BPM is not an option right now. Do you mean I would write the old value to JobOper.Number02 and the new value would be in JobOper.Number01?

Thanks,

Rich Wagner

412-384-3100

rwagner@bawplastics .com<mailto:rwagner@bawplastics .com>

www..bawplastics. com<http://www.bawplastics.com/>

____________ _________ _________ __
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Steven Gotschall
Sent: Thursday, September 17, 2009 8:50 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAM Alert

You could do this with a BPM, but with a BAM I think you are going to have to have two BAMS. One would execute a .p procedure that would set JobOper.Number02 = JobOper.Number01 whenever Number01 changes. The other one would have to execute first and would send the email when JobOper.Number01 changes and JobOper.Number02 <> 0. The order here would be very important. I haven't tried it, but it should work.

____________ _________ _________ __
From: RICH WAGNER <rwagner@bawplastics .com<mailto:rwagner% 40bawplastics. com>>
To: "vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>" <vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>>
Sent: Thursday, September 17, 2009 8:25:46 AM
Subject: [Vantage] BAM Alert

I am trying to setup a BAM to send an email when a change occurs to the JobOper.Number01 field, but I only want to send the email when the original value was something other than 0.

Is this even possible?

Thanks,

Rich Wagner

[cid:image002. jpg@ 01CA3770. 74A86BE0]

412-384-3100

rwagner@bawplastics .com<mailto: rwagner@bawplast ics .com>

www.bawplastics. com<http://www.bawplast ics.com/>

[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]
8
Rich,
Use the Old.Table.Field format to compare (in your case
Old.JobOper.Number01>0).
You will have to execute this through a .p file, but there is a ton of
history in this very list about .p files and BAMs (not an insignificant
portion directly from me).
I don't work much with .p files anymore, but I still am writing progress
code in BPMs in 8.x, so I can offer more assistance if needed.
Aaron Hoyt

RICH WAGNER wrote:
>
>
> We are on 6.1 so a BPM is not an option right now. Do you mean I would
> write the old value to JobOper.Number02 and the new value would be in
> JobOper.Number01?
>
> Thanks,
>
> Rich Wagner
>
> 412-384-3100
>
> rwagner@...
> <mailto:rwagner%40bawplastics.com><mailto:rwagner@...
> <mailto:rwagner%40bawplastics.com>>
>
> www.bawplastics.com<http://www.bawplastics.com/
> <http://www.bawplastics.com/>>
>
> ________________________________
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>] On
> Behalf Of Steven Gotschall
> Sent: Thursday, September 17, 2009 8:50 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] BAM Alert
>
> You could do this with a BPM, but with a BAM I think you are going to
> have to have two BAMS. One would execute a .p procedure that would set
> JobOper.Number02 = JobOper.Number01 whenever Number01 changes. The
> other one would have to execute first and would send the email when
> JobOper.Number01 changes and JobOper.Number02 <> 0. The order here
> would be very important. I haven't tried it, but it should work.
>
> ________________________________
> From: RICH WAGNER <rwagner@...
> <mailto:rwagner%40bawplastics.com><mailto:rwagner%40bawplastics.com>>
> To: "vantage@yahoogroups.com
> <mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>"
> <vantage@yahoogroups.com
> <mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>>
> Sent: Thursday, September 17, 2009 8:25:46 AM
> Subject: [Vantage] BAM Alert
>
> I am trying to setup a BAM to send an email when a change occurs to
> the JobOper.Number01 field, but I only want to send the email when the
> original value was something other than 0.
>
> Is this even possible?
>
> Thanks,
>
> Rich Wagner
>
> [cid:image002.jpg@ 01CA3770. 74A86BE0]
>
> 412-384-3100
>
> rwagner@bawplastics .com<mailto:rwagner@bawplastics .com>
>
> www.bawplastics. com<http://www.bawplastics.com/
> <http://www.bawplastics.com/>>
>
> [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]
9
Steve, Rich,
I don't believe it's a trivial matter to change the value of a field in
6.1 using a BAM. In 8.x it's easy with a BPM.
I think you will have to use the Old.Table.Field my other posts tells about.
Aaron Hoyt
Vantage Plastics

Steven Gotschall wrote:
>
>
> Right, so you would have to check Number02 first when Number01 changes
> and send the email if required. Then you would set Number02 equal to
> Number01. So if you look at Number01 and Number02 they should always
> be the same, its only that brief moment when Number 01 changes and
> your first BAM is triggered that they are different. The trigger
> would always be Number01.
>
> ________________________________
> From: RICH WAGNER <rwagner@...
> <mailto:rwagner%40bawplastics.com>>
> To: "vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>"
> <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>>
> Sent: Thursday, September 17, 2009 9:08:07 AM
> Subject: RE: [Vantage] BAM Alert
>
>
> We are on 6.1 so a BPM is not an option right now. Do you mean I would
> write the old value to JobOper.Number02 and the new value would be in
> JobOper.Number01?
>
> Thanks,
>
> Rich Wagner
>
> 412-384-3100
>
> rwagner@bawplastics .com<mailto:rwagner@bawplastics .com>
>
> www..bawplastics. com<http://www.bawplastics.com/
> <http://www.bawplastics.com/>>
>
> ____________ _________ _________ __
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
> Behalf Of Steven Gotschall
> Sent: Thursday, September 17, 2009 8:50 AM
> To: vantage@yahoogroups .com
> Subject: Re: [Vantage] BAM Alert
>
> You could do this with a BPM, but with a BAM I think you are going to
> have to have two BAMS. One would execute a .p procedure that would set
> JobOper.Number02 = JobOper.Number01 whenever Number01 changes. The
> other one would have to execute first and would send the email when
> JobOper.Number01 changes and JobOper.Number02 <> 0. The order here
> would be very important. I haven't tried it, but it should work.
>
> ____________ _________ _________ __
> From: RICH WAGNER <rwagner@bawplastics .com<mailto:rwagner%
> 40bawplastics. com>>
> To: "vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>"
> <vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>>
> Sent: Thursday, September 17, 2009 8:25:46 AM
> Subject: [Vantage] BAM Alert
>
> I am trying to setup a BAM to send an email when a change occurs to
> the JobOper.Number01 field, but I only want to send the email when the
> original value was something other than 0.
>
> Is this even possible?
>
> Thanks,
>
> Rich Wagner
>
> [cid:image002. jpg@ 01CA3770. 74A86BE0]
>
> 412-384-3100
>
> rwagner@bawplastics .com<mailto: rwagner@bawplast ics .com>
>
> www.bawplastics. com<http://www.bawplast ics.com/>
>
> [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]
10
I didn't know anything about the old.table.field format. I would be interested in finding out more about it and if it is still a valid option in 8.03.4xx.




________________________________
From: Aaron Hoyt <aaron.hoyt@...>
To: vantage@yahoogroups.com
Sent: Thursday, September 17, 2009 9:33:17 AM
Subject: Re: [Vantage] BAM Alert

Â
Steve, Rich,
I don't believe it's a trivial matter to change the value of a field in
6.1 using a BAM. In 8.x it's easy with a BPM.
I think you will have to use the Old.Table.Field my other posts tells about.
Aaron Hoyt
Vantage Plastics

Steven Gotschall wrote:
>
>
> Right, so you would have to check Number02 first when Number01 changes
> and send the email if required. Then you would set Number02 equal to
> Number01. So if you look at Number01 and Number02 they should always
> be the same, its only that brief moment when Number 01 changes and
> your first BAM is triggered that they are different. The trigger
> would always be Number01.
>
> ____________ _________ _________ __
> From: RICH WAGNER <rwagner@bawplastics .com
> <mailto:rwagner% 40bawplastics. com>>
> To: "vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>"
> <vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>>
> Sent: Thursday, September 17, 2009 9:08:07 AM
> Subject: RE: [Vantage] BAM Alert
>
>
> We are on 6.1 so a BPM is not an option right now. Do you mean I would
> write the old value to JobOper.Number02 and the new value would be in
> JobOper.Number01?
>
> Thanks,
>
> Rich Wagner
>
> 412-384-3100
>
> rwagner@bawplastics .com<mailto: rwagner@bawplast ics .com>
>
> www..bawplastics. com<http://www.bawplastics.com/
> <http://www.bawplast ics.com/>>
>
> ____________ _________ _________ __
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
> Behalf Of Steven Gotschall
> Sent: Thursday, September 17, 2009 8:50 AM
> To: vantage@yahoogroups .com
> Subject: Re: [Vantage] BAM Alert
>
> You could do this with a BPM, but with a BAM I think you are going to
> have to have two BAMS. One would execute a .p procedure that would set
> JobOper.Number02 = JobOper.Number01 whenever Number01 changes. The
> other one would have to execute first and would send the email when
> JobOper.Number01 changes and JobOper.Number02 <> 0. The order here
> would be very important. I haven't tried it, but it should work.
>
> ____________ _________ _________ __
> From: RICH WAGNER <rwagner@bawplastic s .com<mailto: rwagner%
> 40bawplastics. com>>
> To: "vantage@yahoogroup s .com<mailto: vantage% 40yahoogroups. com>"
> <vantage@yahoogroup s .com<mailto: vantage% 40yahoogroups. com>>
> Sent: Thursday, September 17, 2009 8:25:46 AM
> Subject: [Vantage] BAM Alert
>
> I am trying to setup a BAM to send an email when a change occurs to
> the JobOper.Number01 field, but I only want to send the email when the
> original value was something other than 0.
>
> Is this even possible?
>
> Thanks,
>
> Rich Wagner
>
> [cid:image002. jpg@ 01CA3770. 74A86BE0]
>
> 412-384-3100
>
> rwagner@bawplastics .com<mailto: rwagner@bawplast ics .com>
>
> www.bawplastics. com<http://www.bawplast ics.com/>
>
> [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]







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