How do we query user properties in jira6 database

eric anier2

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 anier2

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