Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

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. 

Info

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

Code Block
languagesql
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

Code Block
languagesql
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

Code Block
languagesql
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

Code Block
languagesql
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';