Documents created by group between 2 dates

Thomas_Martindale

I'm trying to butcher a report we currently have (SQL Below).select count(*)as "Total Files" , sum(round(dv.datasize / 1000)) as "Total Size (1,000 bytes)" from dtree dt, dversdata dv where dt.createdate < %2 and dt.createdate >= %1 and subtype = 144 and dt.dataid = dv.docidI need the report to give me all documents created by a specific group between 2 dates. We are using LL9.7.1.Any help with this is most welcome.ThanksTom

Tim_Hunter

Assuming your report already gives you what you need you just need to add an additional where clauseand dt.groupid = Or if you need the group name and not the groupID you need to join to the kuaf k table and dt.groupid = k.id and k.name = "some group name"If you are more specific with your request I can give you a more direct answer