Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
royster

Senior Member
Registered:
Posts: 74
Reply with quote  #1 

Good afternoon all.

I am having a wonderful time attempting to create a dynamic role. Basically I want my dynamic role to be a  list of everyone in my static role (role1) except the last person to action the folder, which I store in a process variable. I am using

SelectSql(null,String.Format("SELECT EUSERNAME FROM EASSIGNMENT WHERE EROLENAME = 'role1' AND EUSERNAME <> @LastApprover ", SQLArg("@LastApprover",ProcessVariable.LastApprover))


As far as I can see, if the select statement returns 5 users, it will;

1) Appear on all 5 users' to do lists
2) Show the action button(s) for all 5 users
3) Only allow 4 of the 5 users to view the read only forms, visible to this stage. The 5th user gets a "No forms are available in this folder" message
4) Only 4 out of 5 users can click on the action button and open the form in read/write mode. The same 5th user, gets a "Attempt to access 'Form' - 'Form1' - failed for user '5th User'." message. The form has only Access roles enabled.

Is there something wrong with my SelectSql?

Thanks


0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #2 
Where are you using the role? It sounds like you are only using it in the 'limit access to' property of the form, or the map. The SQL looks fine.
__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
royster

Senior Member
Registered:
Posts: 74
Reply with quote  #3 
Hi Jerome
No I am using the "Access" as the limit access to property of the form. The dynamic roles are only being applied to the Stage todo list and the "who can perform this action".

I cannot replicate this anywhere else. I have created a mini pproject with 1 form and 2 actions and it works fine. Looks like /i will need to dig deeper.
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #4 
Make sure you use ".List" at the end of the function callm BTW
__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
royster

Senior Member
Registered:
Posts: 74
Reply with quote  #5 
Funnily enough, it did resolve itself today. No prompting from me. It just started working.

I did use the .List while I was having trouble and that didn't solve the problem.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!