select
*
from
propertyentry pe,
propertystring ps,
external_entities ee
where
pe.ID = ps.ID
and
ee.ID = pe.ENTITY_ID
and
PROPERTY_KEY
like
'jira.meta.%'
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
So the problem is solved ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Which version of JIRA are you using ? I've tried this on JIRA 6.1.7 and it returns result.
Are you sure there are any user properties set ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.