Create view to show all users, including column showing their membership of a particular Group (or not)

Hi. Our installation provides read-only for guests, and requires anyone creating or editing content to have an account, and to be a member of the Editors Group.

We would like to create a view on the main users Group, including a column which indicated which users are shown as being members of the Editors Group (or not). That way we can easily spot any "orphan" registered users who have no Editing rights.

In SQL terms this would be a Left Join. So, if UserID is the key used in GroupMembership

   SELECT WikiUsers.UserID, WikiUsers.EmailAddr, GroupMembership.GroupName
   FROM WikiUsers
   LEFT JOIN GroupMembership ON WikiUsers.UserID = GroupMembership.UserID
   WHERE GroupMembership.GroupName = 'EditorsGroup'

Commenting is disabled while not logged in