Why some fields are not compatible with 'is' and 'is not' operator and how to identify them

[Lalit Salunkhe]

Hi,

I have a 'linkedissue' field in which some filed contain values and some are blank. I want to filter out the blank values. when I try to write JQL it does not support 'is' and 'is not' operators. Can you please help how I can achieve this?

Advice at earliest.

Thanks.

[Steinar Bang · Accepted solution]

I had set the return type to "Any", since what I wanted was User but not one of the other alternatives ("IssueFunction", "Project", "Version", "Component", "ProjectCategory", "Issue").

Switching the return type to something other than "Any", still with the pasted MyProjects script in the inline, gave various returned values (a collection of two items interpreted variously).

Could the message come from the return type "Any" not being supported for getValues returns?

If so, I guess I will have to reformulate the JQL function to return one of the allowed types. What I actually wanted this function for, was to create a query for issues reported by users that have a particular role in a particular project. So I will try changing the function from hasRole to issuesReportedByRole.

[Steinar Bang]

Finding all issues reported by a particular user doesn't seem to be easy in the API, except by iterating over all issues and checking for the reporter. This was one of the reason I tried to go the hasRole way in the first place. I had hoped to be able to do something like this in JQL:

reporter in hasRole("Somerole")

Is there a way to query the API for all issues reported by a particular user, that doesn't involve iterating over all issues?

Thanks!

- Steinar