List documents/folders and attached category

Hugo_Fréchette

Hi,I want to produce a Livereport to show all the documents/folder of a sub folder and the category attached to it.Example:Documents Name Cat1 Cat2 Cat3 Cat4====================================================Document1 X XDocument2 X XDocument3 X XFolder1 X XFolder2 X X I tried to play with the table LLattrdata and Dtree without any success. This query seems very hard to produce and i need some experts help.ThanksHugo

Glenn_Witerski_(inmadmin_-_(deleted))

One of the affintiy partners has a new LL module called Category Manager that will handle this quite easily. The LiveReport would be likeselect a.name Name, a.DataId, b.category from dtree a, categorymirror bwhere a.dataid = b.dataid and a.parentid = %1Please contact glennw@intrnetmethods.com for further details.