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
We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...
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