Wednesday, May 28, 2008

extract project lead email list in JIRA

select p.pname, ub.username, ps.propertyvalue from userbase ub,propertyentry pe, propertystring ps, project pwhere ub.id=pe.entity_id and pe.property_key=’email’ and ps.id=pe.id and p.lead=ub.username order by p.pname

Reference:http://confluence.atlassian.com/display/JIRA/Database+Schema

No comments: