Live Report

David Weichieh

How to create a live report to get the following information?

username

Name

CraeteDate

PS: where Name LIKE '2%' AND CreateDate BETWEEN '2024-01-01' AND '2024-09-30' ORDER BY CreateDate asc

Greg Griffiths

if you are looking for information about content you will find that in the DTree table, information about users is found in the KUAF table and information about versions of content is in DVersData. The OT training course https://www.opentext.com/TrainingRegistry/course/details/2889 instructor led or https://www.opentext.com/TrainingRegistry/course/details/3241 self paced will really help.

Additionally, you can request the DB Schema via your account manager with an NDA and also have a look at the schema companion guide - https://support.opentext.com/csm?id=kb_article_view&sysparm_article=KB0588114 - will help you find your way around.