Mapping table propertyentry to cwd_user

francis

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

Jobin Kuruvilla [Adaptavist]

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'));