[Spacewalk-list] RHN Errata Clone - publish date

[Paul Robert Marino]

its the spacewalk API
there is no way to hard set the date on an errata.
You can query it from the api but you cant set the create or update date.

A SQL query could set the date but its probably not going to be as
easy as you might like it will probably require a join but I'm not
sure I haven't looked at that part of the schema yet.

to query the date of an errata use the "errata.getDetails" xmlapi
https://access.redhat.com/knowledge/docs/Red_Hat_Network/API_Documentation/errata/ErrataHandler.html#getDetails

Although looking at it there may be a way to set the date in the
publish process via the errata.publishAsOriginal call in the API. The
problem is none of the current errata sync scripts I've seen use this
method.
it would require creating the errata with the publish boolean set to 0
 then publishing it after the fact. its a little more complex but
should be doable. The problem is I'm not sure it the would resolve the
issue because I think it only lets you set the create date not the
update date or last modified date.

I'll try it out when I get a chance and add it to the errata sync
script that I've been developing if it works. It would actually help
my fast skipping of previously published erratas work more accurately
on exact date ranges.



On Mon, May 7, 2012 at 12:31 PM, Musayev, Ilya <imusayev at webmd.net> wrote:
> I see. Is it limitation on RedHat APIs or Spacewalk?
>
>
>
> Can I work around the API limitation and do direct SQL updates, as long as I
> can see the publish date I could probably figure out the location of errata
> in sql and do an update.
>
>
>
> Or an easier approach, would it be possible to inject the publish date into
> description?
>
>
>
> From: spacewalk-list-bounces at redhat.com
> [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Paul Robert Marino
> Sent: Monday, May 07, 2012 12:19 PM
> To: spacewalk-list at redhat.com
> Subject: Re: [Spacewalk-list] RHN Errata Clone - publish date
>
>
>
> No not currently
> Its an api limitation
>
> On May 7, 2012 12:17 PM, "Musayev, Ilya" <imusayev at webmd.net> wrote:
>
> Is there any way to keep publish date of errata same as on RHN? It’s a bit
> tricky to look at erratas while they all have the same date and I have close
> to 10,000 of them.. Any help is appreciated.. thanks.
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list