Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Multiply assignment to execut WF step

Highlighted
Alexander (Sua)
Regular Collector

Multiply assignment to execut WF step

I have steps in WF where decision should take some users.
These users listed in security group.
Users belong to different org units.
I need to select some users from this group basing on belonging of the user who's crated request to one of org units

I made execution step where execute SQL request to select necessary users, but as a result I see a message that result of a request doesn't fit to field lenght

Anybody met this problem?
4 REPLIES
Alexander (Sua)
Regular Collector

Re: Multiply assignment to execut WF step

Any ideas how to workaround this problem?
kerimkilic
Super Collector

Re: Multiply assignment to execut WF step

you need to write that sql in the validation of the user list field where you want to show.

if you want to fill that field with the users, make it multiple enabled and write data according to in db field like #@# i think this helps.
Alexander (Sua)
Regular Collector

Re: Multiply assignment to execut WF step

Exactly like this I did and it caused a problem (about 20 users)
I even tried to use user ids, not usernames. But it also did not solve the problem

I used workaronund - separate users into subgroups and use assingment to groups instead assignment to user
Alexander (Sua)
Regular Collector

Re: Multiply assignment to execut WF step

See above
//Add this to "OnDomLoad" event