source: main/trunk/db/src/main/scripts/mysql/migrate/4_data-iv_misc.sql @ 25154

Last change on this file since 25154 was 25154, checked in by GarthBraithwaite_STG, 3 months ago

db - move split to copy and simplified Kims and script. removed ibisph. prefix. ipv rename to catch ip name. Added default view template record and set IV to default.

File size: 1.0 KB
Line 
1/* Sets the IV measure name and title based on Kim's TMP_IPV_MEASURE table */
2
3update INDICATOR_VIEW set MEASURE_NAME           = ifnull  ((select MEASURE_NAME from TMP_IPV_MEASURE where IPV_NAME3 = NAME), 'DEFAULT');
4/* same as above
5update INDICATOR_VIEW set MEASURE_NAME           = coalesce((select MEASURE_NAME from TMP_IPV_MEASURE where IPV_NAME3 = NAME), 'DEFAULT');
6*/
7update INDICATOR_VIEW set MEASURE_TITLE_OVERRIDE = (select MEASURE_TITLE_OVERRIDE from TMP_IPV_MEASURE where IPV_NAME3 = NAME);
8
9
10
11/* add the default view template and set all IPV's to use the default template. */
12insert into VIEW_TEMPLATE(NAME, TITLE, DESCRIPTION, VIEW_TYPE, FILEPATH_AND_NAME, SORT_ORDER, ACTIVE_FLAG)
13values ('IndicatorViewDefault', 'Default Indicator View', 'Default indicator view XSLT', 'INDICATOR_VIEW', 'html/indicator/profile/view/ViewPage.xslt', 1, 'x')
14;
15
16update INDICATOR_VIEW set VIEW_TEMPLATE_NAME = 'IndicatorViewDefault';
17
18/*------------------------------ END OF FILE ------------------------------*/
Note: See TracBrowser for help on using the repository browser.