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

2014-02-28 Thread Michael Mraka
Jeremy D Davis wrote: % Any updates as to if we can get my latest patch that removes duplicate packages from the output into 2.1? Or should I submit a pull request in the new github? Hi Jeremy, I've applied you fix both to master and SPACEWALK-2.1. It took a bit long because we are busy with

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 Michael Mraka
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 remove the table from Spacewalk and run the query. Once I got % that fixed I was able to test the queries you updated. It seem in

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

2014-02-21 Thread Jeremy D Davis
Michael, I have two child channels that have the same package but different checksum. Meaning we have cloudlinux rpms which use the same package name, version, release and arch but a different checksum. So for example bind-libs-9.8.2-0.23.rc1.el6_5.1.x86_64.rpm - Is in the updates channel.

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

2014-02-20 Thread Michael Mraka
Jeremy D Davis wrote: % 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. ... % Hello Spacewalk Developers, % % After asking the last question I decided to go ahead and make

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

2014-02-20 Thread Jeremy D Davis
] 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 % https

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

2014-02-20 Thread Jeremy D Davis
-devel-boun...@redhat.com [mailto:spacewalk-devel-boun...@redhat.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

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

2014-02-14 Thread Silvio Moioli
On 02/13/2014 05:43 AM, Jeremy D Davis wrote: My question is why use this really big query when you could use a select * from rhnserverneededcache where serverid=x and pull all the packages that way. Granted you would need to do some joins to get the correct names based on the package id but

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

2014-02-13 Thread Jeremy D Davis
Davis Sent: Wednesday, February 12, 2014 9:44 PM To: spacewalk-devel@redhat.com Subject: [Spacewalk-devel] Query question regarding system.listLatestUpgradeablePackages Hello Spacewalk Developers, I was looking at Package_queries.xml and discovered that the following query is being used to pull

[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