Merge lp:~nuclearbob/qlbr/rtm-merge into lp:qlbr

[Max Brustkern]

This branch merges the changes we've made for the RTM report into the main branch and adds the RTM view. There are definitely more improvements that could be made (a lot of code is shared between the two views still, for instance,) but I'd like feedback on this as a first draft, and we can figure out whether to improve this further before merging, or try to land it and then make additional improvements as time allows.

I'd like to get things back into lp:qlbr for purposes of juju and mojo deployment.

[lp:~nuclearbob/qlbr/rtm-merge]

133. By Max Brustkern on 2014-10-21

Restored old searches

134. By Max Brustkern on 2014-10-22

calling bug_tags once

135. By Max Brustkern on 2014-10-22

Added some non-display team names

136. By Max Brustkern on 2014-10-22

Enhanced readability

137. By Max Brustkern on 2014-10-22

More view refactoring

138. By Max Brustkern on 2014-10-22

Removed duplicate duplicate handling

139. By Max Brustkern on 2014-10-22

Adding setting for credentials file

140. By Max Brustkern on 2014-10-22

Refined and organized team mapping

141. By Max Brustkern on 2014-10-22

Sorted projects

142. By Max Brustkern on 2014-10-22

Sorted projects

Unmerged revisions

142. By Max Brustkern on 2014-10-22

Sorted projects

141. By Max Brustkern on 2014-10-22

Sorted projects

140. By Max Brustkern on 2014-10-22

Refined and organized team mapping

139. By Max Brustkern on 2014-10-22

Adding setting for credentials file

138. By Max Brustkern on 2014-10-22

Removed duplicate duplicate handling

137. By Max Brustkern on 2014-10-22

More view refactoring

136. By Max Brustkern on 2014-10-22

Enhanced readability

135. By Max Brustkern on 2014-10-22

Added some non-display team names

134. By Max Brustkern on 2014-10-22

calling bug_tags once

133. By Max Brustkern on 2014-10-21

Restored old searches

=== renamed file 'searches.json' => 'qa_searches.json'
=== added file 'qlbr/management/commands/clear_cache.py'
--- qlbr/management/commands/clear_cache.py	1970-01-01 00:00:00 +0000
+++ qlbr/management/commands/clear_cache.py	2014-10-22 15:29:30 +0000
@@ -0,0 +1,28 @@
+# QA Launchpad Bug Reports
+# Copyright 2014 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
+"""Clear the cache.  Mainly intended for charm use."""
+
+from django.core.cache import cache
+from django.core.management.base import BaseCommand
+
+
+class Command(BaseCommand):
+
+    """Clear the cache."""
+
+    def handle(self, *args, **options):
+        """Clear the cache."""
+        cache.clear()

=== added file 'qlbr/management/commands/drop_searches.py'
--- qlbr/management/commands/drop_searches.py	1970-01-01 00:00:00 +0000
+++ qlbr/management/commands/drop_searches.py	2014-10-22 15:29:30 +0000
@@ -0,0 +1,29 @@
+# QA Launchpad Bug Reports
+# Copyright 2014 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
+"""Delete all searches so they can be freshly loaded."""
+
+from django.core.management.base import BaseCommand
+
+from qlbr.models import Search
+
+
+class Command(BaseCommand):
+
+    """Delete all searches so they can be freshly loaded."""
+
+    def handle(self, *args, **options):
+        """Delete all searches so they can be freshly loaded."""
+        Search.objects.all().delete()

=== modified file 'qlbr/management/commands/get_task_data.py'
--- qlbr/management/commands/get_task_data.py	2014-06-04 18:21:24 +0000
+++ qlbr/management/commands/get_task_data.py	2014-10-22 15:29:30 +0000
@@ -17,12 +17,19 @@
 
 import datetime
 import logging
+from optparse import make_option
 
+from django.conf import settings
+from django.core.cache import cache
 from django.core.exceptions import ObjectDoesNotExist
+from django.core.management.base import BaseCommand
+
+from launchpadlib.launchpad import Launchpad
 
 from qlbr import TZ
 from qlbr.management.commands import LaunchpadCommand
 from qlbr.models import Bug, Person, Search, SearchTag, Tag, Task
+from qlbr.settings import CACHEDIR
 
 logger = logging.getLogger(__name__)
 RUN_START = datetime.datetime.now(TZ)
@@ -32,6 +39,20 @@
 
     """Provide data slurping commands."""
 
+    option_list = BaseCommand.option_list + (
+        make_option('--reload',
+                    action='store_true',
+                    dest='reload',
+                    default=False,
+                    help='Reload all task data',
+                    ),
+        make_option('--credentials_file',
+                    action='store',
+                    dest='credentials_file',
+                    help='Credentials file for authenticated LP access.',
+                    ),
+    )
+
     def get_person(self, person_link):
         """Get a person from launchpad if we don't already have it.
 
@@ -50,14 +71,15 @@
             logger.info('Retriveing %s from launchpad', person_link)
         try:
             lp_person = self.lp.load(person_link)
-            d_person = Person(self_link=lp_person.self_link,
-                              web_link=lp_person.web_link,
-                              name=lp_person.name,
-                              display_name=lp_person.display_name)
-            d_person.save()
-            return d_person
         except:
+            logger.error('Could not load %s', person_link)
             return None
+        d_person = Person(self_link=lp_person.self_link,
+                          web_link=lp_person.web_link,
+                          name=lp_person.name,
+                          display_name=lp_person.display_name)
+        d_person.save()
+        return d_person
 
     def get_bug(self, bug_link, duplicate=False):
         """Get a bug from launchpad.  Refresh it if it's stale.
@@ -78,7 +100,11 @@
                 logger.info('Updating %s from launchpad', bug_link)
         except ObjectDoesNotExist:
             logger.info('Retrieving %s from launchpad', bug_link)
-        lp_bug = self.lp.load(bug_link)
+        try:
+            lp_bug = self.lp.load(bug_link)
+        except:
+            logger.error('Could not load %s', bug_link)
+            return None
         d_owner = self.get_person(lp_bug.owner_link)
         d_duplicate_of = self.get_bug(lp_bug.duplicate_of_link, duplicate=True)
         bug_values = {'web_link': lp_bug.web_link,
@@ -96,6 +122,7 @@
                                        **bug_values)
         else:
             d_bug = Bug.objects.get(self_link=lp_bug.self_link)
+        d_bug.tags.clear()
         for tag in lp_bug.tags:
             d_tag, _created = Tag.objects.get_or_create(tag=tag)
             d_bug.tags.add(d_tag)
@@ -131,7 +158,12 @@
         except ObjectDoesNotExist:
             logger.info('Retrieving %s from launchpad', task_link)
         if isinstance(task, basestring):
-            task = self.lp.load(task)
+            try:
+                task = self.lp.load(task)
+            except:
+                logger.error('Could not load %s', task)
+                Task.objects.get(self_link=task).delete()
+                return None
         d_bug = self.get_bug(task.bug_link)
         d_owner = self.get_person(task.owner_link)
         d_assignee = self.get_person(task.assignee_link)
@@ -183,10 +215,17 @@
             criteria.update(search.criteria_dict)
             for project in search.projects.values_list('project', flat=True):
                 logger.info('Searching project: %s', project)
-                lp_project = self.lp.projects[project]
-                for task in lp_project.searchTasks(**criteria):
-                    self.get_task(task, search.search_tags.values_list(
-                        'search_tag', flat=True))
+                try:
+                    lp_project = self.lp.projects[project]
+                    for task in lp_project.searchTasks(**criteria):
+                        self.get_task(task, search.search_tags.values_list(
+                            'search_tag', flat=True))
+                except KeyError as e:
+                    print("Skipping project '%s': %s" % (project, e))
+                    pass
+            if self.reload:
+                for task in Task.objects.values_list('self_link', flat=True):
+                    self.get_task(task)
             search.last_update = RUN_START
             search.save()
 
@@ -196,4 +235,12 @@
             self.reload = True
         else:
             self.reload = False
+        credentials_file = options.get('credentials_file', None)
+        if not credentials_file:
+            credentials_file = settings.CREDENTIALS_FILE
+        if credentials_file:
+            self.lp = Launchpad.login_with(
+                'QA Reports', 'production', CACHEDIR,
+                credentials_file=credentials_file)
         self.search_tasks()
+        cache.clear()

=== modified file 'qlbr/settings.py'
--- qlbr/settings.py	2013-11-26 21:33:14 +0000
+++ qlbr/settings.py	2014-10-22 15:29:30 +0000
@@ -103,7 +103,7 @@
 STATICFILES_FINDERS = (
     'django.contrib.staticfiles.finders.FileSystemFinder',
     'django.contrib.staticfiles.finders.AppDirectoriesFinder',
-    #'django.contrib.staticfiles.finders.DefaultStorageFinder',
+    # 'django.contrib.staticfiles.finders.DefaultStorageFinder',
 )
 
 # Make this unique, and don't share it with anybody.
@@ -113,7 +113,7 @@
 TEMPLATE_LOADERS = (
     'django.template.loaders.filesystem.Loader',
     'django.template.loaders.app_directories.Loader',
-    #'django.template.loaders.eggs.Loader',
+    # 'django.template.loaders.eggs.Loader',
 )
 
 MIDDLEWARE_CLASSES = (
@@ -124,6 +124,8 @@
     'django.contrib.messages.middleware.MessageMiddleware',
     # Uncomment the next line for simple clickjacking protection:
     # 'django.middleware.clickjacking.XFrameOptionsMiddleware',
+    'django.middleware.cache.UpdateCacheMiddleware',
+    'django.middleware.cache.FetchFromCacheMiddleware',
 )
 
 ROOT_URLCONF = 'qlbr.urls'
@@ -186,10 +188,32 @@
 }
 
 # our launchpadlib cache
-CACHEDIR = "/home/ubuntu/.launchpadlib/cache/"
+CACHEDIR = os.path.expanduser("~/.launchpadlib/cache/")
+CREDENTIALS_FILE = os.path.expanduser("~/.launchpadlib/credentials")
+
+# Let's try memcached for caching
+CACHES = {
+    'default': {
+        'BACKEND': 'django.core.cache.backends.dummy.DummyCache',
+    }
+}
+CACHE_MIDDLEWARE_ALIADS = 'qlbr'
+CACHE_MIDDLEWARE_SECONDS = 600
+CACHE_MIDDLEWARE_KEY_PREFIX = ''
+
+# Set the default view so we can override it locally
+DEFAULT_VIEW = 'qa'
 
 # If we have local settings, import 'em
 try:
     from local_settings import *  # noqa
 except ImportError:
     pass
+try:
+    from database_settings import *  # noqa
+except ImportError:
+    pass
+try:
+    from cache_settings import *  # noqa
+except ImportError:
+    pass

=== added file 'qlbr/team_mapping.py'
--- qlbr/team_mapping.py	1970-01-01 00:00:00 +0000
+++ qlbr/team_mapping.py	2014-10-22 15:29:30 +0000
@@ -0,0 +1,169 @@
+# QA Launchpad Bug Reports
+# Copyright 2013 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
+"""Provide team to project mappings."""
+
+__all__ = [
+    'TEAM_MAPPING',
+    'PROJECT_MAPPING',
+    'PROJECT_LIST',
+    'PROJECT_CONFLICTS',
+]
+
+TEAM_MAPPING = {
+    'Unity APIs': (
+        'gounityscopes',
+        'indicatordatetime',
+        'indicatorlocation',
+        'indicatormessages',
+        'indicatornetwork',
+        'indicatorpower',
+        'indicatorsound',
+        'indicatortransfer',
+        'locationservice',
+        'mediascanner',
+        'mediascanner2',
+        'payservice',
+        'payui',
+        'thumbnailer',
+        'unityscopeclick',
+        'unityscopemediascanner',
+        'unityscopesapi',
+        'unityscopesshell',
+        'unityscopevimeo',
+        'unityscopeyoutube',
+        'urldispatcher',
+    ),
+    'Phonedations': (
+        'android',
+        'bluez',
+        'mediahub',
+        'mtp',
+        'networkmanager',
+        'nuntium',
+        'ofono',
+        'platformapi',
+        'powerd',
+        'pulseaudio',
+        'qtcreatorpluginubuntu',
+        'qtubuntucamera',
+        'qtubuntumedia',
+        'ubuntutouchsession',
+    ),
+    'Shell/Mir': (
+        'mir',
+        'qtmir',
+        'qtubuntu',
+        'unity8',
+        'unitymir',
+        'unitysystemcompositor',
+    ),
+    'Apps': (
+        'addressbookapp',
+        'addressbookservice',
+        'cameraapp',
+        'dialerapp',
+        'galleryapp',
+        'maliitframework',
+        'mediaplayerapp',
+        'messagingapp',
+        'notesapp',
+        'oempriority',
+        'qtorganizer5eds',
+        'qtpimopensourcesrc',
+        'syncmonitor',
+        'telepathyofono',
+        'telephonyservice',
+        'ubuntukeyboard',
+        'webbrowserapp',
+    ),
+    'Webapps/OA': (
+        'accountplugins',
+        'accountsservice',
+        'onlineaccounts',
+        'signon',
+        'signonui',
+        'ubuntusystemsettingsonlineaccounts',
+        'unitywebappsqml',
+        'webappscore',
+    ),
+    'Security': (
+        'apparmor',
+        'apparmoreasyprofubuntu',
+        'clickapparmor',
+        'oxide',
+        'oxideqt',
+    ),
+    'Community': (
+        'droppingletters',
+        'musicapp',
+        'remindersapp',
+        'sudokuapp',
+        'ubuntucalculatorapp',
+        'ubuntuclockapp',
+        'ubuntufilemanagerapp',
+        'ubunturssreaderapp',
+        'ubuntuterminalapp',
+        'ubuntuweatherapp',
+    ),
+    'SDK': (
+        'ubuntuuitoolkit',
+    ),
+    'Design': (
+        'ubuntuux',
+    ),
+    'Foundations': (
+        'click',
+        'livecdrootfs',
+    ),
+    'SystemSettings': (
+        'ubuntusystemsettings',
+    ),
+    'Desktop': (
+        'ubuntuonecredentials',
+    ),
+    'OnlineServices': (
+    ),
+    'Barajas': (
+        'barajas',
+    ),
+    'Espoo': (
+        'espoo',
+    ),
+    'Dash Server': (
+        'accountpolld',
+        'curucu',
+        'ubuntupush',
+        'ubuntupushclient',
+        'ubuntupushserver',
+        'ubunturestscopes',
+    ),
+}
+
+PROJECT_MAPPING = {}
+for team in TEAM_MAPPING:
+    for target in TEAM_MAPPING[team]:
+        PROJECT_MAPPING[target] = team
+
+PROJECT_LIST = [target for target in PROJECT_MAPPING]
+
+PROJECT_CONFLICTS = {}
+for target in PROJECT_LIST:
+    for target2 in PROJECT_LIST:
+        if target in target2 and target is not target2:
+            if target in PROJECT_CONFLICTS:
+                PROJECT_CONFLICTS[target].append(target2)
+            else:
+                PROJECT_CONFLICTS[target] = [target2]

=== added file 'qlbr/templates/qlbr/qa-default.html'
--- qlbr/templates/qlbr/qa-default.html	1970-01-01 00:00:00 +0000
+++ qlbr/templates/qlbr/qa-default.html	2014-10-22 15:29:30 +0000
@@ -0,0 +1,448 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-US">
+
+    <head>
+        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+	<title>{{ report_title }}</title>
+
+        <link title="light" rel="stylesheet" href="http://people.canonical.com/~kernel/reports/css/light-style.css" type="text/css" media="print, projection, screen" />
+        <link title="dark"  rel="stylesheet" href="http://people.canonical.com/~kernel/reports/css/dark-style.css" type="text/css" media="print, projection, screen" />
+
+        <script type="text/javascript" src="http://people.canonical.com/~kernel/reports/js/styleswitcher.js"></script>
+
+        <link href='http://fonts.googleapis.com/css?family=Cantarell&subset=latin' rel='stylesheet' type='text/css'>
+        <script type="text/javascript" src="http://people.canonical.com/~kernel/reports/js/jquery-latest.js"></script>
+        <script type="text/javascript" src="http://people.canonical.com/~kernel/reports/js/jquery.tablesorter.js"></script>
+    </head>
+
+    <body class="bugbody">
+        <!-- Top Panel -->
+        <div id="toppanel">
+            <!-- Sliding Panel -->
+            <div id="panel">
+                <form name="filter">
+                <div class="content clearfix">
+                    <table width="100%">
+                        <tr valign="top">
+                            <td valign="top" width="30%">
+                                <p class="l2-section-heading">Importance</p>
+                                <table width="100%">
+                                    <tr><td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" checked value="Critical"  /> Critical  </td>
+                                        <td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" checked value="Low"       /> Low       </td></tr>
+                                    <tr><td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" checked value="High"      /> High      </td>
+                                        <td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" checked value="Wishlist"  /> Wishlist  </td></tr>
+                                    <tr><td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" checked value="Medium"    /> Medium    </td>
+                                        <td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" checked value="Undecided" /> Undecided </td></tr>
+                                </table>
+                            </td>
+
+                            <td width="20">&nbsp;</td>
+
+                            <td valign="top">
+                                <p class="l2-section-heading">Status</p>
+                                <table width="100%">
+                                    <tr><td width="50%"> <input type="checkbox" name="status"     onclick="status_handler(this, 'status', true)" checked value="New"           /> New           </td>
+                                        <td width="50%"> <input type="checkbox" name="status"     onclick="status_handler(this, 'status', true)" checked value="Incomplete"    /> Incomplete    </td></tr>
+                                    <tr><td width="50%"> <input type="checkbox" name="status"     onclick="status_handler(this, 'status', true)" checked value="Confirmed"     /> Confirmed     </td>
+                                        <td width="50%"> <input type="checkbox" name="status"     onclick="status_handler(this, 'status', true)" value="Fix Released"  /> Fix Released  </td></tr>
+                                    <tr><td width="50%"> <input type="checkbox" name="status"     onclick="status_handler(this, 'status', true)" checked value="Triaged"       /> Triaged       </td>
+                                        <td width="50%"> <input type="checkbox" name="status"     onclick="status_handler(this, 'status', true)" value="Won't Fix"     /> Won't Fix     </td></tr>
+                                    <tr><td width="50%"> <input type="checkbox" name="status"     onclick="status_handler(this, 'status', true)" checked value="In Progress"   /> In Progress   </td>
+                                        <td width="50%"> <input type="checkbox" name="status"     onclick="status_handler(this, 'status', true)" value="Opinion"       /> Opinion       </td></tr>
+                                    <tr><td width="50%"> <input type="checkbox" name="status"     onclick="status_handler(this, 'status', true)" checked value="Fix Committed" /> Fix Committed </td>
+                                        <td width="50%"> <input type="checkbox" name="status"     onclick="status_handler(this, 'status', true)" value="Invalid"       /> Invalid       </td></tr>
+                                </table>
+                            </td>
+
+                            <td width="20">&nbsp;</td>
+
+                            <td valign="top" width="30%">
+                                <p class="l2-section-heading">Series</p>
+                                <table width="100%">
+                                    <tr><td width="50%"> <input type="checkbox" name="series"     onclick="series_handler(this, 'series', true)" checked value="raring"   /> Raring   </td>
+                                        <td width="50%"> <input type="checkbox" name="series"     onclick="series_handler(this, 'series', true)" checked value="quantal"  /> Quantal  </td></tr>
+                                    <tr><td width="50%"> <input type="checkbox" name="series"     onclick="series_handler(this, 'series', true)" checked value="precise"  /> Precise  </td>
+                                        <td width="50%"> <input type="checkbox" name="series"     onclick="series_handler(this, 'series', true)" checked value="jaunty"   /> Jaunty   </td></tr>
+                                    <tr><td width="50%"> <input type="checkbox" name="series"     onclick="series_handler(this, 'series', true)" checked value="oneiric"  /> Oneiric  </td>
+                                        <td width="50%"> <input type="checkbox" name="series"     onclick="series_handler(this, 'series', true)" checked value="karmic"   /> Karmic   </td></tr>
+                                    <tr><td width="50%"> <input type="checkbox" name="series"     onclick="series_handler(this, 'series', true)" checked value="natty"    /> Natty    </td>
+                                        <td width="50%"> <input type="checkbox" name="series"     onclick="series_handler(this, 'series', true)" checked value="hardy"    /> Hardy    </td></tr>
+                                    <tr><td width="50%"> <input type="checkbox" name="series"     onclick="series_handler(this, 'series', true)" checked value="maverick" /> Maverick </td>
+                                        <td width="50%"> <input type="checkbox" name="series"     onclick="series_handler(this, 'series', true)" checked value=""         /> Unknown  </td></tr>
+                                    <tr><td width="50%"> <input type="checkbox" name="series"     onclick="series_handler(this, 'series', true)" checked value="lucid"    /> Lucid    </td></tr>
+                                </table>
+                            </td>
+
+                    </table>
+                </div>
+                </form>
+                <div style="clear:both;"></div>
+            </div> <!-- panel -->
+
+            <!-- The tab on top -->
+            <div class="tab">
+                <ul class="login">
+                    <li class="left">&nbsp;</li>
+                    <li id="toggle">
+                        <a id="open" class="open" href="#">&nbsp;Options</a>
+                        <a id="close" style="display: none;" class="close" href="#">&nbsp;Close&nbsp;&nbsp;</a>
+                    </li>
+                    <li class="right">&nbsp;</li>
+                </ul>
+            </div> <!-- / top -->
+        </div> <!-- Top Panel -->
+
+        <div class="outermost">
+            <div class="title">
+                {{ report_title }}
+            </div>
+
+            {% if datefilter %}<div>
+                <form name="datefilter">
+                    <table width="100%">
+                        <tr><td colspan="4">Created within:</td></tr>
+                        <tr><td width="10">&nbsp;</td>
+                            <td width="50"> <input type="radio" name="date"     onclick="date_handler(this, 'date', true)" value="1"    /> 1 Day   </td>
+                            <td width="50"> <input type="radio" name="date"     onclick="date_handler(this, 'date', true)" value="7"    /> 1 Week    </td>
+                            <td width="50"> <input type="radio" name="date"     onclick="date_handler(this, 'date', true)" value="30"   /> 1 Month   </td>
+                            <td width="50"> <input type="radio" name="date"     onclick="date_handler(this, 'date', true)" checked value="-1"   /> Unlimited </td></tr>
+                    </table>
+                </form>
+            </div>{% endif %}
+
+        {% for target_display_name, target in target_report_order %}
+            <div class="section" id="{{ target }}">
+                <div class="section-heading">{{ target_display_name }}</div>
+                    <table id="{{ target }}" class="tablesorter" border="0" cellpadding="0" cellspacing="1" width="100%%">
+                        <thead>
+                            <tr>
+                                <th width="40">Bug</th>
+                                <th>Summary</th>
+                                <th width="80">Importance</th>
+                                <th width="80">Status</th>
+                                <th width="140">Reporter</th>
+                                <th width="140">Assignee</th>
+                                <th width="200">Tags</th>
+                                <th width="140">Created</th>
+                                <th width="65">Duplicate</th>
+                            </tr>
+                        </thead>
+                        <tbody>
+                        </tbody>
+                    </table>
+                </div>
+            {% endfor %}<br />
+            <br />
+            <div>
+                <br />
+                <hr />
+                <table width="100%%" cellspacing="0" cellpadding="0">
+                    <thead>
+                        <tr>
+                            <td width="100">Column</td>
+                            <td>Description</td>
+                        </tr>
+                    </th>
+                    <tbody>
+                        <tr><td>Bug</td><td>The bug number and a link to the Launchpad task.</td></tr>
+                        <tr><td>Summary</td><td>The 'summary' or 'title' from the bug.</td></tr>
+                        <tr><td>Importance</td><td>The bug task's importance.</td></tr>
+                        <tr><td>Status</td><td>The bug task's status.</td></tr>
+                        <tr><td>Reporter</td><td>The person who reported the bug.</td></tr>
+                        <tr><td>Assignee</td><td>The person or team assigned to work on the bug.</td></tr>
+                        <tr><td>Tags/td><td>The tags applied to the bug.</td></tr>
+                        <tr><td>Created</td><td>The date the bug was created.</td></tr>
+                        <tr><td>Duplicate</td><td>The duplicate bug reported by the QA team.</td></tr>
+                    </tbody>
+                </table>
+                <br />
+            </div>
+            <div>
+                <br />
+                <hr />
+                <table width="100%%" cellspacing="0" cellpadding="0">
+                    <tr>
+                        <td>
+                            {{ timestamp }}
+                        </td>
+                        <td align="right">
+                            &nbsp;
+                            Themes:&nbsp;&nbsp;
+                            <a href='#' onclick="setActiveStyleSheet('dark'); return false;">DARK</a>
+                            &nbsp;
+                            <a href='#' onclick="setActiveStyleSheet('light'); return false;">LIGHT</a>
+                        </td>
+                    </tr>
+                </table>
+                <br />
+            </div>
+        </div> <!-- Outermost -->
+    </body>
+
+    <script type="text/javascript">
+       // add parser through the tablesorter addParser method
+       $.tablesorter.addParser({
+           // set a unique id
+           id: 'age',
+           is: function(s) { return false; },
+           format: function(s) {
+               // format your data for normalization
+               fields  = s.split('.')
+               days    = parseInt(fields[0], 10) * (60 * 24);
+               hours   = parseInt(fields[1], 10) * 60;
+               minutes = parseInt(fields[2]);
+               total   = minutes + hours + days
+               return total;
+           },
+           // set type, either numeric or text
+           type: 'numeric'
+       });
+
+       // add parser through the tablesorter addParser method
+       $.tablesorter.addParser({
+           // set a unique id
+           id: 'importance',
+           is: function(s) { return false; },
+           format: function(s) {
+               // format your data for normalization
+               return s.toLowerCase().replace(/critical/,6).replace(/high/,5).replace(/medium/,4).replace(/low/,3).replace(/wishlist/,2).replace(/undecided/,1).replace(/unknown/,0);
+           },
+           // set type, either numeric or text
+           type: 'numeric'
+       });
+
+       // add parser through the tablesorter addParser method
+       $.tablesorter.addParser({
+           // set a unique id
+           id: 'status',
+           is: function(s) { return false; },
+           format: function(s) {
+               // format your data for normalization
+               return s.toLowerCase().replace(/new/,12).replace(/incomplete/,11).replace(/confirmed/,10).replace(/triaged/,9).replace(/in progress/,8).replace(/fix committed/,7).replace(/fix released/,6).replace(/invalid/,5).replace(/won't fix/,4).replace(/confirmed/,3).replace(/opinion/,2).replace(/expired/,1).replace(/unknown/,0);
+           },
+           // set type, either numeric or text
+           type: 'numeric'
+       });
+       $(function() {
+                {% for _target_display_name, target in target_report_order %}
+                $("#{{ target }}").tablesorter({
+                    headers: {
+                        3: {
+                            sorter:'importance'
+                        },
+                        4: {
+                            sorter:'status'
+                        }
+                    },
+                    widgets: ['zebra']
+                });
+                {% endfor %}
+        });
+    </script>
+
+    <script type="text/javascript">
+        var series = ["raring", "quantal", "precise", "jaunty", "oneiric", "karmic", "natty", "hardy", "maverick", "lucid", ""];
+        var importance = ["Critical", "Low", "High", "Wishlist", "Medium", "Undecided"];
+        var task_status = ["New", "Incomplete", "Confirmed", "Fix Released", "Triaged", "Won't Fix", "In Progress", "Opinion", "Fix Committed", "Invalid"];
+        var assignees = [];
+        var date_filter = -1;
+        var jd = {% autoescape off %}{{ tasks_json_dump }}{% endautoescape %};
+        var first_time = true;
+
+        var importance_color = {
+                "Unknown"       : "importance-unknown",
+                "Critical"      : "importance-critical",
+                "High"          : "importance-high",
+                "Medium"        : "importance-medium",
+                "Low"           : "importance-low",
+                "Wishlist"      : "importance-wishlist",
+                "Undecided"     : "importance-undecided"
+            };
+
+        var status_color = {
+                "New"           : "status-new",
+                "Incomplete"    : "status-incomplete",
+                "Confirmed"     : "status-confirmed",
+                "Triaged"       : "status-triaged",
+                "In Progress"   : "status-in_progress",
+                "Fix Committed" : "status-fix_committed",
+                "Fix Released"  : "status-fix_released",
+                "Invalid"       : "status-invalid",
+                "Won't Fix"     : "status-wont_fix",
+                "Opinion"       : "status-opinion",
+                "Expired"       : "status-expired",
+                "Unknown"       : "status-unknown"
+            };
+
+        var targets_id_list = [];
+        var targets_name_list = [];
+            {% for _target_display_name, target in target_report_order %}targets_id_list.push("{{ target }}");
+            targets_name_list.push("{{ target }}");
+            {% endfor %}
+
+        function series_handler(chkbx, grp, update_table) {
+            series = [];
+            for (i = 0; i < document.filter.length; i++) {
+                if (document.filter[i].name == "series") {
+                    if (document.filter[i].checked) {
+                        series.push(document.filter[i].value);
+                    }
+                }
+            }
+
+            if (update_table) {
+                update_tables();
+            }
+        }
+
+        function importance_handler(chkbx, grp, update_table) {
+            importance = [];
+            for (i = 0; i < document.filter.length; i++) {
+                if (document.filter[i].name == "importance") {
+                    if (document.filter[i].checked) {
+                        importance.push(document.filter[i].value);
+                    }
+                }
+            }
+
+            if (update_table) {
+                update_tables();
+            }
+        }
+
+        function assignee_handler(chkbx, grp, update_table) {
+            assignees = [];
+            for (i = 0; i < document.filter.length; i++) {
+                if (document.filter[i].name == "assignees") {
+                    if (document.filter[i].checked) {
+                        assignees.push(document.filter[i].value);
+                    }
+                }
+            }
+
+            if (update_table) {
+                update_tables();
+            }
+        }
+
+        function status_handler(chkbx, grp, update_table) {
+            task_status = [];
+            for (i = 0; i < document.filter.length; i++) {
+                if (document.filter[i].name == "status") {
+                    if (document.filter[i].checked) {
+                        task_status.push(document.filter[i].value);
+                    }
+                }
+            }
+
+            if (update_table) {
+                update_tables();
+            }
+        }
+
+        function date_handler(chkbx, grp, update_table) {
+            date_filter = -1;
+            for (i = 0; i < document.datefilter.length; i++) {
+                if (document.datefilter[i].name == "date") {
+                    if (document.datefilter[i].checked) {
+                        date_filter = parseInt(document.datefilter[i].value);
+                    }
+                }
+            }
+
+            if (update_table) {
+                update_tables();
+            }
+        }
+
+        function update_tables() {
+            var tables = {
+                {% for _target_display_name, target in target_report_order %}"{{ target }}" : false,
+                {% endfor %}};
+
+            var oddness = {
+                {% for _target_display_name, target in target_report_order %}"{{ target }}" : true,
+                {% endfor %}};
+
+            $.each(jd, function(bid, tasks) {
+                $.each(tasks, function(index, task) {
+                    var fail = false;
+
+                    if (!fail && importance.indexOf(task.importance) == -1) {
+                        fail = true;
+                    }
+
+                    if (!fail && task_status.indexOf(task.status) == -1) {
+                        fail = true;
+                    }
+
+{% if datefilter %}
+                    if (!fail && date_filter != -1) {
+                        if (task.age > date_filter) {
+                            fail = true;
+                        }
+                    }
+{% endif %}
+                    s = "";
+                    if (!fail) {
+                        if (oddness[task.target]) {
+                            s += "<tr class=\"odd\">";
+                            oddness[task.target] = false;
+                        } else {
+                            s += "<tr class=\"even\">";
+                            oddness[task.target] = true;
+                        }
+                        s += "<td><a href=\"" + task.web_link + "\">" + bid + "</a></td>";
+                        s += "<td>" + task.title + "</td>";
+                        s += "<td class=\"" + importance_color[task.importance] + "\">" + task.importance + "</td>";
+                        s += "<td class=\"" + status_color[task.status] + "\">" + task.status + "</td>";
+                        s += "<td>" + task.owner + "</td>";
+                        s += "<td>" + task.assignee + "</td>";
+                        s += "<td>" + task.taglist + "</td>";
+                        s += "<td>" + task.date_created + "</td>";
+                        s += "<td>" + task.duplicate_link + "</td>";
+                        s += "</tr>";
+                        tables[task.target] += s;
+                    }
+                });
+            });
+
+            $.each(tables, function(target, val) {
+                if (tables[target]) {
+                    $("#" + target + " tbody").html(tables[target]);
+                    $("#" + target).show()
+                    $("#" + target).trigger("update");
+                } else {
+                    $("#" + target).hide()
+                    $("#" + target).trigger("update");
+                }
+            });
+            if (first_time) {
+                first_time = false;
+                sortList = [[3,1], [4,1]];
+                $.each(tables, function(target, val) {
+                    $("#" + target).trigger("sorton", [sortList]);
+                });
+            }
+        }
+
+        $(document).ready(function(){
+            // Expand Panel
+            $("#open").click(function(){ $("div#panel").slideDown("slow"); });
+
+            // Collapse Panel
+            $("#close").click(function(){ $("div#panel").slideUp("slow"); });
+
+            // Switch buttons on the tab from "Options" to "Close"
+            $("#toggle a").click(function () { $("#toggle a").toggle(); });
+
+            series_handler(null, null, false);
+            importance_handler(null, null, false);
+            status_handler(null, null, false);
+            {% if datefilter %}date_handler(null, null, false);
+            {% endif %}update_tables();
+        });
+    </script>
+
+</html>
+<!-- vi:set ts=4 sw=4 expandtab syntax=django: -->

=== renamed file 'qlbr/templates/qlbr/qa-default.html' => 'qlbr/templates/qlbr/rtm.html'
--- qlbr/templates/qlbr/qa-default.html	2013-11-20 15:39:37 +0000
+++ qlbr/templates/qlbr/rtm.html	2014-10-22 15:29:30 +0000
@@ -13,6 +13,7 @@
         <link href='http://fonts.googleapis.com/css?family=Cantarell&subset=latin' rel='stylesheet' type='text/css'>
         <script type="text/javascript" src="http://people.canonical.com/~kernel/reports/js/jquery-latest.js"></script>
         <script type="text/javascript" src="http://people.canonical.com/~kernel/reports/js/jquery.tablesorter.js"></script>
+        <script src="http://yui.yahooapis.com/3.4.1/build/yui/yui-min.js"></script>
     </head>
 
     <body class="bugbody">
@@ -28,11 +29,11 @@
                                 <p class="l2-section-heading">Importance</p>
                                 <table width="100%">
                                     <tr><td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" checked value="Critical"  /> Critical  </td>
-                                        <td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" checked value="Low"       /> Low       </td></tr>
+                                        <td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" value="Low"       /> Low       </td></tr>
                                     <tr><td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" checked value="High"      /> High      </td>
-                                        <td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" checked value="Wishlist"  /> Wishlist  </td></tr>
-                                    <tr><td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" checked value="Medium"    /> Medium    </td>
-                                        <td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" checked value="Undecided" /> Undecided </td></tr>
+                                        <td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" value="Wishlist"  /> Wishlist  </td></tr>
+                                    <tr><td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" value="Medium"    /> Medium    </td>
+                                        <td width="50%"> <input type="checkbox" name="importance" onclick="importance_handler(this, 'importance', true)" value="Undecided" /> Undecided </td></tr>
                                 </table>
                             </td>
 
@@ -110,21 +111,21 @@
                 </form>
             </div>{% endif %}
 
-        {% for target_display_name, target in target_report_order %}
+        {% for target_display_name, target, total, critical, high in target_report_order %}
             <div class="section" id="{{ target }}">
-                <div class="section-heading">{{ target_display_name }}</div>
+		    <div class="section-heading">{{ target_display_name }} (Total: {{ total }} Critical: {{ critical }} High: {{ high }})</div>
                     <table id="{{ target }}" class="tablesorter" border="0" cellpadding="0" cellspacing="1" width="100%%">
                         <thead>
                             <tr>
-                                <th width="40">Bug</th>
-                                <th>Summary</th>
-                                <th width="80">Importance</th>
-                                <th width="80">Status</th>
-                                <th width="140">Reporter</th>
-                                <th width="140">Assignee</th>
-                                <th width="200">Tags</th>
-                                <th width="140">Created</th>
-                                <th width="65">Duplicate</th>
+                                <th class=header width="40">Bug</th>
+                                <th class=header width="600">Summary</th>
+                                <th class=header width="80">Importance</th>
+                                <th class=header width="80">Status</th>
+                                <th class=header width="140">Reporter</th>
+                                <th class=header width="140">Assignee</th>
+                                <th class=header width="200">Tags</th>
+                                <th class=header width="140">Created</th>
+                                <th class=header width="65">Duplicate</th>
                             </tr>
                         </thead>
                         <tbody>

=== modified file 'qlbr/urls.py'
--- qlbr/urls.py	2013-12-03 20:12:05 +0000
+++ qlbr/urls.py	2014-10-22 15:29:30 +0000
@@ -17,6 +17,7 @@
 
 import datetime
 
+from django.conf import settings
 from django.conf.urls import patterns, include, url
 
 from django.contrib import admin
@@ -24,9 +25,12 @@
 
 urlpatterns = patterns(
     '',
-    url(r'^$', 'qlbr.views.index', name='index'),
-    url(r'^untriaged$', 'qlbr.views.index', {'triaged': False}, name='index'),
-    url(r'^today$', 'qlbr.views.index', {'task_filter':
+    url(r'^$', 'qlbr.views.{}'.format(settings.DEFAULT_VIEW),
+        name=settings.DEFAULT_VIEW),
+    url(r'^qa/$', 'qlbr.views.qa', name='qa'),
+    url(r'^rtm/$', 'qlbr.views.rtm', name='rtm'),
+    url(r'^untriaged$', 'qlbr.views.qa', {'triaged': False}, name='qa'),
+    url(r'^today$', 'qlbr.views.qa', {'task_filter':
         {'bug__date_last_updated__gt':
         datetime.datetime.now()-datetime.timedelta(1)}}),
     url(r'^admin/doc/', include('django.contrib.admindocs.urls')),

=== modified file 'qlbr/views.py'
--- qlbr/views.py	2014-06-04 18:42:23 +0000
+++ qlbr/views.py	2014-10-22 15:29:30 +0000
@@ -19,13 +19,78 @@
 import json
 import re
 
+from django.http import HttpResponse
 from django.shortcuts import render
 
 from qlbr import TZ
 from qlbr.models import Task
-
-
-def index(request, task_filter=None, triaged=None):
+from qlbr.team_mapping import (
+    TEAM_MAPPING,
+    PROJECT_MAPPING,
+)
+
+OPEN_STATUSES = [
+    'New',
+    'Confirmed',
+    'Triaged',
+    'In Progress',
+    'Fix Committed',
+    'Incomplete',
+]
+
+
+def bug_tags():
+    bug_tags = {}
+    for bug, tag in Task.objects.distinct().values_list('bug__bug_id',
+                                                        'bug__tags'):
+        if bug in bug_tags:
+            bug_tags[bug] += ' '
+            bug_tags[bug] += tag
+        else:
+            bug_tags[bug] = tag
+    return bug_tags
+
+
+BUG_TAGS = bug_tags()
+
+
+def task_data(task, bug_tags=BUG_TAGS, triaged=False):
+    data = {
+        'title': task.bug.title,
+        'date_created': task.date_created.isoformat(),
+        'age': (datetime.datetime.now(TZ) - task.date_created).days,
+        'importance': task.importance,
+        'status': task.status,
+        'web_link': task.web_link,
+        'duplicate_link': '',
+        'owner': task.owner.display_name,
+    }
+
+    # Pilfered from collect-bug-data in lp:arsenal
+    m = re.search('(\S+)\s\(.*\)', task.bug_target_name)
+    if m is not None:
+        data['target'] = m.group(1)
+    else:
+        data['target'] = task.bug_target_name
+    m = re.search('(\S+)\s\(.*\)', task.bug_target_display_name)
+    if m is not None:
+        data['target_display_name'] = m.group(1)
+    else:
+        data['target_display_name'] = task.bug_target_display_name
+
+    if triaged:
+        data['triaged'] = task.triaged
+    if task.bug.duplicate_of:
+        data.update(task_data(task.bug.duplicate_of.task_set.first(),
+                              bug_tags))
+        data['duplicate_link'] = '<a href="{}">{}</a>'.format(task.web_link,
+                                                              task.bug.bug_id)
+    data['taglist'] = bug_tags[task.bug.bug_id]
+    data['original_target_display_name'] = task.bug_target_display_name,
+    return data
+
+
+def qa(request, task_filter=None, triaged=None):
     """Main view of all bugs.
 
     :returns: view of all bugs
@@ -39,42 +104,10 @@
         task_iterator = Task.objects.filter(**task_filter).iterator()
     for task in task_iterator:
         bugid = task.bug.bug_id
-        report_task = {
-            'title': task.bug.title,
-            'taglist': task.bug.tag_list,
-            'date_created': task.date_created.isoformat(),
-            'age': (datetime.datetime.now(TZ) - task.date_created).days,
-            'importance': task.importance,
-            'status': task.status,
-            'web_link': task.web_link,
-            'duplicate_link': '',
-            'owner': task.owner.display_name,
-            'triaged': task.triaged
-        }
+        report_task = task_data(task)
         if triaged is not None:
             if task.triaged != triaged:
                 continue
-        dupe_of = task.bug.duplicate_of
-        if dupe_of:
-            report_task['duplicate_link'] = ('<a href="{}">{}</a>'
-                                             .format(task.web_link, bugid))
-            report_task['owner'] += ' (dup)'
-            bugid = dupe_of.bug_id
-            report_task['web_link'] = dupe_of.web_link
-            report_task['triaged'] = dupe_of.triaged
-            report_task['status'] = dupe_of.task_set.first().status
-
-        # Pilfered from collect-bug-data in lp:arsenal
-        m = re.search('(\S+)\s\(.*\)', task.bug_target_name)
-        if m is not None:
-            report_task['target'] = m.group(1)
-        else:
-            report_task['target'] = task.bug_target_name
-        m = re.search('(\S+)\s\(.*\)', task.bug_target_display_name)
-        if m is not None:
-            report_task['target_display_name'] = m.group(1)
-        else:
-            report_task['target_display_name'] = task.bug_target_display_name
 
         report_task['target'] = report_task['target'].replace('.', '')
         if task.assignee:
@@ -105,3 +138,86 @@
                'target_report_order': target_report_order,
                'tasks_json_dump': tasks_json_dump}
     return render(request, 'qlbr/qa-default.html', context)
+
+
+def rtm(request, task_filter=None):
+    """RTM bug report.
+
+    :returns: RTM bugs view
+    :rtype" HttpResponse
+
+    """
+    tasks = {}
+    task_objects = Task.objects.select_related(
+        'owner__display_name',
+        'assignee__display_name',
+        'bug__duplicate_of',
+    )
+    if task_filter:
+        task_objects = task_objects.filter(**task_filter)
+    task_objects = task_objects.filter(bug__tags__tag='rtm14')
+    if 'tag' in request.REQUEST:
+        for tag in request.REQUEST['tag'].split():
+            task_objects = task_objects.filter(bug__tags__tag=tag)
+    task_iterator = task_objects.iterator()
+    for task in task_iterator:
+        bugid = task.bug.bug_id
+        report_task = task_data(task)
+        if task.assignee:
+            report_task['assignee'] = task.assignee.display_name
+        else:
+            report_task['assignee'] = 'Unassigned'
+        if bugid not in tasks:
+            tasks[bugid] = []
+
+        target = report_task['target'].replace(' (Ubuntu)', '')
+        target = target.replace(' ', '').replace('-', '')
+        target = target.lower()
+        if target in PROJECT_MAPPING:
+            team = PROJECT_MAPPING[target]
+        else:
+            team = 'Other'
+        report_task['target'] = team.replace(' ', '').replace('/', '')
+        tasks[bugid].append(report_task)
+        targets = {task['target'] for task in tasks[bugid]}
+        if 'Other' in targets and targets != {'Other'}:
+            task_list = list(
+                filter(lambda t: t['target'] != 'Other', tasks[bugid]))
+            if any(task['status'] in OPEN_STATUSES and
+                   task['target'] != 'Other' for task in task_list):
+                tasks[bugid] = task_list
+
+    team_stats = {'Other': ['Other', 'Other', 0, 0, 0]}
+    for team in TEAM_MAPPING:
+        team_sanitized = team.replace(' ', '').replace('/', '')
+        team_stats[team_sanitized] = [
+            team,
+            team_sanitized,
+            0,
+            0,
+            0,
+        ]
+    for bug_id in tasks:
+        for task in tasks[bug_id]:
+            if task['status'] in OPEN_STATUSES:
+                team = task['target']
+                team_stats[team][2] += 1
+                if task['importance'] == 'Critical':
+                    team_stats[team][3] += 1
+                if task['importance'] == 'High':
+                    team_stats[team][4] += 1
+
+    team_report_order = []
+    for team in sorted(list(team_stats)):
+        team_report_order.append(team_stats[team])
+    tasks_json_dump = json.dumps(tasks, sort_keys=True, indent=4)
+    context = {'report_title': 'RTM Bugs',
+               'tasks': tasks,
+               'timestamp': datetime.datetime.now().isoformat(),
+               'datefilter': True,
+               'target_report_order': team_report_order,
+               'tasks_json_dump': tasks_json_dump}
+    if 'json' in request.REQUEST:
+        return HttpResponse(tasks_json_dump, mimetype='application/json')
+    else:
+        return render(request, 'qlbr/rtm.html', context)

=== added file 'rtm_searches.json'
--- rtm_searches.json	1970-01-01 00:00:00 +0000
+++ rtm_searches.json	2014-10-22 15:29:30 +0000
@@ -0,0 +1,111 @@
+[
+    {
+        "name": "RTM14", 
+        "search_tags": [], 
+        "projects": [
+            "ubuntu",
+	    "account-plugins",
+	    "account-polld",
+	    "accountsservice",
+	    "address-book-app",
+	    "address-book-service",
+	    "android",
+	    "apparmor",
+	    "apparmor-easyprof-ubuntu",
+	    "barajas",
+	    "bluez",
+	    "camera-app",
+	    "click",
+	    "click-apparmor",
+	    "curucu",
+	    "dialer-app",
+	    "dropping-letters",
+	    "espoo",
+	    "gallery-app",
+	    "go-unityscopes",
+	    "indicator-datetime",
+	    "indicator-location",
+	    "indicator-messages",
+	    "indicator-network",
+	    "indicator-power",
+	    "indicator-sound",
+	    "indicator-transfer",
+	    "livecd-rootfs",
+	    "location-service",
+	    "maliit-framework",
+	    "media-hub",
+	    "mediaplayer-app",
+	    "mediascanner",
+	    "mediascanner2",
+	    "messaging-app",
+	    "mir",
+	    "mtp",
+	    "music-app",
+	    "network-manager",
+	    "notes-app",
+	    "nuntium",
+	    "oem-priority",
+	    "ofono",
+	    "online-accounts",
+	    "oxide",
+	    "oxide-qt",
+	    "pay-service",
+	    "pay-ui",
+	    "platform-api",
+	    "powerd",
+	    "pulseaudio",
+	    "qtcreator-plugin-ubuntu",
+	    "qtmir",
+	    "qtorganizer5-eds",
+	    "qtpim-opensource-src",
+	    "qtubuntu",
+	    "qtubuntu-camera",
+	    "qtubuntu-media",
+	    "reminders-app",
+	    "signon",
+	    "signon-ui",
+	    "sudoku-app",
+	    "sync-monitor",
+	    "telepathy-ofono",
+	    "telephony-service",
+	    "thumbnailer",
+	    "ubuntu-calculator-app",
+	    "ubuntu-clock-app",
+	    "ubuntu-filemanager-app",
+	    "ubuntu-keyboard",
+	    "ubuntu-push",
+	    "ubuntu-push-client",
+	    "ubuntu-push-server",
+	    "ubuntu-rest-scopes",
+	    "ubuntu-rssreader-app",
+	    "ubuntu-system-settings",
+	    "ubuntu-system-settings-online-accounts",
+	    "ubuntu-terminal-app",
+	    "ubuntu-touch-session",
+	    "ubuntu-translations",
+	    "ubuntu-ui-toolkit",
+	    "ubuntu-ux",
+	    "ubuntu-weather-app",
+	    "ubuntudeveloperportal",
+	    "ubuntuone-credentials",
+	    "unity-mir",
+	    "unity-scope-click",
+	    "unity-scope-mediascanner",
+	    "unity-scope-vimeo",
+	    "unity-scope-youtube",
+	    "unity-scopes-api",
+	    "unity-scopes-shell",
+	    "unity-system-compositor",
+	    "unity-webapps-qml",
+	    "unity8",
+	    "url-dispatcher",
+	    "webapps-core",
+	    "webbrowser-app"
+        ], 
+        "criteria": {
+            "tags": [
+                "rtm14"
+            ]
+        } 
+    } 
+]