Confluence not allowing me to save filters

[Doug Ancil]

I have a custom filter that I am trying to save in confluence. It is a simple SQL query. Code check verifies that there are no code errors in my query, but when I attempt to save it, it will save the name but not the query. I have tried this in 4 different browsers (Opera, Safari, Chrome & Vivaldi) and I am on a Mac running High Sierra, 10.13.5. The query is as follows:

project = ITS AND status in ("In Progress", "In Review", Open, "Ready to Deploy", Reopened, "To Do", "Waiting on Information") AND assignee in membersOf(IT-SUPPORT) AND type not in (Folder) AND assignee = dancil ORDER BY updated DESC

Any help would be appreciated. 

Thanks

[Davin Studer · Accepted solution]

You must run the JQL once before it will allow you to save the JQL as a filter. FYI, "assignee in membersOf(IT-SUPPORT)" and "assignee = dancil" is redundant. Since you are limiting to a specific user you would not need "assignee in membersOf(IT-SUPPORT)".

[Davin Studer]

I should mention that the above answer is if you are trying to actually save this as a filter in Jira. If you just want to put the JQL into the Jira macro in Confluence then you still need to run it by clicking the  magnifying glass icon before the insert button will be enabled.

[Doug Ancil]

Davin,

Thank you for that answer. I wasn't aware that you needed to run the JQL first. That worked.

[Davin Studer]

Glad that worked. Please remember to mark the question as answered. Thanks.