X-Path constraint on a Data Grid,

5
I have a datagrid in which questionnaire are shown. The questionnaire can have different statuses. I have 3 different employees in one userrole (viewer, MD, FD). I want the viewer, MD and FD to see the questionnaires when the status is 'In_progress' or 'Locked'. And only the viewer to see the questionnaire when the status is 'Closed'. I thought it would be set like this: [Status = 'In_progress' or Status = 'Locked'] [LOR.Questionnaire_QuestionnaireRound/LOR.Questionnaire [LOR.Questionnaire_MD = '[%CurrentUser%]'or LOR.Questionnaire_FD = '[%CurrentUser%]' or LOR.Questionnaire_Viewer = '[%CurrentUser%]'] or [Status ='Closed'] [LOR.Questionnaire_QuestionnaireRound/LOR.Questionnaire/LOR.Questionnaire_Viewer = '[%CurrentUser%]'] this doesnt seem possible. Does anyone know a solution for this. (I prefer not to create a new UserRole for viewers).
asked
1 answers
4

Something like this

[((Status = 'In_progress' or Status = 'Locked')
and
LOR.Questionnaire_QuestionnaireRound/LOR.Questionnaire
[LOR.Questionnaire_MD = '[%CurrentUser%]'or 
LOR.Questionnaire_FD = '[%CurrentUser%]' or
LOR.Questionnaire_Viewer = '[%CurrentUser%]'
]
) or
(Status ='Closed'  and      LOR.Questionnaire_QuestionnaireRound/LOR.Questionnaire/LOR.Questionnaire_Viewer = '[%CurrentUser%]')

]

answered