Bug 1663334

I tried to look at how it was handled for the Systems view. It's more complex there because the Updates column display is in the SystemListHelper.setSystemStatusDisplay property. The base SQL query for the System list also primarily pulls key information, but it also includes elaborator queries that populate the other fields for each row in the SystemOverview list

<mode name="visible_to_user" class="com.redhat.rhn.frontend.dto.SystemOverview">
  <query name="available_to_user" />
  <elaborator name="system_overview" />
  <elaborator name="system_config_files_with_diffs" />
  <elaborator name="entitlements"/>
  <elaborator name="is_virtual_guest" />
  <elaborator name="is_virtual_host" />
</mode>

<query name="system_overview" params="">
  SELECT SERVER_ID AS ID, OUTDATED_PACKAGES, SERVER_NAME, security_errata, bug_errata, enhancement_errata,
          SERVER_ADMINS, GROUP_COUNT, MODIFIED, CHANNEL_LABELS, CHANNEL_ID, HISTORY_COUNT,
          unique_crash_count, total_crash_count, LAST_CHECKIN_DAYS_AGO, PENDING_UPDATES, OS, RELEASE,
          SERVER_ARCH_NAME, LAST_CHECKIN, LOCKED
  FROM  rhnServerOverview
  WHERE  server_id IN (%s)
ORDER BY  UPPER(COALESCE(SERVER_NAME, '(none)')), SERVER_ID
</query>



So rather than try to modify the existing query for the SystemGroupOverview "visible_to_user_and_counts" mode, it probably makes more sense to populate the mostSevereErrata property of dto.SystemGroupOverview with a decorator query for that mode as well. Something like 

<query name="system_group_overview" params="">
 SELECT GROUP_ID AS ID, GROUP_NAME, GROUP_ADMINS,
        CASE
            WHEN security_errata > 0 THEN 'Security Advisory'
            WHEN bug_errata > 0 THEN 'Bug Fix Advisory'
            WHEN enhancement_errata > 0 THEN 'Product Enhancement Advisory'
            ELSE ''
        END AS "mostSevereErrata"
      FROM rhnServerGroupOverview
      WHERE group_id IN (%s)
      ORDER BY UPPER(GROUP_NAME)
</query>

Woops I meant an elaborator query, not a decroator query. The mode would also need to be modified to add the elaborator query. I'm guessing that it also would no longer need the ORDER By clause if it's in the elaborator.

<mode name="visible_to_user_and_counts" class="com.redhat.rhn.frontend.dto.SystemGroupOverview">
  <query params="user_id">
    SELECT SG.id AS ID, SG.name AS NAME,
       (SELECT COUNT(*)
          FROM rhnServerGroupMembers SGM WHERE SGM.server_group_id = SG.id
           AND EXISTS (SELECT 1
                         FROM rhnServerFeaturesView SFV
                        WHERE SFV.server_id = SGM.server_id
                          AND SFV.label = 'ftr_system_grouping')) AS SERVER_COUNT
      FROM rhnServerGroup SG, rhnUserManagedServerGroups UMSG
     WHERE UMSG.user_id = :user_id
       AND UMSG.server_group_id = SG.id
       AND SG.group_type IS NULL
  </query>
  <elaborator name="system_group_overview" />
</mode>

Hi,

We have the same issue after we migrate Spacewalk to 2.8 in Redhat 7. Could anyone please advice if there is any fix on it.

Thanks
Sushant

Hello,

Same here on Spacewalk 2.9, but just in the System Groups page (Overview page is fine).

Any thoughts?

Regards,

Ranmsés.

Fixed by https://github.com/spacewalkproject/spacewalk/pull/700

commit a5010b34234bea6c56335d05fa126c3dfe2a028c
    Fix to display right errata status in System Group view

Spacewalk 2.10 has been released.
https://github.com/spacewalkproject/spacewalk/wiki/ReleaseNotes210