Ok when I use a Script Runner Custom field (I initially used a free script cust. field type) to get the project lead for issues - I use the following script:
issue.getProjectObject().getProjectLead().getDisplayName()
1. I do get the project lead for each issue. It works in JQL searches, and I can add it as a column but it sorts on first name - would prefer last name sort. My JQL is: resolution is EMPTY AND updatedDate <= startOfYear() ORDER BY issueProjectLead, project ASC
2. I created it as a free text field. Apparently that is not countable / Statable. Who knew?! Ok, maybe you guys but not me. I can change the context but what kind of field would you use to make a custom field like this one Statable? I need this to use in the pie graph widget. I want to display the number of tickets in this state and sort by Project Owner in a nice display. I can do this by reporter and assignee but not Proj Lead.
Can I do this?
