Searching users by profile field (moodle 2.2.3)

Searching users by profile field (moodle 2.2.3)

par Brian Bell,
Nombre de réponses : 2

I have a profile field named Institution (and my users do have the field populated) but when I search using Institution I always get 0 users... what might the problem be?

Thank you,

Brian

Moyenne des évaluations  -
En réponse à Brian Bell

Re: Searching users by profile field (moodle 2.2.3)

par AL Rachels,
Avatar Core developers Avatar Particularly helpful Moodlers Avatar Plugin developers Avatar Testers

Hi Brian,

Are you saying that you have added a profile field named Institution? Where are you searching?

  1. Profiles in Moodle 2.2.3 already have a field named Institution, so if that is the one you are searching, it is stored in the mdl_user table. You can look with something like phpMyAdmin to see if that is where your info is stored.
  2. If you added a profile field, the setup parameters are stored in the mdl_user_info_field table.
  3. If you added a profile field, the actual data you want is stored in the mdl_user_info_data table and that is where you would need to search. I contains the user id, the id of the field you added, and the actual data that was added.

Hope this helps,

AL

En réponse à AL Rachels

Re: Searching users by profile field (moodle 2.2.3)

par Brian Bell,

That helps indeed - thank you!

Yes, I did create a new field... not a great idea in retrospect.

Brian