/DTI_PID/SPPIDConverter/DB/SPPID_DB.cs - Diff - HYTOS - 일정관리

개정판 dc8313b7

조봉훈이(가) 약 2년 전에 추가함

Modify MSSQL Query

Change-Id: I67737458c820da311a3ae16c1b5a890baa066128

                                         WHERE 1 = 1
                                            AND ia.NAME NOT LIKE('Case.%')
                                            AND ea.ENTITY_NAME NOT IN('T_PlantItemGroup')
                                            AND instr(ia.NAME, 'SP_RoomID') = 0
                                            AND (ia.NAME not like 'SP_RoomID%' )
                                            AND (ia.DISPLAYNAME not like 'Parent%' or ia.DISPLAYNAME = 'Parent Item')
                                            AND ia.DISPLAYNAME not like 'PartOfPlant%'
                                            AND ia.DISPLAYNAME not like '%Design Basis UID%'

내보내기 Unified diff