Release | Yes/No |
---|---|
8.0.x | |
7.3.x | |
7.2.x | |
7.0.x |
Table of Content
Introduction
This document provided sample SQL scripts for explicit lists.
SQL Script to pick up Java Packages
This script is needed when defining User Defined Module on java results with a filter of type OBJECT PATH.
In effect, Java Packages are not stored in the knowledge base with their path but rather with their full names and therefore, are not included in the result of a filter of type OBJECT PATH.
SQL Script
Delete From §CI_OBJECTS_SET
Where SET_NAME = '$(ModuleName)'
/
Insert Into §CI_OBJECTS_SET(SET_NAME, OBJECT_ID, ERROR_ID)
select distinct '$(ModuleName)', p.IdKey, 0
from §Keys p, §KeyPar kp, §Keys k, §ObjFilRef r, §RefPath rp
where rp.Path like 'path set in the OBJECT PATH Filter'
and r.IdFilRef = rp.IdFilRef
and k.IdKey = r.IdObj
and kp.IdKey = k.IdKey
and p.IdKey = kp.IdParent
and p.ObjTyp = 99 /Java Package/
/
Replace 'path set in the OBJECT PATH Filter' with its value