LiveReport to Display all items associated with a Category

I would like to be able to run a LiveReport to see all items that have a specified Category.Is there a way to do this?

Find more posts tagged with

Comments

This is a LiveReport that I use to identify the contents of a category. I hope this helpsSQL select * from catregionmap where catid=%1User input parameter is number ,, input the objid of the categoryAuto LiveReport setting

Cheryl_Brock

I am really looking for a report that would allow me to select the category id and get all dataids that uses the specific category id.Any thing like that?

eLink User

Message from WARD Mitch via eLinkTry:select distinct id as dataid from LLATTRDATA where DefID=xxxxxxxWhere xxxxx is the id of the category.You can always join to DTREE to get the details such as name or subtypefor the item.RegardsMitch -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 29 July 2005 22:50To: eLink RecipientSubject: Need actual documents/folders that have categories assigned toitNeed actual documents/folders that have categories assigned to it Postedby Brock, Cheryl L on 07/29/2005 04:48 PMI am really looking for a report that would allow me to select thecategory id and get all dataids that uses the specific category id.Any thing like that?[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: LiveReport to Display all items associated with a Categoryhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=4046048&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server: https://knowledge.opentext.com/knowledge/livelink.exe______________________________________________________________This message has been scanned for viruses.