BAQ question Blank Title 103490

> > How do you add a table more than once in a BAQ?
> We are on 9.04.507
> its no longer in the left pane.

I'm using 9.04.506.
PODetail is still in the LH pane after I add it in Phrase Build diagram view.
Then I can add PODetail again as an alias.


Sorry, I don't have any ideas why it isn't available in your BAQ.


--- In vantage@yahoogroups.com, "Mike Tonoyan" <mtonoyan@...> wrote:
>
> We are on 9.04.507
>
>
>
> Mike Tonoyan / Natel Engr.
>
> mtonoyan@...
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of cooner_55421
> Sent: Monday, August 29, 2011 1:33 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ question
>
>
>
>
>
> > How do you add a table more than once in a BAQ?
> I assume you are in V8?
> I have never found a way in V8.
> I think you can only do this in E9.
> Maybe somebody else can verify?
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "c.krusen1" <ckrusen1@> wrote:
> >
> > > Should I upload the BAQ and Dashboard definitions to the
> > > Files folder?"
> >
> > It wouldn't hurt.
> >
> > How do you add a table more than once in a BAQ? As soon as I add it,
> its no longer in the left pane.
> >
> > Calvin
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Mike Tonoyan" <mtonoyan@> wrote:
> > >
> > > When you add the same table twice the second one is created as an
> alias.
> > > Instead of PODetail it is created as PODetail1. I have linked part
> > > numbers so PODetail1 table will pull past PO Detail records for the
> > > those parts.
> > >
> > > I have created a dashboard for our QA team to easily recognize the
> > > current Pending Purchase Orders which have part revision changes
> from
> > > the last time they had been ordered. I added View Rules so if the
> > > current revision is not the same as ordered previous times then the
> PO
> > > number cells turn into yellow and the PartRev cells turn to red.
> It's a
> > > very useful dashboard except it shows not only the last PO but every
> PO
> > > before that. I am afraid with time the number of previous PO's are
> going
> > > to grow so big that the dashboard will become useless.
> > >
> > > Should I upload the BAQ and Dashboard definitions to the Files
> folder?
> > >
> > >
> > >
> > > Mike Tonoyan / Natel Engr.
> > >
> > > mtonoyan@
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > > Of c.krusen1
> > > Sent: Monday, August 29, 2011 12:29 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: BAQ question
> > >
> > >
> > >
> > >
> > >
> > > I'm not familiar with an "alias" table. What is the purpose of the
> alias
> > > table, and are you trying to get out?
> > >
> > > Calvin
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > > "Mike Tonoyan" <mtonoyan@> wrote:
> > > >
> > > > In a BAQ I have PODetail table connected PODetail1 (alias) table
> where
> > > > PODetail.Partnum = PODetail1.Partnum. I also have POHead table
> linked
> > > to
> > > > PODetail and POHead1 (alias) linked to PODetail1 (alias) table.
> With
> > > > this the BAQ is pulling all previous PO's. How can I pull only the
> > > very
> > > > last PO purchased for that part?
> > > >
> > > > Mike Tonoyan / Natel Engr.
> > > > mtonoyan@
> > > >
> > > > __________________________________________________________
> > > > Notice: This email transmission may contain confidential
> information
> > > and is intended only for the person(s) named. Any use, copying or
> > > disclosure to/by any other person(s) is strictly prohibited. By
> > > accepting this information, recipients confirm that they understand
> and
> > > will comply with all applicable ITAR and EAR requirements.
> > > > __________________________________________________________
> > > >
> > >
> > >
> > >
> > >
> > > __________________________________________________________
> > > Notice: This email transmission may contain confidential information
> and is intended only for the person(s) named. Any use, copying or
> disclosure to/by any other person(s) is strictly prohibited. By
> accepting this information, recipients confirm that they understand and
> will comply with all applicable ITAR and EAR requirements.
> > > __________________________________________________________
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
> ______________________________________________________________________
> Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
> ______________________________________________________________________
>
> [Non-text portions of this message have been removed]
>
Hello,



I'm trying to control who can change the sales rep on a customer using a
BPM.

I think I have everything mapped out but what I want to happen is if the
user changes 4 fields, of which one is the sales rep, I like to allow
the other 3 fields to be saved but just revert the sales rep back to the
value before they changed it. Then I could alert the user that the
change was rejected.



How do I retrieve the original value so that I can overwrite the changed
value?










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
Make a BPM on update that copies the selected sales rep to say Char1

On the Same BPM (check if User Changed that value by comparing the two, if
it did copy char 1 back to sales rep)
Otehrwise just Update Char1 to match the new oen.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Tue, Aug 23, 2011 at 3:17 PM, Joe Rojas <jrojas@...> wrote:

> **
>
>
> Hello,
>
> I'm trying to control who can change the sales rep on a customer using a
> BPM.
>
> I think I have everything mapped out but what I want to happen is if the
> user changes 4 fields, of which one is the sales rep, I like to allow
> the other 3 fields to be saved but just revert the sales rep back to the
> value before they changed it. Then I could alert the user that the
> change was rejected.
>
> How do I retrieve the original value so that I can overwrite the changed
> value?
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and
> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not the
> named addressee you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received this
> e-mail by mistake. Please note that any views or opinions presented in this
> email are solely those of the author and do not necessarily represent those
> of the company.
>
> [Non-text portions of this message have been removed]
>
>
>


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

While I was waiting for a response, I thought I heard that on updates,
the temp tables have two rows, the original row and the updated row.
I tried reading the value from the row where RowMod = "" but it didn't
seem to work.
Does this sound familiar?












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



-----Original Message-----

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Tuesday, August 23, 2011 3:48 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM: Prevent change on one field but allow the
update to complete

Make a BPM on update that copies the selected sales rep to say Char1

On the Same BPM (check if User Changed that value by comparing the two,
if it did copy char 1 back to sales rep) Otehrwise just Update Char1 to
match the new oen.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Tue, Aug 23, 2011 at 3:17 PM, Joe Rojas <jrojas@...> wrote:

> **
>
>
> Hello,
>
> I'm trying to control who can change the sales rep on a customer using

> a BPM.
>
> I think I have everything mapped out but what I want to happen is if
> the user changes 4 fields, of which one is the sales rep, I like to
> allow the other 3 fields to be saved but just revert the sales rep
> back to the value before they changed it. Then I could alert the user
> that the change was rejected.
>
> How do I retrieve the original value so that I can overwrite the
> changed value?
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and

> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not

> the named addressee you should not disseminate, distribute or copy
this e-mail.
> Please notify the sender immediately by e-mail if you have received
> this e-mail by mistake. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of the company.
>
> [Non-text portions of this message have been removed]
>
>
>


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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
No as far as I know there is only one Temp Row per Record. never heard that
before.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Tue, Aug 23, 2011 at 4:03 PM, Joe Rojas <jrojas@...> wrote:

> **
>
>
> Thanks Jose,
>
> While I was waiting for a response, I thought I heard that on updates,
> the temp tables have two rows, the original row and the updated row.
> I tried reading the value from the row where RowMod = "" but it didn't
> seem to work.
> Does this sound familiar?
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and
> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not the
> named addressee you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received this
> e-mail by mistake. Please note that any views or opinions presented in this
> email are solely those of the author and do not necessarily represent those
> of the company.
>
> -----Original Message-----
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Tuesday, August 23, 2011 3:48 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] BPM: Prevent change on one field but allow the
> update to complete
>
>
> Make a BPM on update that copies the selected sales rep to say Char1
>
> On the Same BPM (check if User Changed that value by comparing the two,
> if it did copy char 1 back to sales rep) Otehrwise just Update Char1 to
> match the new oen.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
>
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez>
> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
>
> *Quis custodiet ipsos custodes?*
>
> On Tue, Aug 23, 2011 at 3:17 PM, Joe Rojas <jrojas@...> wrote:
>
> > **
> >
> >
> > Hello,
> >
> > I'm trying to control who can change the sales rep on a customer using
>
> > a BPM.
> >
> > I think I have everything mapped out but what I want to happen is if
> > the user changes 4 fields, of which one is the sales rep, I like to
> > allow the other 3 fields to be saved but just revert the sales rep
> > back to the value before they changed it. Then I could alert the user
> > that the change was rejected.
> >
> > How do I retrieve the original value so that I can overwrite the
> > changed value?
> >
> >
> >
> >
> >
> >
> >
> > Joe Rojas | Director of Information Technology | Mats Inc
> > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > jrojas@... | www.matsinc.com Ask us about our clean, green and
>
> > beautiful matting and flooring
> >
> > This message is intended only for the individual named. If you are not
>
> > the named addressee you should not disseminate, distribute or copy
> this e-mail.
> > Please notify the sender immediately by e-mail if you have received
> > this e-mail by mistake. Please note that any views or opinions
> > presented in this email are solely those of the author and do not
> > necessarily represent those of the company.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>


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

That sounds familiar to me too. I had a look around at the information I have accumulated regarding BPMs, but I can't find it.

Linda

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joe Rojas
Sent: Tuesday, August 23, 2011 4:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM: Prevent change on one field but allow the update to complete



Thanks Jose,

While I was waiting for a response, I thought I heard that on updates,
the temp tables have two rows, the original row and the updated row.
I tried reading the value from the row where RowMod = "" but it didn't
seem to work.
Does this sound familiar?

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@...<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

-----Original Message-----

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Jose Gomez
Sent: Tuesday, August 23, 2011 3:48 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] BPM: Prevent change on one field but allow the
update to complete

Make a BPM on update that copies the selected sales rep to say Char1

On the Same BPM (check if User Changed that value by comparing the two,
if it did copy char 1 back to sales rep) Otehrwise just Update Char1 to
match the new oen.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...<mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Tue, Aug 23, 2011 at 3:17 PM, Joe Rojas <jrojas@...<mailto:jrojas%40matsinc.com>> wrote:

> **
>
>
> Hello,
>
> I'm trying to control who can change the sales rep on a customer using

> a BPM.
>
> I think I have everything mapped out but what I want to happen is if
> the user changes 4 fields, of which one is the sales rep, I like to
> allow the other 3 fields to be saved but just revert the sales rep
> back to the value before they changed it. Then I could alert the user
> that the change was rejected.
>
> How do I retrieve the original value so that I can overwrite the
> changed value?
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@...<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean, green and

> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not

> the named addressee you should not disseminate, distribute or copy
this e-mail.
> Please notify the sender immediately by e-mail if you have received
> this e-mail by mistake. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of the company.
>
> [Non-text portions of this message have been removed]
>
>
>

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



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

The function you want in your BPM is the buffer compare. Following is an explaination and example that I've used on Part to do what you're trying to do on Customer. You'd use this on the Customer.Update Pre-Process BO.Method.

BUFFER-COMPARE statement
Performs a bulk comparison of two records (source and target) by comparing source and target fields of the same name for equality and storing the result in a field. You can specify a list of fields to exclude, or a list of fields to include. You can also specify WHEN...THEN phrases. For all such phrases you specify, the AVM evaluates the WHEN portion, and if it evaluates to TRUE, the AVM executes the THEN portion.

Syntax

BUFFER-COMPARE source [ { EXCEPT | USING } field ... ] TO target [ CASE-SENSITIVE | BINARY ] [ SAVE [ RESULT IN ] result-field ] [ [ EXPLICIT ] COMPARES ]: [ WHEN field compare-operator expression THEN statement-or-block ] ... [ END [ COMPARES ] ] [ NO-LOBS ] [ NO-ERROR ]

Example

define variable differences as logical no-undo.

Set differences = Yes.

For each ttPart, each Part where ttPart.Company = Part.Company and ttPart.PartNum = Part.PartNum no-lock.

buffer-compare ttPart Except ttPart.PurComment ttPart.MfgComment to Part save result in differences.

/*I hard coded in a handful of users here but could you could easily use a UD checkbox on UserFile to control this as well...*/
If /*Add your user test condition here*/ and differences = No then do:

{lib\PublishEx.i &ExMsg = "'You are not authorized to update parts, ' + DCD-UserID"}
{&THROW_PUBLIC}.

End.

End.

If this give you trouble, let me know. I should be able to walk you through what you're trying to do in less than 30 min.

NB

--- In vantage@yahoogroups.com, Linda Lowney <llowney@...> wrote:
>
> Hi Joe,
>
> That sounds familiar to me too. I had a look around at the information I have accumulated regarding BPMs, but I can't find it.
>
> Linda
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joe Rojas
> Sent: Tuesday, August 23, 2011 4:03 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] BPM: Prevent change on one field but allow the update to complete
>
>
>
> Thanks Jose,
>
> While I was waiting for a response, I thought I heard that on updates,
> the temp tables have two rows, the original row and the updated row.
> I tried reading the value from the row where RowMod = "" but it didn't
> seem to work.
> Does this sound familiar?
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@...<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
>
> -----Original Message-----
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
> Of Jose Gomez
> Sent: Tuesday, August 23, 2011 3:48 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] BPM: Prevent change on one field but allow the
> update to complete
>
> Make a BPM on update that copies the selected sales rep to say Char1
>
> On the Same BPM (check if User Changed that value by comparing the two,
> if it did copy char 1 back to sales rep) Otehrwise just Update Char1 to
> match the new oen.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...<mailto:jose%40josecgomez.com>
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez>
> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
> On Tue, Aug 23, 2011 at 3:17 PM, Joe Rojas <jrojas@...<mailto:jrojas%40matsinc.com>> wrote:
>
> > **
> >
> >
> > Hello,
> >
> > I'm trying to control who can change the sales rep on a customer using
>
> > a BPM.
> >
> > I think I have everything mapped out but what I want to happen is if
> > the user changes 4 fields, of which one is the sales rep, I like to
> > allow the other 3 fields to be saved but just revert the sales rep
> > back to the value before they changed it. Then I could alert the user
> > that the change was rejected.
> >
> > How do I retrieve the original value so that I can overwrite the
> > changed value?
> >
> >
> >
> >
> >
> >
> >
> > Joe Rojas | Director of Information Technology | Mats Inc
> > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > jrojas@...<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean, green and
>
> > beautiful matting and flooring
> >
> > This message is intended only for the individual named. If you are not
>
> > the named addressee you should not disseminate, distribute or copy
> this e-mail.
> > Please notify the sender immediately by e-mail if you have received
> > this e-mail by mistake. Please note that any views or opinions
> > presented in this email are solely those of the author and do not
> > necessarily represent those of the company.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>
Do you have to use a BPM? How about a screen customization that just
makes the sales rep field read only for certain users?

Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Tuesday, August 23, 2011 3:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM: Prevent change on one field but allow the update
to complete





Hello,

I'm trying to control who can change the sales rep on a customer using a
BPM.

I think I have everything mapped out but what I want to happen is if the
user changes 4 fields, of which one is the sales rep, I like to allow
the other 3 fields to be saved but just revert the sales rep back to the
value before they changed it. Then I could alert the user that the
change was rejected.

How do I retrieve the original value so that I can overwrite the changed
value?







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.

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





[Non-text portions of this message have been removed]
It turns out that there are two rows.

One where RowMod is blank and the other where RowMod is U.

The row where RowMod is blank contains the original values.



I didn't get the results I wanted when I used RowMod = ""

But when I used, RowMod <> "U", I was able to see the other row.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Nathan
Sent: Tuesday, August 23, 2011 5:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM: Prevent change on one field but allow the
update to complete





Joe,

The function you want in your BPM is the buffer compare. Following is an
explaination and example that I've used on Part to do what you're trying
to do on Customer. You'd use this on the Customer.Update Pre-Process
BO.Method.

BUFFER-COMPARE statement
Performs a bulk comparison of two records (source and target) by
comparing source and target fields of the same name for equality and
storing the result in a field. You can specify a list of fields to
exclude, or a list of fields to include. You can also specify
WHEN...THEN phrases. For all such phrases you specify, the AVM evaluates
the WHEN portion, and if it evaluates to TRUE, the AVM executes the THEN
portion.

Syntax

BUFFER-COMPARE source [ { EXCEPT | USING } field ... ] TO target [
CASE-SENSITIVE | BINARY ] [ SAVE [ RESULT IN ] result-field ] [ [
EXPLICIT ] COMPARES ]: [ WHEN field compare-operator expression THEN
statement-or-block ] ... [ END [ COMPARES ] ] [ NO-LOBS ] [ NO-ERROR ]

Example

define variable differences as logical no-undo.

Set differences = Yes.

For each ttPart, each Part where ttPart.Company = Part.Company and
ttPart.PartNum = Part.PartNum no-lock.

buffer-compare ttPart Except ttPart.PurComment ttPart.MfgComment to Part
save result in differences.

/*I hard coded in a handful of users here but could you could easily use
a UD checkbox on UserFile to control this as well...*/
If /*Add your user test condition here*/ and differences = No then do:

{lib\PublishEx.i &ExMsg = "'You are not authorized to update parts, ' +
DCD-UserID"}
{&THROW_PUBLIC}.

End.

End.

If this give you trouble, let me know. I should be able to walk you
through what you're trying to do in less than 30 min.

NB

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
Linda Lowney <llowney@...> wrote:
>
> Hi Joe,
>
> That sounds familiar to me too. I had a look around at the information
I have accumulated regarding BPMs, but I can't find it.
>
> Linda
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Joe Rojas
> Sent: Tuesday, August 23, 2011 4:03 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] BPM: Prevent change on one field but allow the
update to complete
>
>
>
> Thanks Jose,
>
> While I was waiting for a response, I thought I heard that on updates,
> the temp tables have two rows, the original row and the updated row.
> I tried reading the value from the row where RowMod = "" but it didn't
> seem to work.
> Does this sound familiar?
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@...<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about
our clean, green and beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.
>
>










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



-----Original Message-----

>
> 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 Jose Gomez
> Sent: Tuesday, August 23, 2011 3:48 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] BPM: Prevent change on one field but allow the
> update to complete
>
> Make a BPM on update that copies the selected sales rep to say Char1
>
> On the Same BPM (check if User Changed that value by comparing the
two,
> if it did copy char 1 back to sales rep) Otehrwise just Update Char1
to
> match the new oen.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...<mailto:jose%40josecgomez.com>
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez>
> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
> On Tue, Aug 23, 2011 at 3:17 PM, Joe Rojas
<jrojas@...<mailto:jrojas%40matsinc.com>> wrote:
>
> > **
> >
> >
> > Hello,
> >
> > I'm trying to control who can change the sales rep on a customer
using
>
> > a BPM.
> >
> > I think I have everything mapped out but what I want to happen is if
> > the user changes 4 fields, of which one is the sales rep, I like to
> > allow the other 3 fields to be saved but just revert the sales rep
> > back to the value before they changed it. Then I could alert the
user
> > that the change was rejected.
> >
> > How do I retrieve the original value so that I can overwrite the
> > changed value?
> >
> >
> >
> >
> >
> >
> >
> > Joe Rojas | Director of Information Technology | Mats Inc
> > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > jrojas@...<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us
about our clean, green and
>
> > beautiful matting and flooring
> >
> > This message is intended only for the individual named. If you are
not
>
> > the named addressee you should not disseminate, distribute or copy
> this e-mail.
> > Please notify the sender immediately by e-mail if you have received
> > this e-mail by mistake. Please note that any views or opinions
> > presented in this email are solely those of the author and do not
> > necessarily represent those of the company.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access.
)
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/> <
http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>




[Non-text portions of this message have been removed]
Here is some code I use to not allow users to push out a task due date with out comments. You should be able to modify this for any table.

Tom

DEFINE BUFFER oldRecord FOR ttTask.

{&TRY_PUBLIC}


FOR EACH ttTask WHERE
ttTask.RowMod = 'U':U NO-LOCK:

FIND FIRST oldRecord WHERE oldRecord.RowMod EQ "":U
AND oldRecord.RowIdent EQ ttTask.RowIdent NO-ERROR.
IF AVAILABLE(oldRecord) THEN DO:


IF oldRecord.DueDate LT ttTask.DueDate
AND ttTask.TaskComment EQ ''
THEN DO:
{lib/PublishEx.i &ExTable = 'Task':U
&ExField = 'DueDate':U
&ExMsg = "'You can not push out the due date without entering comments for the Task. Please fill in the comments for this Task.'":U}
{&THROW_PUBLIC}.
END.
END.

--- In vantage@yahoogroups.com, Joe Rojas <jrojas@...> wrote:
>
> It turns out that there are two rows.
>
> One where RowMod is blank and the other where RowMod is U.
>
> The row where RowMod is blank contains the original values.
>
>
>
> I didn't get the results I wanted when I used RowMod = ""
>
> But when I used, RowMod <> "U", I was able to see the other row.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Nathan
> Sent: Tuesday, August 23, 2011 5:20 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BPM: Prevent change on one field but allow the
> update to complete
>
>
>
>
>
> Joe,
>
> The function you want in your BPM is the buffer compare. Following is an
> explaination and example that I've used on Part to do what you're trying
> to do on Customer. You'd use this on the Customer.Update Pre-Process
> BO.Method.
>
> BUFFER-COMPARE statement
> Performs a bulk comparison of two records (source and target) by
> comparing source and target fields of the same name for equality and
> storing the result in a field. You can specify a list of fields to
> exclude, or a list of fields to include. You can also specify
> WHEN...THEN phrases. For all such phrases you specify, the AVM evaluates
> the WHEN portion, and if it evaluates to TRUE, the AVM executes the THEN
> portion.
>
> Syntax
>
> BUFFER-COMPARE source [ { EXCEPT | USING } field ... ] TO target [
> CASE-SENSITIVE | BINARY ] [ SAVE [ RESULT IN ] result-field ] [ [
> EXPLICIT ] COMPARES ]: [ WHEN field compare-operator expression THEN
> statement-or-block ] ... [ END [ COMPARES ] ] [ NO-LOBS ] [ NO-ERROR ]
>
> Example
>
> define variable differences as logical no-undo.
>
> Set differences = Yes.
>
> For each ttPart, each Part where ttPart.Company = Part.Company and
> ttPart.PartNum = Part.PartNum no-lock.
>
> buffer-compare ttPart Except ttPart.PurComment ttPart.MfgComment to Part
> save result in differences.
>
> /*I hard coded in a handful of users here but could you could easily use
> a UD checkbox on UserFile to control this as well...*/
> If /*Add your user test condition here*/ and differences = No then do:
>
> {lib\PublishEx.i &ExMsg = "'You are not authorized to update parts, ' +
> DCD-UserID"}
> {&THROW_PUBLIC}.
>
> End.
>
> End.
>
> If this give you trouble, let me know. I should be able to walk you
> through what you're trying to do in less than 30 min.
>
> NB
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> Linda Lowney <llowney@> wrote:
> >
> > Hi Joe,
> >
> > That sounds familiar to me too. I had a look around at the information
> I have accumulated regarding BPMs, but I can't find it.
> >
> > Linda
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of Joe Rojas
> > Sent: Tuesday, August 23, 2011 4:03 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] BPM: Prevent change on one field but allow the
> update to complete
> >
> >
> >
> > Thanks Jose,
> >
> > While I was waiting for a response, I thought I heard that on updates,
> > the temp tables have two rows, the original row and the updated row.
> > I tried reading the value from the row where RowMod = "" but it didn't
> > seem to work.
> > Does this sound familiar?
> >
> > Joe Rojas | Director of Information Technology | Mats Inc
> > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > jrojas@<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about
> our clean, green and beautiful matting and flooring
> >
> > This message is intended only for the individual named. If you are not
> the named addressee you should not disseminate, distribute or copy this
> e-mail. Please notify the sender immediately by e-mail if you have
> received this e-mail by mistake. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of the company.
> >
> >
>
>
>
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
>
>
> This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
>
>
>
> -----Original Message-----
>
> >
> > 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 Jose Gomez
> > Sent: Tuesday, August 23, 2011 3:48 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > Subject: Re: [Vantage] BPM: Prevent change on one field but allow the
> > update to complete
> >
> > Make a BPM on update that copies the selected sales rep to say Char1
> >
> > On the Same BPM (check if User Changed that value by comparing the
> two,
> > if it did copy char 1 back to sales rep) Otehrwise just Update Char1
> to
> > match the new oen.
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *checkout my new blog <http://www.usdoingstuff.com> *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@<mailto:jose%40josecgomez.com>
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez>
> > <http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez>
> > <http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> > On Tue, Aug 23, 2011 at 3:17 PM, Joe Rojas
> <jrojas@<mailto:jrojas%40matsinc.com>> wrote:
> >
> > > **
> > >
> > >
> > > Hello,
> > >
> > > I'm trying to control who can change the sales rep on a customer
> using
> >
> > > a BPM.
> > >
> > > I think I have everything mapped out but what I want to happen is if
> > > the user changes 4 fields, of which one is the sales rep, I like to
> > > allow the other 3 fields to be saved but just revert the sales rep
> > > back to the value before they changed it. Then I could alert the
> user
> > > that the change was rejected.
> > >
> > > How do I retrieve the original value so that I can overwrite the
> > > changed value?
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Joe Rojas | Director of Information Technology | Mats Inc
> > > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > > jrojas@<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us
> about our clean, green and
> >
> > > beautiful matting and flooring
> > >
> > > This message is intended only for the individual named. If you are
> not
> >
> > > the named addressee you should not disseminate, distribute or copy
> > this e-mail.
> > > Please notify the sender immediately by e-mail if you have received
> > > this e-mail by mistake. Please note that any views or opinions
> > > presented in this email are solely those of the author and do not
> > > necessarily represent those of the company.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have already linked your email address to a yahoo id to enable access.
> )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/> <
> http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
I thought of doing that but the other requirement was to allow the user
to set the sale rep when a new order was created but then prevent
changes after the order was saved.



Because BPMs have an easy way to distinguish between new rows and
changes rows, I started down the BPM path.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian Roberts
Sent: Wednesday, August 24, 2011 9:31 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM: Prevent change on one field but allow the
update to complete





Do you have to use a BPM? How about a screen customization that just
makes the sales rep field read only for certain users?

Brian.












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



________________________________


From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Tuesday, August 23, 2011 3:17 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BPM: Prevent change on one field but allow the update
to complete

Hello,

I'm trying to control who can change the sales rep on a customer using a
BPM.

I think I have everything mapped out but what I want to happen is if the
user changes 4 fields, of which one is the sales rep, I like to allow
the other 3 fields to be saved but just revert the sales rep back to the
value before they changed it. Then I could alert the user that the
change was rejected.

How do I retrieve the original value so that I can overwrite the changed
value?

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.

[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]
This is strange. What I stated below is not consistent.

I created two, almost identical, pre-processing directives and one had
access to two rows and the other only have access to the updated row.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Wednesday, August 24, 2011 9:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: BPM: Prevent change on one field but allow
the update to complete





It turns out that there are two rows.

One where RowMod is blank and the other where RowMod is U.

The row where RowMod is blank contains the original values.

I didn't get the results I wanted when I used RowMod = ""

But when I used, RowMod <> "U", I was able to see the other row.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Nathan
Sent: Tuesday, August 23, 2011 5:20 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: BPM: Prevent change on one field but allow the
update to complete

Joe,

The function you want in your BPM is the buffer compare. Following is an
explaination and example that I've used on Part to do what you're trying
to do on Customer. You'd use this on the Customer.Update Pre-Process
BO.Method.

BUFFER-COMPARE statement
Performs a bulk comparison of two records (source and target) by
comparing source and target fields of the same name for equality and
storing the result in a field. You can specify a list of fields to
exclude, or a list of fields to include. You can also specify
WHEN...THEN phrases. For all such phrases you specify, the AVM evaluates
the WHEN portion, and if it evaluates to TRUE, the AVM executes the THEN
portion.

Syntax

BUFFER-COMPARE source [ { EXCEPT | USING } field ... ] TO target [
CASE-SENSITIVE | BINARY ] [ SAVE [ RESULT IN ] result-field ] [ [
EXPLICIT ] COMPARES ]: [ WHEN field compare-operator expression THEN
statement-or-block ] ... [ END [ COMPARES ] ] [ NO-LOBS ] [ NO-ERROR ]

Example

define variable differences as logical no-undo.

Set differences = Yes.

For each ttPart, each Part where ttPart.Company = Part.Company and
ttPart.PartNum = Part.PartNum no-lock.

buffer-compare ttPart Except ttPart.PurComment ttPart.MfgComment to Part
save result in differences.

/*I hard coded in a handful of users here but could you could easily use
a UD checkbox on UserFile to control this as well...*/
If /*Add your user test condition here*/ and differences = No then do:

{lib\PublishEx.i &ExMsg = "'You are not authorized to update parts, ' +
DCD-UserID"}
{&THROW_PUBLIC}.

End.

End.

If this give you trouble, let me know. I should be able to walk you
through what you're trying to do in less than 30 min.

NB

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
Linda Lowney <llowney@...> wrote:
>
> Hi Joe,
>
> That sounds familiar to me too. I had a look around at the information
I have accumulated regarding BPMs, but I can't find it.
>
> Linda
>
> 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 Joe Rojas
> Sent: Tuesday, August 23, 2011 4:03 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] BPM: Prevent change on one field but allow the
update to complete
>
>
>
> Thanks Jose,
>
> While I was waiting for a response, I thought I heard that on updates,
> the temp tables have two rows, the original row and the updated row.
> I tried reading the value from the row where RowMod = "" but it didn't
> seem to work.
> Does this sound familiar?
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@...<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about
our clean, green and beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.
>
>







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



-----Original Message-----


>
> 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 Jose Gomez
> Sent: Tuesday, August 23, 2011 3:48 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] BPM: Prevent change on one field but allow the
> update to complete
>
> Make a BPM on update that copies the selected sales rep to say Char1
>
> On the Same BPM (check if User Changed that value by comparing the
two,
> if it did copy char 1 back to sales rep) Otehrwise just Update Char1
to
> match the new oen.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...<mailto:jose%40josecgomez.com>
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez>
> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
> On Tue, Aug 23, 2011 at 3:17 PM, Joe Rojas
<jrojas@...<mailto:jrojas%40matsinc.com>> wrote:
>
> > **
> >
> >
> > Hello,
> >
> > I'm trying to control who can change the sales rep on a customer
using
>
> > a BPM.
> >
> > I think I have everything mapped out but what I want to happen is if
> > the user changes 4 fields, of which one is the sales rep, I like to
> > allow the other 3 fields to be saved but just revert the sales rep
> > back to the value before they changed it. Then I could alert the
user
> > that the change was rejected.
> >
> > How do I retrieve the original value so that I can overwrite the
> > changed value?
> >
> >
> >
> >
> >
> >
> >
> > Joe Rojas | Director of Information Technology | Mats Inc
> > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > jrojas@...<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us
about our clean, green and
>
> > beautiful matting and flooring
> >
> > This message is intended only for the individual named. If you are
not
>
> > the named addressee you should not disseminate, distribute or copy
> this e-mail.
> > Please notify the sender immediately by e-mail if you have received
> > this e-mail by mistake. Please note that any views or opinions
> > presented in this email are solely those of the author and do not
> > necessarily represent those of the company.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access.
)
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/> <
http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
> [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 a BAQ I have PODetail table connected PODetail1 (alias) table where
PODetail.Partnum = PODetail1.Partnum. I also have POHead table linked to
PODetail and POHead1 (alias) linked to PODetail1 (alias) table. With
this the BAQ is pulling all previous PO's. How can I pull only the very
last PO purchased for that part?

Mike Tonoyan / Natel Engr.
mtonoyan@...

______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________
I'm not familiar with an "alias" table. What is the purpose of the alias table, and are you trying to get out?

Calvin


--- In vantage@yahoogroups.com, "Mike Tonoyan" <mtonoyan@...> wrote:
>
> In a BAQ I have PODetail table connected PODetail1 (alias) table where
> PODetail.Partnum = PODetail1.Partnum. I also have POHead table linked to
> PODetail and POHead1 (alias) linked to PODetail1 (alias) table. With
> this the BAQ is pulling all previous PO's. How can I pull only the very
> last PO purchased for that part?
>
> Mike Tonoyan / Natel Engr.
> mtonoyan@...
>
> ______________________________________________________________________
> Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
> ______________________________________________________________________
>
When you add the same table twice the second one is created as an alias.
Instead of PODetail it is created as PODetail1. I have linked part
numbers so PODetail1 table will pull past PO Detail records for the
those parts.

I have created a dashboard for our QA team to easily recognize the
current Pending Purchase Orders which have part revision changes from
the last time they had been ordered. I added View Rules so if the
current revision is not the same as ordered previous times then the PO
number cells turn into yellow and the PartRev cells turn to red. It's a
very useful dashboard except it shows not only the last PO but every PO
before that. I am afraid with time the number of previous PO's are going
to grow so big that the dashboard will become useless.

Should I upload the BAQ and Dashboard definitions to the Files folder?



Mike Tonoyan / Natel Engr.

mtonoyan@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of c.krusen1
Sent: Monday, August 29, 2011 12:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ question





I'm not familiar with an "alias" table. What is the purpose of the alias
table, and are you trying to get out?

Calvin

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Mike Tonoyan" <mtonoyan@...> wrote:
>
> In a BAQ I have PODetail table connected PODetail1 (alias) table where
> PODetail.Partnum = PODetail1.Partnum. I also have POHead table linked
to
> PODetail and POHead1 (alias) linked to PODetail1 (alias) table. With
> this the BAQ is pulling all previous PO's. How can I pull only the
very
> last PO purchased for that part?
>
> Mike Tonoyan / Natel Engr.
> mtonoyan@...
>
> __________________________________________________________
> Notice: This email transmission may contain confidential information
and is intended only for the person(s) named. Any use, copying or
disclosure to/by any other person(s) is strictly prohibited. By
accepting this information, recipients confirm that they understand and
will comply with all applicable ITAR and EAR requirements.
> __________________________________________________________
>




______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

[Non-text portions of this message have been removed]
> Should I upload the BAQ and Dashboard definitions to the
> Files folder?"

It wouldn't hurt.

How do you add a table more than once in a BAQ? As soon as I add it, its no longer in the left pane.

Calvin


--- In vantage@yahoogroups.com, "Mike Tonoyan" <mtonoyan@...> wrote:
>
> When you add the same table twice the second one is created as an alias.
> Instead of PODetail it is created as PODetail1. I have linked part
> numbers so PODetail1 table will pull past PO Detail records for the
> those parts.
>
> I have created a dashboard for our QA team to easily recognize the
> current Pending Purchase Orders which have part revision changes from
> the last time they had been ordered. I added View Rules so if the
> current revision is not the same as ordered previous times then the PO
> number cells turn into yellow and the PartRev cells turn to red. It's a
> very useful dashboard except it shows not only the last PO but every PO
> before that. I am afraid with time the number of previous PO's are going
> to grow so big that the dashboard will become useless.
>
> Should I upload the BAQ and Dashboard definitions to the Files folder?
>
>
>
> Mike Tonoyan / Natel Engr.
>
> mtonoyan@...
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of c.krusen1
> Sent: Monday, August 29, 2011 12:29 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ question
>
>
>
>
>
> I'm not familiar with an "alias" table. What is the purpose of the alias
> table, and are you trying to get out?
>
> Calvin
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Mike Tonoyan" <mtonoyan@> wrote:
> >
> > In a BAQ I have PODetail table connected PODetail1 (alias) table where
> > PODetail.Partnum = PODetail1.Partnum. I also have POHead table linked
> to
> > PODetail and POHead1 (alias) linked to PODetail1 (alias) table. With
> > this the BAQ is pulling all previous PO's. How can I pull only the
> very
> > last PO purchased for that part?
> >
> > Mike Tonoyan / Natel Engr.
> > mtonoyan@
> >
> > __________________________________________________________
> > Notice: This email transmission may contain confidential information
> and is intended only for the person(s) named. Any use, copying or
> disclosure to/by any other person(s) is strictly prohibited. By
> accepting this information, recipients confirm that they understand and
> will comply with all applicable ITAR and EAR requirements.
> > __________________________________________________________
> >
>
>
>
>
> ______________________________________________________________________
> Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
> ______________________________________________________________________
>
> [Non-text portions of this message have been removed]
>
> How do you add a table more than once in a BAQ?
I assume you are in V8?
I have never found a way in V8.
I think you can only do this in E9.
Maybe somebody else can verify?

--- In vantage@yahoogroups.com, "c.krusen1" <ckrusen1@...> wrote:
>
> > Should I upload the BAQ and Dashboard definitions to the
> > Files folder?"
>
> It wouldn't hurt.
>
> How do you add a table more than once in a BAQ? As soon as I add it, its no longer in the left pane.
>
> Calvin
>
>
> --- In vantage@yahoogroups.com, "Mike Tonoyan" <mtonoyan@> wrote:
> >
> > When you add the same table twice the second one is created as an alias.
> > Instead of PODetail it is created as PODetail1. I have linked part
> > numbers so PODetail1 table will pull past PO Detail records for the
> > those parts.
> >
> > I have created a dashboard for our QA team to easily recognize the
> > current Pending Purchase Orders which have part revision changes from
> > the last time they had been ordered. I added View Rules so if the
> > current revision is not the same as ordered previous times then the PO
> > number cells turn into yellow and the PartRev cells turn to red. It's a
> > very useful dashboard except it shows not only the last PO but every PO
> > before that. I am afraid with time the number of previous PO's are going
> > to grow so big that the dashboard will become useless.
> >
> > Should I upload the BAQ and Dashboard definitions to the Files folder?
> >
> >
> >
> > Mike Tonoyan / Natel Engr.
> >
> > mtonoyan@
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of c.krusen1
> > Sent: Monday, August 29, 2011 12:29 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: BAQ question
> >
> >
> >
> >
> >
> > I'm not familiar with an "alias" table. What is the purpose of the alias
> > table, and are you trying to get out?
> >
> > Calvin
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Mike Tonoyan" <mtonoyan@> wrote:
> > >
> > > In a BAQ I have PODetail table connected PODetail1 (alias) table where
> > > PODetail.Partnum = PODetail1.Partnum. I also have POHead table linked
> > to
> > > PODetail and POHead1 (alias) linked to PODetail1 (alias) table. With
> > > this the BAQ is pulling all previous PO's. How can I pull only the
> > very
> > > last PO purchased for that part?
> > >
> > > Mike Tonoyan / Natel Engr.
> > > mtonoyan@
> > >
> > > __________________________________________________________
> > > Notice: This email transmission may contain confidential information
> > and is intended only for the person(s) named. Any use, copying or
> > disclosure to/by any other person(s) is strictly prohibited. By
> > accepting this information, recipients confirm that they understand and
> > will comply with all applicable ITAR and EAR requirements.
> > > __________________________________________________________
> > >
> >
> >
> >
> >
> > ______________________________________________________________________
> > Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
> > ______________________________________________________________________
> >
> > [Non-text portions of this message have been removed]
> >
>
We are on 9.04.507



Mike Tonoyan / Natel Engr.

mtonoyan@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of cooner_55421
Sent: Monday, August 29, 2011 1:33 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ question





> How do you add a table more than once in a BAQ?
I assume you are in V8?
I have never found a way in V8.
I think you can only do this in E9.
Maybe somebody else can verify?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"c.krusen1" <ckrusen1@...> wrote:
>
> > Should I upload the BAQ and Dashboard definitions to the
> > Files folder?"
>
> It wouldn't hurt.
>
> How do you add a table more than once in a BAQ? As soon as I add it,
its no longer in the left pane.
>
> Calvin
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Mike Tonoyan" <mtonoyan@> wrote:
> >
> > When you add the same table twice the second one is created as an
alias.
> > Instead of PODetail it is created as PODetail1. I have linked part
> > numbers so PODetail1 table will pull past PO Detail records for the
> > those parts.
> >
> > I have created a dashboard for our QA team to easily recognize the
> > current Pending Purchase Orders which have part revision changes
from
> > the last time they had been ordered. I added View Rules so if the
> > current revision is not the same as ordered previous times then the
PO
> > number cells turn into yellow and the PartRev cells turn to red.
It's a
> > very useful dashboard except it shows not only the last PO but every
PO
> > before that. I am afraid with time the number of previous PO's are
going
> > to grow so big that the dashboard will become useless.
> >
> > Should I upload the BAQ and Dashboard definitions to the Files
folder?
> >
> >
> >
> > Mike Tonoyan / Natel Engr.
> >
> > mtonoyan@
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> > Of c.krusen1
> > Sent: Monday, August 29, 2011 12:29 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: BAQ question
> >
> >
> >
> >
> >
> > I'm not familiar with an "alias" table. What is the purpose of the
alias
> > table, and are you trying to get out?
> >
> > Calvin
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> > "Mike Tonoyan" <mtonoyan@> wrote:
> > >
> > > In a BAQ I have PODetail table connected PODetail1 (alias) table
where
> > > PODetail.Partnum = PODetail1.Partnum. I also have POHead table
linked
> > to
> > > PODetail and POHead1 (alias) linked to PODetail1 (alias) table.
With
> > > this the BAQ is pulling all previous PO's. How can I pull only the
> > very
> > > last PO purchased for that part?
> > >
> > > Mike Tonoyan / Natel Engr.
> > > mtonoyan@
> > >
> > > __________________________________________________________
> > > Notice: This email transmission may contain confidential
information
> > and is intended only for the person(s) named. Any use, copying or
> > disclosure to/by any other person(s) is strictly prohibited. By
> > accepting this information, recipients confirm that they understand
and
> > will comply with all applicable ITAR and EAR requirements.
> > > __________________________________________________________
> > >
> >
> >
> >
> >
> > __________________________________________________________
> > Notice: This email transmission may contain confidential information
and is intended only for the person(s) named. Any use, copying or
disclosure to/by any other person(s) is strictly prohibited. By
accepting this information, recipients confirm that they understand and
will comply with all applicable ITAR and EAR requirements.
> > __________________________________________________________
> >
> > [Non-text portions of this message have been removed]
> >
>




______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

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