Unavailable JQL function projectsWhereTextProperty to some users

Issue #996 resolved
Janata Radek created an issue

The following JQL works well under my personal account but it returns error under local admin user. Both users are JIRA system administrators. This seems to be related to the recent JWT 2.3.4 update. It worked in 2.3.3.

project in projectsWhereTextProperty(AutoClose, "=", 1w) AND status = Resolved and updated <-1w

I get the following error when this JQL is run under the local admin user: A value provided by the function 'projectsWhereTextProperty' is invalid for the field 'project'.

I use this JQL in combination with ScriptRunner's Built-in script (Escalation service) to automatically close resolved issues after 1 week of inactivity. This stopped working (probably after the JWT update; but the root cause might be different)

Comments (4)

  1. Fidel Castro Armario repo owner

    Hi @CraZ_CZ,

    Update from 2.3.3 to 2.3.4 doesn't provide any modification in JQL functions. The reasonable explanation is that both users don't have browse project permission in the same projects. The fact that both are administrators, doesn't guarantee the same permissions.

    Anyway, it would be great if you could temporarily downgrade to JWT 2.3.3 and check whether the problem keeps happening.

  2. Janata Radek reporter

    Hi @fcarmario, thanks for response. I found a reason why it now worked, it was a silly PEBKAC issue :-( Sorry for bothering and you can close this bug as invalid.

  3. Log in to comment