Re: [Spacewalk-devel] Query question regarding system.listLatestUpgradeablePackages

2014-02-27 Thread Jeremy D Davis
...@redhat.com] On Behalf Of Jeremy D Davis Sent: Friday, February 21, 2014 9:49 AM To: spacewalk-devel@redhat.com Subject: Re: [Spacewalk-devel] Query question regarding system.listLatestUpgradeablePackages Michael, I have two child channels that have the same package but different checksum. Meaning we

Re: [Spacewalk-devel] Query question regarding system.listLatestUpgradeablePackages

2014-02-21 Thread Jeremy D Davis
this issue of displaying both packages as it restricts the search to only the channels assigned to the server. Regards, Jeremy Jeremy D Davis wrote: % Michael, % % I was able to get it working by manually changing the % rhnServerOutdatedPackages.sql to include the arch in the select and % then

Re: [Spacewalk-devel] Query question regarding system.listLatestUpgradeablePackages

2014-02-20 Thread Jeremy D Davis
deploy this without having to remove a table. Regards, Jeremy -Original Message- From: spacewalk-devel-boun...@redhat.com [mailto:spacewalk-devel-boun...@redhat.com] On Behalf Of Jeremy D Davis Sent: Thursday, February 20, 2014 10:37 AM To: spacewalk-devel@redhat.com Subject: Re: [Spacewalk

Re: [Spacewalk-devel] Query question regarding system.listLatestUpgradeablePackages

2014-02-20 Thread Jeremy D Davis
t.com] On Behalf Of Michael Mraka Sent: Thursday, February 20, 2014 4:05 AM To: spacewalk-devel@redhat.com Subject: Re: [Spacewalk-devel] Query question regarding system.listLatestUpgradeablePackages Jeremy D Davis wrote: % Attached you will find the patch as per the documentation %

Re: [Spacewalk-devel] Query question regarding system.listLatestUpgradeablePackages

2014-02-13 Thread Jeremy D Davis
Attached you will find the patch as per the documentation https://fedorahosted.org/spacewalk/wiki/GitGuide . Sorry about all the emails and not following documentation. From: spacewalk-devel-boun...@redhat.com [mailto:spacewalk-devel-boun...@redhat.com] On Behalf Of Jeremy D Davis Sent

Re: [Spacewalk-devel] Query question regarding system.listLatestUpgradeablePackages

2014-02-13 Thread Jeremy D Davis
D puac.package_upgrade_arch_id = up.arch_id AND sp.evr < up.evr AND sp.name_id = up.name_id Thank you for your time and have a great day! Regards, Jeremy From: spacewalk-devel-boun...@redhat.com [mailto:spacewalk-devel-boun...@redhat.com] On Behalf Of Jeremy D Davis Sent: Wedn

[Spacewalk-devel] Query question regarding system.listLatestUpgradeablePackages

2014-02-12 Thread Jeremy D Davis
Hello Spacewalk Developers, I was looking at Package_queries.xml and discovered that the following query is being used to pull a list of packages that need to be installed on the server that are being displayed on the Web UI as needing updated. The reason for pulling this query is that we have