places where related language prompt table can be missing
—-places where related language prompt table can be missing
replace CSG_PP with your project name.
with a1 as (
SELECT r.RELLANGRECNAME,f.edittable,
f.recname, f.fieldname
FROM psrecfield f, psrecdefn r
WHERE f.edittable = r.recname
and r.RELLANGRECNAME=' '
AND (f.recname, f.fieldname) IN (
SELECT p.recname,
p.fieldname
FROM pspnlfield p
WHERE p.pnlname IN (
SELECT objectvalue1
FROM psprojectitem
WHERE objecttype = 5
AND projectname LIKE 'CSG_PP_%') )
AND edittable <> ' ')
select p.pnlname, p.pnlfldid, a1.*,p.pnlname FROM pspnlfield p,a1
WHERE p.pnlname IN (
SELECT objectvalue1
FROM psprojectitem
WHERE objecttype = 5
AND projectname LIKE 'CSG_PP_%')
and a1.recname=p.recname and a1.fieldname=p.fieldname
/
