Author |
Message
|
fairymails |
Posted: Tue Jun 13, 2006 8:02 am Post subject: Filter by current user |
|
|
Newbie
Joined: 13 Jun 2006 Posts: 6
|
Hi, I want to filter a worklist by the current_user, I know I can write something like if owner = current_user but can I use this current_user syntax to show only certain users certain items in a worklist,
So for a user id bloggsj can I write
current_user = 'bloggsj'
Thanks much for help in advance.
 |
|
Back to top |
|
 |
Ratan |
Posted: Tue Jun 13, 2006 8:45 am Post subject: |
|
|
 Grand Master
Joined: 18 Jul 2002 Posts: 1245
|
Did not understand what you are trying to acheive. If you want to display workitems belonging to a certain user, use Owner = 'thatuser'. _________________ -Ratan |
|
Back to top |
|
 |
fairymails |
Posted: Tue Jun 13, 2006 9:54 am Post subject: |
|
|
Newbie
Joined: 13 Jun 2006 Posts: 6
|
hi thanks for getting back, my workflow is configured so a user can only be a member of one team, i have a small number of users that I wish to make a member of two teams. Seeing as I could only put them directly into one team I have made the other team a virtual team with a virtual team manager. So for bloggsj I want him to see his own items and ones owned by virtual_team_manager, so I tried to filter his worklist by
(owner = current_user) or (current_user = bloggsj and owner = virtual_team_manager)
I cant get the filter to accept current_user = bloggsj
Maybe I cant filter by current_user in this manner?
Ideas much appreciated!
 |
|
Back to top |
|
 |
Ratan |
Posted: Tue Jun 13, 2006 10:35 am Post subject: |
|
|
 Grand Master
Joined: 18 Jul 2002 Posts: 1245
|
you should use something like
OWNER = 'bloggsj' OR OWNER = 'virtual_team_manager'
and also you need to authorize bloggsj for virtual_team_manager's workitems. _________________ -Ratan |
|
Back to top |
|
 |
fairymails |
Posted: Tue Jun 13, 2006 12:47 pm Post subject: |
|
|
Newbie
Joined: 13 Jun 2006 Posts: 6
|
thing is that i cant let bloggsj be the owner of the items in question because there are a couple of members in the virtual group besides bloggsj, if i make him the sole owner the others wouldnt see them, also bloggsj is a member of another team and i dont want all the rest of his first team to see the items, i know this is a pain, but in essence i need only those with
((owner = virtual_team_manager and current_user = 'bloggsj' or other_virtual_team_member)
or
(owner = current_user))
to have these items in their worklistband. I need to specify the bloggsj to prevent all users having these items show up their worklists.
In pseudocode
if (current_user = bloggsj or other_virtual_team_members)
{ show items belonging to current_user
and items belonging to virtual_team_manager}
else
{show items belonging to current_user}
My workflow contractor leaves on thursday and I know if we dont figure out this member of two teams problem by then the book stops with me!!
There may be some problem if either the current_user variable or the string userid i feed it are not resolved until run-time? |
|
Back to top |
|
 |
Ratan |
Posted: Tue Jun 13, 2006 12:55 pm Post subject: |
|
|
 Grand Master
Joined: 18 Jul 2002 Posts: 1245
|
Give authorization of virtual_team_manager's workitems to all the Virtual_Team_Members (I guess in usr example bloggsj is a member of virtual_Team_Members).
Then Virtual_Team_Members worklist will contain all the items that are owned by them and any workitems owned by Virtual_team_manager. _________________ -Ratan |
|
Back to top |
|
 |
fairymails |
Posted: Tue Jun 13, 2006 1:04 pm Post subject: |
|
|
Newbie
Joined: 13 Jun 2006 Posts: 6
|
sorry , the point is hard to explain, it is a virtual team but not in the workflow sense of a virtual group, but it is a team that has no members, i cant put members into it because they are already in another team and the system is configured so any user can only be in one group...i dunno is this standard but its the way this is set up in any case, have you ever heard of a way to filter by current_user and a user id?
u might be seeing more of me, i've new orders to be the workflow person for an insurance company and at first glances i'm scared....
N
 |
|
Back to top |
|
 |
jmac |
Posted: Tue Jun 13, 2006 4:11 pm Post subject: |
|
|
 Jedi Knight
Joined: 27 Jun 2001 Posts: 3081 Location: EmeriCon, LLC
|
The issue is tha WMQWF will NOT let a user see work that they are not authorized to see. IF you do not authorize the users to see the work of this "virtual user" there is NO filter that will ever be able to show you what you are looking for.
It sounds to me like you need to review the design maybe. _________________ John McDonald
RETIRED |
|
Back to top |
|
 |
fairymails |
Posted: Wed Jun 14, 2006 1:35 am Post subject: |
|
|
Newbie
Joined: 13 Jun 2006 Posts: 6
|
hey thanks for the help, not what i wanted to hear but sure at least i know
Cheers N |
|
Back to top |
|
 |
fairymails |
Posted: Thu Jun 15, 2006 5:26 am Post subject: |
|
|
Newbie
Joined: 13 Jun 2006 Posts: 6
|
HEY GRANDMASTER, ARE YOU STILL OUT THERE, I HAVE GOTTEN MY HEAD A BIT MORE AROUND WORKFLOW IDEAS AND HAVE MET MUCH RESISTANCE TO CHANGING THE SYSTEM. AT THIS POINT MY BLOGGSJ HAS BEEN AUTHORISED TO VIEW THE ITEMS OWNED BY MY VIRTUAL_TEAM_MANAGER, HOWEVER I STILL NEED THESE ITEMS TO SHOW UP ON BLOGGSJ'S WORKLIST. I THINK THE FILTER IS THE PLACE TO DO THIS, SEEING AS ALL USERS DONT NEED TO SEE THE ITEMS IN QUESTION I NEED TO FILTER TO SHOW THESE ITEMS ONLY TO SOME USERS SO ONLY IF CURRENT_USER = BLOGGSJ, AS I ONLY WANT SOME USERS TO SEE THESE ITEM IN THEIR "MY WORKLIST"
IS THE USE OF CURRENT_USER IN THIS WAY EVER POSSIBLE?
CHEERS N |
|
Back to top |
|
 |
jmac |
Posted: Thu Jun 15, 2006 5:32 am Post subject: |
|
|
 Jedi Knight
Joined: 27 Jun 2001 Posts: 3081 Location: EmeriCon, LLC
|
If I understand your scenario correctly then you need two worklists. One that would show OWNER = CURRENT_USER (WL1) and one with NO FILTER (WL2)
WL1 can be used to show any user just their own work.
WL2 can be used to show any user all the work they are Authorized to see. This is what it sounds like your bloggsj user needs.
For a user NOT authorized to see any other user's work, they will show the same workitems. But for those users authorized to see the work of one or more additional users, WL2 will show them "ALL" their work.
BTW.... this is generally the 2 worklists I create in any MQWF system. _________________ John McDonald
RETIRED |
|
Back to top |
|
 |
|