BPM Question On Current User

Yahoo Archive
1
DCD-USERID is a system variable so it doesn't need the table name.



Try using STRING(DCD-USERID).



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dines, Tim
Sent: Thursday, September 16, 2010 9:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM Question On Current User





What table is DCD-USERID located in? You need the table name just like
on the other side of the equation unless you declare a variable and put
the DCD-USERID value into it first.

Tim Dines

ERP Analyst

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

765-675-5201

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of melissa hietala
Sent: Wednesday, September 15, 2010 11:24 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BPM Question On Current User

I have a BPM setup on the method "UD100.GetByID". I have a post
processing
directive I am attempting to setup utilizing the "number of rows in the
designed query is not less than 1" condition. What I need to do is
after the
"GetByID" method is launched, I need to take the value that is in the
ttUD01.ShortChar01" field and compare it to the ID of the user that is
currently
logged in (I believe the syntax for this is "DCD-UserID"). So I am
attempting
to enter the following code into the condition:

for each ttUD100 where ttUD100.ShortChar01 = DCD-UserID no-lock

However I am receiving an error stating: "DCD-UserID must be a quoted
constant
or an unabbreviated, unambiguous buffer/field reference for buffers
known to
query . (7328)"

Any thoughts on what I am doing wrong or how I can get this corrected?

Thanks for your help,

Dustin Biniek

[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 have a BPM setup on the method "UD100.GetByID". I have a post processing
directive I am attempting to setup utilizing the "number of rows in the
designed query is not less than 1" condition. What I need to do is after the
"GetByID" method is launched, I need to take the value that is in the
ttUD01.ShortChar01" field and compare it to the ID of the user that is currently
logged in (I believe the syntax for this is "DCD-UserID"). So I am attempting
to enter the following code into the condition:

for each ttUD100 where ttUD100.ShortChar01 = DCD-UserID no-lock

However I am receiving an error stating: "DCD-UserID must be a quoted constant
or an unabbreviated, unambiguous buffer/field reference for buffers known to
query . (7328)"

Any thoughts on what I am doing wrong or how I can get this corrected?

Thanks for your help,

Dustin Biniek




[Non-text portions of this message have been removed]
3
I have done something similar.

But I Assigned ttTableName.ShortChar01 = DCD-UserID.

THEN, I compared ttTableName.ShortChar01 to whatever other field

How did you get the user id in ShortChar01 in the first place?

> I have a BPM setup on the method "UD100.GetByID". I have a post
> processing
> directive I am attempting to setup utilizing the "number of rows in the
> designed query is not less than 1" condition. What I need to do is after
> the
> "GetByID" method is launched, I need to take the value that is in the
> ttUD01.ShortChar01" field and compare it to the ID of the user that is
> currently
> logged in (I believe the syntax for this is "DCD-UserID"). So I am
> attempting
> to enter the following code into the condition:
>
> for each ttUD100 where ttUD100.ShortChar01 = DCD-UserID no-lock
>
> However I am receiving an error stating: "DCD-UserID must be a quoted
> constant
> or an unabbreviated, unambiguous buffer/field reference for buffers known
> to
> query . (7328)"
>
> Any thoughts on what I am doing wrong or how I can get this corrected?
>
> Thanks for your help,
>
> Dustin Biniek
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
4
What table is DCD-USERID located in? You need the table name just like
on the other side of the equation unless you declare a variable and put
the DCD-USERID value into it first.



Tim Dines

ERP Analyst

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

765-675-5201



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of melissa hietala
Sent: Wednesday, September 15, 2010 11:24 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM Question On Current User





I have a BPM setup on the method "UD100.GetByID". I have a post
processing
directive I am attempting to setup utilizing the "number of rows in the
designed query is not less than 1" condition. What I need to do is
after the
"GetByID" method is launched, I need to take the value that is in the
ttUD01.ShortChar01" field and compare it to the ID of the user that is
currently
logged in (I believe the syntax for this is "DCD-UserID"). So I am
attempting
to enter the following code into the condition:

for each ttUD100 where ttUD100.ShortChar01 = DCD-UserID no-lock

However I am receiving an error stating: "DCD-UserID must be a quoted
constant
or an unabbreviated, unambiguous buffer/field reference for buffers
known to
query . (7328)"

Any thoughts on what I am doing wrong or how I can get this corrected?

Thanks for your help,

Dustin Biniek

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





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