multiple assigned users filter for a query

swiftinitpvtltd

I do not see a simple filter in BO query when an item is assigned to Multiple users. How do I quickly filter an item only for
users who have been assigned that task/item(if task is assigned to 3 users they only should see it-task item with om_usersassigned does not show up in query filter)

ddumas

Can you explain this a bit more?

Explain all BOs and relevant attributes, and their relationships.
What specifically is not working.
Screenshots are great too.

I would like to help, but from the post, I cannot understand your setup / what is needed.

Dave

swiftinitpvtltd

Thanks. basically I have a task list and multiple users are assigned to a single task-Project.
ProjectTasklist BO- it contains om_RegularUsersAssigned-multiple users for a single project task assigned

Regular User BO

All these project assignees need to see in their query grid that they are assigned to this project/projects. But the query of Task BO grid can not have filter for users because it has multiple allowed-it just does not show up in filter criteria of task list query. Is there any IN custom query that I can write for example

FIND Tasklist where LoggedInRegularUser inside Tasklist

himanshu

Hi Amit,

try this

FIND TaskList WHERE LoggedInRegularUser IN TaskList.AssignedUsers

ddumas

Try :

FIND Project WHERE count ProjectTaskList WHERE(LoggedInRegularUser=ProjectTaskList.om_RegularUsersAssigned and ProjectTaskList.Project = Project )>0

customaware

ddumas wrote
Try :

FIND Project WHERE count ProjectTaskList WHERE(LoggedInRegularUser=ProjectTaskList.om_RegularUsersAssigned and ProjectTaskList.Project = Project )>0

This will not work as it is. You are trying to equate a single value with a multiple. I think change it to....

FIND Project WHERE COUNT ProjectTaskList WHERE(LoggedInRegularUser IN ProjectTaskList.om_RegularUsersAssigned AND ProjectTaskList.ob_Project = Project )>0

Additionally, I would think om_ should be a pm_ Reference. Having ProjectTaskList Owning Multiple RegularUsers look really dangerous to me.

swiftinitpvtltd

FIND TaskList WHERE LoggedInRegularUser IN TaskList.AssignedUsers this thing suggested by Himanshu worked nicely-have not checked other options as this works. Thanks all. I will check om/pm references.

ddumas

eagles9999 wrote
ddumas wrote
Try :

FIND Project WHERE count ProjectTaskList WHERE(LoggedInRegularUser=ProjectTaskList.om_RegularUsersAssigned and ProjectTaskList.Project = Project )>0

This will not work as it is. You are trying to equate a single value with a multiple. I think change it to....

FIND Project WHERE COUNT ProjectTaskList WHERE(LoggedInRegularUser IN ProjectTaskList.om_RegularUsersAssigned AND ProjectTaskList.ob_Project = Project )>0

Additionally, I would think om_ should be a pm_ Reference. Having ProjectTaskList Owning Multiple RegularUsers look really dangerous to me.

Mine will work if he wants to show all projects that exists in which the logged in user is assigned on a project task within a project. If that's not what he wants then I may have misunderstood his intent.
Dave

customaware

Wow! Really?! 😉