| NAME | AGE | GENDER |
|---|---|---|
| Dan | 21 | Male |
| Jona | 23 | Female |
| Sam | 18 | Female |
The criteria is gender and I am only to enroll users that are female. How do I do that?
Big thanks!
In reply to Bernie Rey Barsomo
Re: Selected users for external database enrollment
by Emma Richardson -
When you say enroll - do you mean into a course?
In reply to Emma Richardson
Re: Selected users for external database enrollment
by Bernie Rey Barsomo -
Hi Emma! Thanks for your response. Sorry for the confusion. I meant External Database Authentication 
In reply to Bernie Rey Barsomo
Re: Selected users for external database enrollment
by Leon Stringer -
So to be clear: authentication is providing access to the site using an external source, enrolment is adding users into courses using an external source.
If you only want a subset of the users table to be able to access the site you'll need to create a database view in that only returns the subset and specify that view in the Table field in the External Database authentication plugin settings.
For example if the external database was MySQL the view could be created with:
CREATE VIEW users_female AS SELECT name, ... FROM users WHERE gender = 'Female';
Seconding this recommendation, this has worked very well for us for years. Just be careful with tweaking the view parameters since it will unenroll students that are removed from the view.
In reply to Leon Stringer
Re: Selected users for external database enrollment
by Bernie Rey Barsomo -
Hi Leon! I will definitely try try that. Thank you all the way from the Philippines!