프로젝트

일반

사용자정보

개정판 810102c6

ID810102c6dc8ef3e2426421662f0bcb273d03fbfb
상위 3be92e31
하위 dc34677e

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

change sym attr expression

Change-Id: Idc2d70e61500aad4508e3aa97670c4338a163310

차이점 보기:

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()[:5]',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() 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);
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()[:5]',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() 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);
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()[:5]',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() 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);
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 len(item.text()) is 5 else item.text()[5:]',4,1,NULL,'ALL',0);
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);
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 len(item.text()) is 5 else item.text()[5:]',3,1,NULL,'ALL',0);
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);
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 len(item.text()) is 5 else item.text()[5:]',3,1,NULL,'ALL',0);
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);
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 (
......
2383 2383 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2384 2384 
'ed1355df-ffb8-462a-a43e-59c94d88572b','0','Line No','Line No','Text Item','item.text()',6,6,NULL,'ALL',0);
2385 2385 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2386 
'fbada9c7-0a5b-45c6-b082-2d3763e19abd','39','Tag Prefix','Tag Prefix','Tag No','item.text().split("-")[0] if item and "-" in item.text() else ''',1,0,NULL,'ALL',0);
2386 
'fbada9c7-0a5b-45c6-b082-2d3763e19abd','39','Tag Prefix','Tag Prefix','Tag No','item.EvaluatedAttribute(''EQ_TYPE'')',1,0,NULL,'ALL',0);
2387 2387 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2388 
'28c6bda1-e02a-4473-aa71-ee5f45dbbe5b','39','Tag Seq No','Tag Seq No','Tag No','item.text().split("-")[1][:5] if item and "-" in item.text() and len(item.text().split("-")[1]) > 4 else ''',2,0,NULL,'ALL',0);
2388 
'28c6bda1-e02a-4473-aa71-ee5f45dbbe5b','39','Tag Seq No','Tag Seq No','Tag No','item.EvaluatedAttribute(''EQ_TAG'')',2,0,NULL,'ALL',0);
2389 2389 
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES (
2390 
'258e8b06-21bd-4c5b-901b-7abdbb2d0dca','39','Tag Suffix','Tag Suffix','Tag No','item.text().split("-")[1][5:] if item and "-" in item.text() and len(item.text().split("-")[1]) > 4 else ''',3,0,NULL,'ALL',0);
2390 
'258e8b06-21bd-4c5b-901b-7abdbb2d0dca','39','Tag Suffix','Tag Suffix','Tag No','item.EvaluatedAttribute(''EQ_SUX'')',3,0,NULL,'ALL',0);
2391 2391 
INSERT INTO SymbolAttribute (UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property)
2392 2392 
VALUES('3cbbffc0-9f60-4d6c-9c64-e5983adac9c0', '22', 'Outlet Size', 'Outlet Size', 'Size Text Item', 'item.mainSize', 3, 0, NULL, 'ALL', 1);
2393 2393 
INSERT INTO SymbolAttribute (UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property)

내보내기 Unified diff