feature-additional-project-properties: projectScript.sql

File projectScript.sql, 2.6 kB (added by tincholiguori, 3 months ago)

This script is going to be used to change the combo values.

Line 
1 {\rtf1\ansi\ansicpg1252\cocoartf949\cocoasubrtf330
2 {\fonttbl\f0\fnil\fcharset0 LucidaGrande;}
3 {\colortbl;\red255\green255\blue255;}
4 \paperw11900\paperh16840\margl1440\margr1440\vieww19640\viewh8740\viewkind0
5 \pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\ql\qnatural\pardirnatural
6
7 \f0\fs24 \cf0 /* First Deletes all the values from the Combos */\
8 prompt \
9 prompt First Deletes all the values from the Combos\
10 prompt \
11 \
12 delete from PN_PROJECT_SPACE_META_COMBO;\
13 \
14 /* Add Specific Values For the First Combo Value of the Property Project */\
15 prompt \
16 prompt Add Specific Values For the First Combo Value of the Property Project\
17 prompt \
18 insert into PN_PROJECT_SPACE_META_COMBO(PROPERTY_ID, COMBO_VALUE, COMBO_LABEL) VALUES (7, 'First Value','First Label')\
19 insert into PN_PROJECT_SPACE_META_COMBO(PROPERTY_ID, COMBO_VALUE, COMBO_LABEL) VALUES (7, 'Second Value','Second Label')\
20 insert into PN_PROJECT_SPACE_META_COMBO(PROPERTY_ID, COMBO_VALUE, COMBO_LABEL) VALUES (7, 'XXX Value','XXX Label')\
21 \
22 prompt \
23 prompt Add Specific Values For the Second Combo Value of the Property Project\
24 prompt \
25 /* Add Specific Values For the Second Combo Value of the Property Project */\
26 insert into PN_PROJECT_SPACE_META_COMBO(PROPERTY_ID, COMBO_VALUE, COMBO_LABEL) VALUES (6, 'First Value','First Label')\
27 insert into PN_PROJECT_SPACE_META_COMBO(PROPERTY_ID, COMBO_VALUE, COMBO_LABEL) VALUES (6, 'Second Value','Second Label')\
28 insert into PN_PROJECT_SPACE_META_COMBO(PROPERTY_ID, COMBO_VALUE, COMBO_LABEL) VALUES (7, 'XXX Value','XXX Label')\
29 \
30 /* Change the Tokens From the Pages that are being changed (For Type of Expense) */\
31 prompt \
32 prompt Change the Tokens From the Pages that are being changed (For Type of Expense)\
33 prompt \
34 update PN_PROPERTY set property_value = 'New Value' where property = 'prm.project.create.wizard.meta.typeofexpense'\
35 update PN_PROPERTY set property_value = 'New Value' where property = 'prm.project.propertiesedit.meta.typeofexpense.label'\
36 update PN_PROPERTY set property_value = 'New Value' where property = 'prm.project.properties.meta.typeofexpense.label'\
37 \
38 /* Change the Tokens From the Pages that are being changed (For Functional Area) */\
39 prompt \
40 prompt Change the Tokens From the Pages that are being changed (For Functional Area)\
41 prompt \
42 update PN_PROPERTY set property_value = 'New Value 2' where property = 'prm.project.create.wizard.meta.functionalarea'\
43 update PN_PROPERTY set property_value = 'New Value 2' where property = 'prm.project.propertiesedit.meta.functionalarea.label'\
44 update PN_PROPERTY set property_value = 'New Value 2' where property = 'prm.project.properties.meta.functionalarea.label'}