pe.ID = ps.ID
ee.ID = pe.ENTITY_ID
hi, im using 6.0.8
anyway query below returs corect data.
select au.user_key, pe.entity_id, substr(pe.property_key,11) name, pe.id, ps.propertyvalue from app_user au , PROPERTYENTRY pe , PROPERTYSTRING ps where au.id = pe.entity_id and pe.property_key like '%IJR%' and pe.id = ps.id order by user_key, name
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG