Page 1 of 1

Retrieve List of all documents and users of openKM

PostPosted:Wed Aug 15, 2018 12:45 pm
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

Re: Retrieve List of all documents and users of openKM

PostPosted:Thu Aug 16, 2018 2:11 pm
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 )

Re: Retrieve List of all documents and users of openKM

PostPosted:Sat Aug 18, 2018 4:35 am
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 ??

Re: Retrieve List of all documents and users of openKM

PostPosted:Sun Aug 19, 2018 6:26 pm
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