프로젝트

일반

사용자정보

개정판 b7b58c83

IDb7b58c83747e34f9936c0125238e4cfa433d6d06
상위 dc34677e
하위 42ac1d27

함의성이(가) 3년 이상 전에 추가함

fix sym attrs

Change-Id: Id9216865a9d1576d13f917cec4c2dd296de011f8

차이점 보기:

DTI_PID/DTI_PID/Scripts/MSSQL/ID2.sql
2273 2273 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2274 2274 
'e630853f-8b08-45b8-949b-3005c02674b4','21','Type','Type','Text Item','item.text()[1:]',1,0,NULL,'ALL',0);
2275 2275 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2276 
'94cfa92b-1e0c-49c1-866e-d540dc8c23a4','21','SeqNumber','Tag Seq Number','Text Item','item.text() if (item.text()[-1].isdecimal() and item.text()[-2].isdecimal() and item.text()[-3].isdecimal()) else (item.text()[:-1] if (item.text()[-2].isdecimal() and item.text()[-3].isdecimal()) else (item.text()[:-2] if item.text()[-3].isdecimal() else item.text()[:-3]))',2,1,NULL,'ALL',0);
2276 
'94cfa92b-1e0c-49c1-866e-d540dc8c23a4','21','SeqNumber','Tag Seq Number','Text Item','item.text() if item.text()[-1].isdecimal() else (item.text()[:-1] if item.text()[-2].isdecimal() else (item.text()[:-2] if item.text()[-3].isdecimal() else item.text()[:-3]))',2,1,NULL,'ALL',0);
2277 2277 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2278 2278 
'b21acc50-ca25-4d37-a121-b654c4e8b155','21','MEASURED_VARIABLE','MEASURED_VARIABLE','Text Item','item.text()[0]',0,0,NULL,'ALL',0);
2279 2279 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2280 2280 
'eb5cbcca-9f4c-484e-a4cb-ca4fcc14499f','25','Type','Type','Text Item','item.text()[1:]',1,0,NULL,'ALL',0);
2281 2281 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2282 
'0816f270-c098-4284-901f-61b7b5c856ef','25','SeqNumber','Tag Seq Number','Text Item','item.text() if (item.text()[-1].isdecimal() and item.text()[-2].isdecimal() and item.text()[-3].isdecimal()) else (item.text()[:-1] if (item.text()[-2].isdecimal() and item.text()[-3].isdecimal()) else (item.text()[:-2] if item.text()[-3].isdecimal() else item.text()[:-3]))',2,1,NULL,'ALL',0);
2282 
'0816f270-c098-4284-901f-61b7b5c856ef','25','SeqNumber','Tag Seq Number','Text Item','item.text() if item.text()[-1].isdecimal() else (item.text()[:-1] if item.text()[-2].isdecimal() else (item.text()[:-2] if item.text()[-3].isdecimal() else item.text()[:-3]))',2,1,NULL,'ALL',0);
2283 2283 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2284 2284 
'4271299e-a197-4250-b195-c748aa46b9a2','25','MEASURED_VARIABLE','MEASURED_VARIABLE','Text Item','item.text()[0]',0,0,NULL,'ALL',0);
2285 2285 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
......
2351 2351 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2352 2352 
'235c62dc-02ca-483b-bcd6-eb8ee5c86f9a','19','Type','Type','Text Item','item.text()[1:]',2,0,NULL,'ALL',0);
2353 2353 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2354 
'16b674b2-9c10-4309-9d98-c36035ab0922','19','SeqNumber','Tag Seq Number','Text Item','item.text() if (item.text()[-1].isdecimal() and item.text()[-2].isdecimal() and item.text()[-3].isdecimal()) else (item.text()[:-1] if (item.text()[-2].isdecimal() and item.text()[-3].isdecimal()) else (item.text()[:-2] if item.text()[-3].isdecimal() else item.text()[:-3]))',3,1,NULL,'ALL',0);
2354 
'16b674b2-9c10-4309-9d98-c36035ab0922','19','SeqNumber','Tag Seq Number','Text Item','item.text() if item.text()[-1].isdecimal() else (item.text()[:-1] if item.text()[-2].isdecimal() else (item.text()[:-2] if item.text()[-3].isdecimal() else item.text()[:-3]))',3,1,NULL,'ALL',0);
2355 2355 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2356 
'a5b5ff96-c33c-43e2-91ed-b0e2ad583a53','19','Suffix','Tag Suffix','Text Item',''''' if (item.text()[-1].isdecimal() and item.text()[-2].isdecimal() and item.text()[-3].isdecimal()) else (item.text()[-1] if (item.text()[-2].isdecimal() and item.text()[-3].isdecimal()) else (item.text()[-2:] if item.text()[-3].isdecimal() else item.text()[-3:]))',4,1,NULL,'ALL',0);
2356 
'a5b5ff96-c33c-43e2-91ed-b0e2ad583a53','19','Suffix','Tag Suffix','Text Item',''''' if item.text()[-1].isdecimal() else (item.text()[-1] if item.text()[-2].isdecimal() else (item.text()[-2:] if item.text()[-3].isdecimal() else item.text()[-3:]))',4,1,NULL,'ALL',0);
2357 2357 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2358 
'7b22bbba-9323-43af-9ca3-973c0a2a2b37','21','Suffix','Tag Suffix','Text Item',''''' if (item.text()[-1].isdecimal() and item.text()[-2].isdecimal() and item.text()[-3].isdecimal()) else (item.text()[-1] if (item.text()[-2].isdecimal() and item.text()[-3].isdecimal()) else (item.text()[-2:] if item.text()[-3].isdecimal() else item.text()[-3:]))',3,1,NULL,'ALL',0);
2358 
'7b22bbba-9323-43af-9ca3-973c0a2a2b37','21','Suffix','Tag Suffix','Text Item',''''' if item.text()[-1].isdecimal() else (item.text()[-1] if item.text()[-2].isdecimal() else (item.text()[-2:] if item.text()[-3].isdecimal() else item.text()[-3:]))',3,1,NULL,'ALL',0);
2359 2359 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2360 
'28a2680b-3125-4cb7-a637-26ec54d594b1','25','Suffix','Tag Suffix','Text Item',''''' if (item.text()[-1].isdecimal() and item.text()[-2].isdecimal() and item.text()[-3].isdecimal()) else (item.text()[-1] if (item.text()[-2].isdecimal() and item.text()[-3].isdecimal()) else (item.text()[-2:] if item.text()[-3].isdecimal() else item.text()[-3:]))',3,1,NULL,'ALL',0);
2360 
'28a2680b-3125-4cb7-a637-26ec54d594b1','25','Suffix','Tag Suffix','Text Item',''''' if item.text()[-1].isdecimal() else (item.text()[-1] if item.text()[-2].isdecimal() else (item.text()[-2:] if item.text()[-3].isdecimal() else item.text()[-3:]))',3,1,NULL,'ALL',0);
2361 2361 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2362 2362 
'66cef7da-9f34-4dd8-8f23-b804b2cc6e16','19','SP','SP','Text Item','item.text()',5,0,NULL,'ALL',0);
2363 2363 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (

내보내기 Unified diff

클립보드 이미지 추가 (최대 크기: 500 MB)