On 07/20/2011 02:42 PM, Tomas Lestach wrote:
> APIs:
system.getRelevantErrata
Requires a systemid.
system.getRelevantErrataByType
Requires a systemid.
system.getUnscheduledErrata
Requires a systemid.
Depends what you need.
That is exactly what I am trying to avoid. I want basically
def AffectedSystems()
return SELECT * from SYSTEM s WHERE HasRelevantErrata(s)
I want to avoid looping over systems finding their relevant erratas, or
looping over erratas finding their affected systems.
the APIs above answer
def getRelevantErratas(id)
return SELECT * from SYSTEM s WHERE HasRelevantErrata(s) and s.id=id
and the ones in errata answer
def listAffectedSystems(id)
return SELECT * from SYSTEM s WHERE IsAffectedByErrata(s, id)
--
Duncan Mac-Vicar P. - Novell® Making IT Work As One™
SUSE LINUX Products GmbH, GF: Jeff Hawn, Jennifer Guild, Felix
Imendörffer, HRB 16746 (AG Nürnberg)
Maxfeldstraße 5, 90409 Nürnberg, Germany
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
