How do we query user properties in jira6 database

[eric anier]

from previous questions, query like this wont return any result.

id in table external_entities have way different value in propertyentry.entity_id

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.%'

[eric anier · Accepted solution]

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

[Boris Georgiev [Appfire]]

So the problem is solved ?

[Boris Georgiev [Appfire]]

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 ?