Extended Collection Properties

The Extended Collection properties will show you what characteristics

Within the current version, this work needs to be done using SQL queries on the database. Following are these queries.

The line that starts with (-1) sets the default header graphic your collections will use (unless you define a specific header graphic within particular collection).

(All Collections) - This is where you can edit the Collection Description you see on the Luna Viewer when you have no collection selected and are looking at all collections.

Change the Theme to blue or default

delete from EXTENDEDCOLLECTIONPROPERTIES  where collectionid is NULL;
delete from EXTENDEDCOLLECTIONPROPERTIES  where collectionid='';


update EXTENDEDCOLLECTIONPROPERTIES set THEME='blue' where COLLECTIONID='All Collections';
update EXTENDEDCOLLECTIONPROPERTIES set THEME='blue' where COLLECTIONID='-1';

Change the Header Graphic URL

delete from EXTENDEDCOLLECTIONPROPERTIES  where collectionid is NULL;
delete from EXTENDEDCOLLECTIONPROPERTIES  where collectionid='';
 
update EXTENDEDCOLLECTIONPROPERTIES set HEADERGRAPHICURL='http://www.example.com/graphics/revisedHeader2000.jpg' where COLLECTIONID='All Collections';
update EXTENDEDCOLLECTIONPROPERTIES set HEADERGRAPHICURL='http://www.example.com/graphics/revisedHeader2000.jpg' where COLLECTIONID='-1';

Change the Description text

delete from EXTENDEDCOLLECTIONPROPERTIES  where collectionid is NULL;
delete from EXTENDEDCOLLECTIONPROPERTIES  where collectionid='';


update EXTENDEDCOLLECTIONPROPERTIES set INTRODUCTIONTEXT='This is the site level description' where COLLECTIONID='All Collections';
update EXTENDEDCOLLECTIONPROPERTIES set INTRODUCTIONTEXT='This is the site level description' where COLLECTIONID='-1';

Change the Default Group

delete from EXTENDEDCOLLECTIONPROPERTIES  where collectionid is NULL;
delete from EXTENDEDCOLLECTIONPROPERTIES  where collectionid='';


update EXTENDEDCOLLECTIONPROPERTIES set DEFAULTGROUPID='7' where COLLECTIONID='All Collections';
update EXTENDEDCOLLECTIONPROPERTIES set DEFAULTGROUPID='7' where COLLECTIONID='-1';