Question

Photo of Richard Sanford

0

Problem with Group Requirements v 8.4

I'm having a problem with group requirements. I have setup 2 requirement types, 1 to check for male gender and the other to check for female gender. I want the requirement(s) set at the group level not group type level. However I have had to set both requirements at the group type, then go into each group and set just the one I want for that group and then on to the next group with the specific requirement for that group. So what has happened is i have both requirements at the group type and one at the group level. If I go back to Group Types and remove the group type requirements then I only have the requirement I want at the group level. I don't think it's supposed to work this way, am I right?

  • Photo of Thomas Stephens

    0

    I think there is a current problem with dataview group requirements. You can do SQL though. The SQL to select all males is


    SELECT p.Id

    FROM Person p

    WHERE p.Gender = 1;


    Females would be


    SELECT p.Id

    FROM Person p

    WHERE p.Gender = 2;