LiveReport on Category Field Being Populated

Brenda_Paul

I need to create a LiveReport that checks to see if there are any objects without a field in a category index populated. Iv'e seen some examples, but still don't understand how to code the SQL statement.

Martin_Gäckler

Here is an exampleselect * from dtree dwhere not exists( select * from llattrdata l where d.dataid = l.id and d.versionnum = l.vernum and l.defid = and l.defvern = and l.attrid = and l.valstr is not null)You must populate , and with the correct values.Hope this helpsMartin