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

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

db - updated the ds create to key off of SO3 and "Country" and cleaned out dup SO1 and SO3 usage. Added map_name cleanup to set to None vs DEFAULT. Added more select tests. Added test for VALUE_ATTR and null measure value.

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/* add the default view template and set all IPV's to use the default template. */
11insert into VIEW_TEMPLATE(NAME, TITLE, DESCRIPTION, VIEW_TYPE, FILEPATH_AND_NAME, SORT_ORDER, ACTIVE_FLAG)
12values ('IndicatorViewDefault', 'Default Indicator View', 'Default indicator view XSLT', 'INDICATOR_VIEW', 'html/indicator/profile/view/ViewPage.xslt', 1, 'x')
13;
14
15update INDICATOR_VIEW set VIEW_TEMPLATE_NAME = 'IndicatorViewDefault';
16
17/*------------------------------ END OF FILE ------------------------------*/
Note: See TracBrowser for help on using the repository browser.