The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to change the Users User Data value without calling a function or procedure

Highlighted
kndlny
Regular Collector

Is it possible to change the Users User Data value without calling a function or procedure

Hi,

 

I wonder whether it is possible to update Users User Data without calling a function or procedure which has an UPDATE statement.

 

In other words, is it possible to update this user data inside a workflow step.

 

I have tried

 

ksc_store USR="[REQ.CREATED_BY_USERNAME]".US.USERDATA = "[REQ.P.MY_TOKEN]","[REQ.VP.MY_TOKEN]"

 

and

 

ksc_set USR="[REQ.CREATED_BY_USERNAME]".US.USERDATA = "[REQ.P.MY_TOKEN]"

ksc_set USR="[REQ.CREATED_BY_USERNAME]".VUS.USERDATA = "[REQ.VP.MY_TOKEN]"

 

both ways did not update the users user data value.

 

Is there another way I can update this value without using a db function_

 

Thanks

 

1 REPLY
philipwood
Regular Collector

Re: Is it possible to change the Users User Data value without calling a function or procedure

Not much of an alternative, but you could use ksc_local execute to call sqlplus to execute the desired update statement - either a a script or as an command line parameter.

//Add this to "OnDomLoad" event