Moodle: CSV bulk download of other fields in user profile not showing data -

sample outcome:

i'm wondering possible show gender male rather 2. shows number answer when uses multi select answers dropdown etc.

i hope can point me right direction, help.

i'm guessing old version of moodle?

you use instead replace numbers values:

select u.id,         u.username,         /* other user fields need */         d.user_profile_gender,         d.user_profile_agegroup,         d.user_profile_jobtitle,         d.user_profile_department mdl_user u left join (     select d.userid,     max(case             when f.shortname = 'gender' , d.data = '1' 'male'             when f.shortname = 'gender' , d.data = '2' 'female'             else null         end) user_profile_gender,     max(case             when f.shortname = 'agegroup' , d.data = '1' 'xxx'             when f.shortname = 'agegroup' , d.data = '2' 'yyy'             else null         end) user_profile_agegroup,     max(case when f.shortname = 'jobtitle' d.data else null end) user_profile_jobtitle,     max(case when f.shortname = 'department' d.data else null end) user_profile_department     mdl_user_info_data d     join mdl_user_info_field f on f.id = d.fieldid         , f.shortname in ('gender', 'agegroup', 'jobtitle', 'department')     group d.userid ) d on d.userid = u.id