• Retrieve List of all documents and users of openKM

  • OpenKM has many interesting features, but requires some configuration process to show its full potential.
OpenKM has many interesting features, but requires some configuration process to show its full potential.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #46568  by mamad
 
Hi guys
I want to retrieve information about all documents in a list(maybe in a array,arraylist,list or ...) and also a list of all users inside openKM.

i know how get info of a single document but i dont have any idea about all documents inside openKm.

for example i want a list of document names or uuids . i want to show this info in front end, so i need a way that work in a gwt-based class.

can you say me a proper method or class that return this two things ?

thanks in advance
 #46585  by jllort
 
If you have a lot of files, thousands this kind of information might take a lot of time to be processed and it does not seem good idea display a table or simple list what might have huge data. Reports seem better scenario for this kind of things, I will suggest two url what I think might be a good starting point for it:
https://docs.openkm.com/kcenter/view/ok ... ption.html ( understanding main OpenKM tables )
https://docs.openkm.com/kcenter/view/ok ... -pack.html ( here you will find basic report templates, you should investigate SQLReportPattern.jrxml ).
https://docs.openkm.com/kcenter/view/ok ... ports.html ( detailed information about how build your own reports )
 #46603  by mamad
 
well ,
I don't have any problem with time, just want the list !!!
using this query :
Code: Select all
 "SELECT NBS_UUID FROM OKM_NODE_DOCUMENT" 
will retrieve all uuids that is exactly what i want
But how i can run this query in a gwt-based class and get the uusids ?
I mean is there any way like using JDBC to retrieve this data in a gwt-based class ??
 #46616  by jllort
 
The easiest way for you might be make an iframe from GWT panel and include into some JSP. From GWT you can not execute queries or accessing core, you always make RPC ( remote process call ) what return JSON data across servlets. Take a look at classes like the interface OKMDocumentService and OKMDocumentServiceAsync class

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.