How do we query user properties in jira6 database

eric anier
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 16, 2014
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.%'

2 answers

1 accepted

0 votes
Answer accepted
eric anier
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 16, 2014

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_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 16, 2014

So the problem is solved ?

0 votes
Boris Georgiev _Appfire_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 16, 2014

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 ?

Suggest an answer

Log in or Sign up to answer