• Report with a parameter "searchtext" to list all Users, which searchtext is part of their User-ID

  • We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
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.
 #54460  by Pitt
 
Hello,
I created a report with Jaspersoft Studio. The report should list all users, where the user-ID contains an entered searchtext.
If I make the searchtext as an static variable, everything is fine.
But if I try to combine the jrxml-file with a params.xml, so that I get ask to enter a searchtext before the report has been created, no window for entering the parameter value for searchtext will appear. Only the report appears without filtering.
Here my code for the params.xml:
Code: Select all
...
<report-parameters>
	<input label="enter the searchtext:" name="searchtext" type="text">
		<validator type="req"/>
	</input>
</report-parameters>
and a snippet of the code of the jrxml:
Code: Select all
...
	<queryString>
		<![CDATA[import com.openkm.dao.*;
               import com.openkm.dao.bean.*;
...
  if (user.getId().contains(searchtext)) {
    al.add(usr);
  }
 
Last edited by Pitt on Tue Oct 10, 2023 6:22 pm, edited 2 times in total.
 #54461  by Pitt
 
Ahhhhh, there is a bug!

If I run the report from "administration"-Tab, no window for entering the parameter appears.
But if I activate the report and put it to a profile, then I can run it from the menue "reports", and a window for entering appears and the report has been created all right!

Can someone check this problem and solve it?

Thx!!!

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.