> On 9 Jun 2017, at 17:56, Vincent Massol <[email protected]> wrote:
>
> Hi devs,
>
> Almost all our filters on jira.xwiki.org were wrong (all bugs for xwiki
> committers, all issues for xwiki committers, etc) because they were only
> filtering on the “top level” category (id = 10000) and thus were forgetting
> the contrib extensions that we bundled in XE.
>
> Thus I’ve renamed the "top level projects” category into “XWiki Enterprise”
> (and soon we’ll rename it with the name of the flavor replacing it). I’ve
> also moved the conrib extensions that we bundled into that category. See
> https://jira.xwiki.org/secure/Dashboard.jspa?selectPageId=10000
>
> As a consequence this fixed
> https://jira.xwiki.org/secure/Dashboard.jspa?selectPageId=10352 for example,
> which is now correct.
>
> However this leads to a problem: All JQL we wrote that were using things like
> “category in (“Top Level Projects”)” instead of “category = 10000” are now
> broken. For example we use this in our Relaese Notes for bug fix releases.
> I’ve fixed all of them using the Release Application but not old ones yet.
>
> Also, in our RN for bug fix releases we need to specify all projects one by
> one along with versions. Writing the following (as can be seen in
> http://www.xwiki.org/xwiki/bin/edit/ReleaseNotes/Data/XWiki/9.3.1/WebHome?editor=wiki)
> is wrong for example:
>
> category = 10000 AND fixVersion in ("9.3.1") AND resolution in (Fixed) and
> component not in ("Development Issues only”)
>
> FTR in the RN for 8.4.2 I wrote:
>
> category = 10000 and fixVersion = "8.4.2" and resolution = Fixed and
> component != "Development Issues only" OR project = "CKEditor Integration"
> and fixVersion = "1.10" and resolution = Fixed OR project = "Tour
> Application" and fixVersion = "1.1" and resolution = Fixed
>
> But even that is not correct anymore and we now need to write instead:
>
> project IN ("XCOMMONS", "XRENDERING", "XWIKI", "XE") AND fixVersion = "8.4.2"
> AND resolution = Fixed and component != "Development Issues only" OR project
> = "CKEDITOR" AND fixVersion = "1.10" AND resolution = Fixed OR project =
> "TOUR" AND fixVersion = "1.1" AND resolution = Fixed
Seems this wasn’t clear so here’s the rule:
* If you're writing a filter that filters on versions you need to specify each
project and the version you’re filtering on for this project. As with: "project
IN ("XCOMMONS", "XRENDERING", "XWIKI", "XE") AND fixVersion = "8.4.2" AND
resolution = Fixed and component != "Development Issues only" OR project =
"CKEDITOR" AND fixVersion = "1.10" AND resolution = Fixed OR project = "TOUR"
AND fixVersion = "1.1" AND resolution = Fixed”
* If you’re writing a filter that doesn’t filter on versions you can use the
category. For example to list all open bugs for the xwiki core committers you’d
write: "category = 10000 AND issuetype = Bug AND status in (Open, "In
Progress", Reopened) ORDER BY key DESC”
Hope it’s more clear.
Thanks
-Vincent
>
> So we need to review:
> * The filters and dashboard in jira.xwiki.org and fix them (for example GD,
> in the RN for 9.4 we point to
> https://jira.xwiki.org/secure/Dashboard.jspa?selectPageId=13894 which is
> broken now since its filter uses “Top Level Projects” but I can’t fix it
> since I don’t own it in jira…)
> * The JQL statements used in xwiki.org and especially in the RNs. We should
> probably create some scripts/tools to help us write those JQL.
>
> Any comment? Any other idea?
>
> Thanks
> -Vincent
>
