HI
I have a task browser screen where the ask is assigned either by User or by security Role.
When I use query with user parameter like this, it works:
in XML, query for the data Container:
select e from erp_WorkflowTaskStatus e where e.readyForAction = true
and e.actionDone = false and e.userAssigned = :userLogin
sending parameter before show event in the controller:
@Subscribe
public void onBeforeShow(BeforeShowEvent event) {
workflowTaskLinesDl.setParameters(ParamsMap.of("userLogin",userSessionSource.getUserSession().getCurrentOrSubstitutedUser()));
workflowTaskLinesDl.load();
]
}
it loads the data successfully.
However, when i add the role related query condition as follows:
select e from erp_WorkflowTaskStatus e where e.readyForAction = true
and e.actionDone = false and (e.userAssigned = :userLogin OR e.secRoleAssigned in :userRoles)
and load in controller as follows:
@Subscribe
public void onBeforeShow(BeforeShowEvent event) {
workflowTaskLinesDl.setParameters(ParamsMap.of("userLogin",userSessionSource.getUserSession().getCurrentOrSubstitutedUser(), "userRoles", userSessionSource.getUserSession().getCurrentOrSubstitutedUser().getUserRoles()));
workflowTaskLinesDl.load();
]
}
It dones’t display any data but empty browser screen table.
Is there any error in my code or it’s a bug?