If you have questions or if you want to share your opinion about Aware IM post your message on this forum
#52523 by swiftinitpvtltd
Tue Dec 24, 2019 1:01 pm
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)
#52559 by ddumas
Thu Dec 26, 2019 7:03 pm
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
#52562 by swiftinitpvtltd
Fri Dec 27, 2019 1:53 am
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
#52563 by himanshu
Fri Dec 27, 2019 4:29 am
Hi Amit,

try this

FIND TaskList WHERE LoggedInRegularUser IN TaskList.AssignedUsers
#52566 by eagles9999
Fri Dec 27, 2019 11:01 am
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.
#52570 by ddumas
Sat Dec 28, 2019 12:58 pm
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
#52571 by eagles9999
Sat Dec 28, 2019 1:25 pm
Wow! Really?! ;-)

Who is online

Users browsing this forum: idpSteve, MSN [Bot] and 21 guests