Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
LiveReport to display all the file extensions in Livelink
Dragan_Jichici
I would like this report to only show the latest version if possible. Does anyone know how to create one?Thanks
Find more posts tagged with
Comments
Dave_Ebels_(jocoadmin_-_(deleted))
make sure this is run with a large number of records and as an AutoLiveReportselect mimetype, count(*) from dversdata group by mimetype order by count(*) desc
Dragan_Jichici
Message from via eLink
Message from <
> via eLink
Hi Dave,
That worked. Do you know if I can narrowdown my results with only the most recent versions in Livelink?
We have large number of documents thatcould contain up to 40 versions.
Regards,
Dragan
Dave_Ebels_(jocoadmin_-_(deleted))
Dragan,Good to see you are hard at it. Try thisselect %1, DVersData.MimeType, count(*) "count(*)" from DTree, DVersData where %2 and (DTree.DataID = DVersData.DocID) and (%3) group by %1, DVersData.MimeType order by count(*) descor give me a call if you like.Dave Ebels616-394-2439
