LDN - Luminis Developer Network

Extending William's Combined Announcement Channel and someone's archive, we added an archive that sorts the announcements based on Month and year. We have had this for some time but, while it works, the code is not my favorite... I'm going to post it anyway and if you want to use it or customize it that's great.

The archive is created on the database side. Every night a job runs that takes the announcements from the Luminis Database and moves them to the archive. When the archive is brought up, the announcements in the Luminis schema and the archive are unioned to produce the result.

At UVic we have all of our custom channel data in a separate Schema, so you will see references to the Luminis schema as our custom schema has read access to the Luminis schema. ta.sql contains the required packages for retrieving the archive and managing the announcements. archive.sql has the table definitions and the job definition.

The channel also uses our dropdowns.

I'm sure I have forgotten something so if you have any questions please ask away.

Demo