LiveReport for Category Field Not Populated

Brenda_Paul

We need to create a LiveReport that presents a list of all objects with a specific category field populated. Has anyone done this before? The only objects that would have the category are contract files.

Appu_Nair

See Lindsay's thread here,https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=16490104&objAction=view&show=0select dataid from dtree where subtype=31067 --is all contract objectsselect * from llattrdata where defid= and defvern= and attrid= =these are the objects that have that category and attribute you are afterCombining these two something likeselect * from llattrdata where defid= and defvern= and attrid= and id in (select dataid from dtree where subtype=31067 )The attached document is how I wrote a report to get all contract objects that had three categories attached to it modelled after the OT article.