User ID used in a BPM

I was out on other projects for a bit, now back to Vantage. I think I'm going to try a different route with the user ID because I can't seem to get that to work, but I have a problem where it looks like a simple query won't work either. It would appear simple... If the RMA line in the RMA processing screen has a receipt when a change is saved, it should send me an email, if not, do nothing. But I can't see how to get this one to work correctly. I am trying this currently(and tried many combinations there of) :

for each ttrmadtl , each rmarcpt where (ttrmadtl.RMANum = rmarcpt.RMANum and ttrmadtl.RMALine =

rmarcpt.RMALine) and rmarcpt.RMAReceipt = 1 no-lock.

Basically, if the RMA number and RMA line of the RMA has a record in the rmarcpt table, it should send an email to me after a save. I've tried numerous different ways and nothing works. Currently, if I do it as a regular query in the Method Directive Conditions, it never sends anything out, if I go in and use the Advanced area, it always sends email out regardless if there is a receipt or not. I have other conditions I'm going to add to this later, but this is my base condition and I need this to work first. Like I said, I've tried 100 different ways and I can't get any working results, can anyone help?? I do appreciate any help offered!!!

Regards,

Kurt

--- In vantage@yahoogroups.com, Dan Godfrey <dgodfrey@...> wrote:
>
> Cany ou isolate the user into a security group. If so, then there is a condition for the user belonging to OR not belonging to a specific group.
>
>
> [Non-text portions of this message have been removed]
>
Hi all!

I'm trying to do a BPM for the RMA Processing screen. Basically, it is supposed to let only certain people make changes to the Reason Code after receipt. I think I have a portion of it figured out, but I can't seem to get the current user. Like 'If current user = "Fred" or current user = "John" then....' This would be after checking for the receipt (rmadtl = rmarcpt). But I can't get how to check the current user against specific names. I tried USERID and it does nothing, and I've seen somethings about DCD-USERID, but that just errors. I know there has to be something that is right in front of me, but I can't see it. Can anyone help on this? Thanks in advance for any help!

Regards,

Kurt
The variable is DCD-USERID. It should work.

What might be easer is to create a security group and then I think one
of the conditions on a BPM is to check that the user is part of a
security group.

That what you don't have to change your BPM as people come and go.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kurt
Sent: Wednesday, January 19, 2011 4:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] User ID used in a BPM





Hi all!

I'm trying to do a BPM for the RMA Processing screen. Basically, it is
supposed to let only certain people make changes to the Reason Code
after receipt. I think I have a portion of it figured out, but I can't
seem to get the current user. Like 'If current user = "Fred" or current
user = "John" then....' This would be after checking for the receipt
(rmadtl = rmarcpt). But I can't get how to check the current user
against specific names. I tried USERID and it does nothing, and I've
seen somethings about DCD-USERID, but that just errors. I know there has
to be something that is right in front of me, but I can't see it. Can
anyone help on this? Thanks in advance for any help!

Regards,

Kurt












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]
Ditto what Joe said - definitely do this as part of security groups. That
way, any security admin can change it and it doesn't require someone to dig
into BPM's. Also, if you have multiple BPM's that are affected, you only
have to make one change to the group instead of having to change multiple
BPMs.



Kevin Simon



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joe Rojas
Sent: Wednesday, January 19, 2011 4:41 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] User ID used in a BPM





The variable is DCD-USERID. It should work.

What might be easer is to create a security group and then I think one
of the conditions on a BPM is to check that the user is part of a
security group.

That what you don't have to change your BPM as people come and go.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Kurt
Sent: Wednesday, January 19, 2011 4:21 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] User ID used in a BPM

Hi all!

I'm trying to do a BPM for the RMA Processing screen. Basically, it is
supposed to let only certain people make changes to the Reason Code
after receipt. I think I have a portion of it figured out, but I can't
seem to get the current user. Like 'If current user = "Fred" or current
user = "John" then....' This would be after checking for the receipt
(rmadtl = rmarcpt). But I can't get how to check the current user
against specific names. I tried USERID and it does nothing, and I've
seen somethings about DCD-USERID, but that just errors. I know there has
to be something that is right in front of me, but I can't see it. Can
anyone help on this? Thanks in advance for any help!

Regards,

Kurt

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]
Thanks for your replies! But, I keep getting various errors when trying to use the DCD-USERID in the Method Directives..Compose Query screen. What syntax would you use to check if someones user id equal a specific name? DCD-USERID = "John Smith" ? This is where I get errors. The other syntax I'm getting through, but this is giving me a problem. Can you help on this? Again, thanks for all your help!!

Regards,

Kurt



--- In vantage@yahoogroups.com, "Kevin Simon" <ksimon@...> wrote:
>
> Ditto what Joe said - definitely do this as part of security groups. That
> way, any security admin can change it and it doesn't require someone to dig
> into BPM's. Also, if you have multiple BPM's that are affected, you only
> have to make one change to the group instead of having to change multiple
> BPMs.
>
>
>
> Kevin Simon
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Joe Rojas
> Sent: Wednesday, January 19, 2011 4:41 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] User ID used in a BPM
>
>
>
>
>
> The variable is DCD-USERID. It should work.
>
> What might be easer is to create a security group and then I think one
> of the conditions on a BPM is to check that the user is part of a
> security group.
>
> That what you don't have to change your BPM as people come and go.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Kurt
> Sent: Wednesday, January 19, 2011 4:21 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] User ID used in a BPM
>
> Hi all!
>
> I'm trying to do a BPM for the RMA Processing screen. Basically, it is
> supposed to let only certain people make changes to the Reason Code
> after receipt. I think I have a portion of it figured out, but I can't
> seem to get the current user. Like 'If current user = "Fred" or current
> user = "John" then....' This would be after checking for the receipt
> (rmadtl = rmarcpt). But I can't get how to check the current user
> against specific names. I tried USERID and it does nothing, and I've
> seen somethings about DCD-USERID, but that just errors. I know there has
> to be something that is right in front of me, but I can't see it. Can
> anyone help on this? Thanks in advance for any help!
>
> Regards,
>
> Kurt
>
> 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]
>
I'm pretty sure that you can only put queries in the Compose Query
screen, not just any code. Or in other words, a query where rows from a
table are returned.

In this case, you would want to use the condition that says something
like "the user belongs to specific security group".



You want to still check the actual user id, then you will need to go
into advanced and where your own ABL code.

Keep in mind that DCD-USERID contains the user's username not there full
name.



If this case, it would look something like:



If DCD-USERID = "jrojas" then

Do something

Else

Do something else







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kurt
Sent: Thursday, January 20, 2011 8:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: User ID used in a BPM





Thanks for your replies! But, I keep getting various errors when trying
to use the DCD-USERID in the Method Directives..Compose Query screen.
What syntax would you use to check if someones user id equal a specific
name? DCD-USERID = "John Smith" ? This is where I get errors. The other
syntax I'm getting through, but this is giving me a problem. Can you
help on this? Again, thanks for all your help!!

Regards,

Kurt

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Kevin Simon" <ksimon@...> wrote:
>
> Ditto what Joe said - definitely do this as part of security groups.
That
> way, any security admin can change it and it doesn't require someone
to dig
> into BPM's. Also, if you have multiple BPM's that are affected, you
only
> have to make one change to the group instead of having to change
multiple
> BPMs.
>
>
>
> Kevin Simon
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> Joe Rojas
> Sent: Wednesday, January 19, 2011 4:41 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] User ID used in a BPM
>
>
>
>
>
> The variable is DCD-USERID. It should work.
>
> What might be easer is to create a security group and then I think one
> of the conditions on a BPM is to check that the user is part of a
> security group.
>
> That what you don't have to change your BPM as people come and go.
>
> 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 Kurt
> Sent: Wednesday, January 19, 2011 4:21 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] User ID used in a BPM
>
> Hi all!
>
> I'm trying to do a BPM for the RMA Processing screen. Basically, it is
> supposed to let only certain people make changes to the Reason Code
> after receipt. I think I have a portion of it figured out, but I can't
> seem to get the current user. Like 'If current user = "Fred" or
current
> user = "John" then....' This would be after checking for the receipt
> (rmadtl = rmarcpt). But I can't get how to check the current user
> against specific names. I tried USERID and it does nothing, and I've
> seen somethings about DCD-USERID, but that just errors. I know there
has
> to be something that is right in front of me, but I can't see it. Can
> anyone help on this? Thanks in advance for any help!
>
> Regards,
>
> Kurt
>
> 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]
>












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]
Cany ou isolate the user into a security group. If so, then there is a condition for the user belonging to OR not belonging to a specific group.


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