Mapping table propertyentry to cwd_user

francis
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
September 17, 2013

Hi,


Question - where can we access the property which specifies how many issues a user can see on a single issue navigator page ?

We found the user.issues.per.page preference in the database ( in the propertyentry table), but it is unclear how this parameter links to cwd_user.

Either this property is not in use anymore - and is replaced with another property in the database - which ? or I'm looking in the wrong place.

Can someone help

1 answer

0 votes
Jobin Kuruvilla [Adaptavist]
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.
September 17, 2013

Try this. Entity links to app_user in 6.x to enable renaming of users.

select * from propertynumber where ID = (select ID from propertyentry where PROPERTY_KEY = 'user.issues.per.page' and ENTITY_ID = (select ID from app_user where user_key = 'xxx'));

Suggest an answer

Log in or Sign up to answer