Database publish time

Rhythmyx Technical Discussion
1

Hello,

I am working on publishing items of Articles CT to the database. I want to be able to record in the db table, the publish time of the each item, the first time the items were published to the database.

How do I go about this?

Thanks
Pallavi

2

Has anyone done something similar to what I am trying to do here ?

3

Hi Pallavi

Which database are you using?

This may be more of a db question than Rhythmyx. In SQL2000-5 You could create a column in your db published table that had a default value of the current time (getdate()) so everytime a new record was inserted it would be populated by the current time. Then have a trigger on update to populate another field everytime the row was updated.

Cheers
James

4

Hey James,

I figured it out but thanks for your response. I appreciate.

Pallavi