Extended Collection Properties

Owned by sam
Last updated: Apr 02, 2015 by LunaVersion comment
2 min read

The Extended Collection properties will show you what characteristics will be used for each collection and when all or multiple collections are selected in the LUNA Viewer. 

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

Site level characteristics 

Site level characteristics are identified in the column called Collection were the values are (-1) and (All Collections) . This is where you can edit the Collection Description, Theme (default or blue),  Header Graphic and the Default Group you see on the Luna Viewer when you have more than one collection selected or 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';