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
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.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