Searching users by profile field (moodle 2.2.3)

Searching users by profile field (moodle 2.2.3)

de către Brian Bell-
Număr de răspunsuri: 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

Media aprecierilor: -
Ca răspuns la Brian Bell

Re: Searching users by profile field (moodle 2.2.3)

de către AL Rachels-
Fotografia lui Core developers Fotografia lui Particularly helpful Moodlers Fotografia lui Plugin developers Fotografia lui 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

Ca răspuns la AL Rachels

Re: Searching users by profile field (moodle 2.2.3)

de către Brian Bell-

That helps indeed - thank you!

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

Brian