Hi. Does anyone know how I can write a LiveReport which shows me all the different subtypes and the total count of objects within the Enterprise Workspace?
Hi, I hope you are aware about sql queries and Join operations. you required two tables to join DTree and DTreeAncestors.
DTreeAncestors having the data of ancestor details for all items. DTree is a view having active items(not deleted) details. If you want to include the deleted item's count, you can refer to the table DTreeCore.
Now you can join the the both tables to get items present under Enterprise Workspace having DataID = 2000 in DTree. you can join using DTree.DataID = DTreeAncestors.AncestorID
For the subtype count you can refer to the column SubType Present on DTree table. Use group by and count function to get the count.
Thanks.
Happy Coding. :)
