Jump to content
We've recently updated our Privacy Statement, available here ×

jeanpierrepolnareff91

Members
  • Posts

    58
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Entry Comments posted by jeanpierrepolnareff91

  1. Thanks for the wiki ! 

    I managed to get the resource_name using a subquery inside a join clause, sample here to get report executions (date of exec, report name, report_uri, user exec) :

    SELECT jia.event_date, jir.resource_name, jia.resource_uri, jia.username FROM 
    jiauditevent jia
    INNER JOIN (
        SELECT DISTINCT rf.uri || '/' || r.name AS resource_uri, r.label AS resource_name, resourcetype 
        FROM jiresource r, jiresourcefolder rf 
        WHERE r.parent_folder=rf.id
    ) jir ON jia.resource_uri = jir.resource_uri 
    WHERE jir.resourcetype LIKE '%com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.ReportUnit%'
    ORDER BY jia.event_date DESC

    Sample result : 

    Event_date Resource_name Resource_uri Username
    "2022-02-02 17:11:48.745" my report

    /public/test/my_report

    jasperadmin

     

  2. Hello ! 

    Thanks for your Wiki page, it's very usefull.

    I tried your configuration on a demo JasperReports solution and everythink worked well,

    but when my system administrator followed the documentation on the production server, an error was triggered : 

    Error creating bean with name 'filterInvocationInterceptor' defined in ServletContext resource [/WEB-INF/applicationContext-security-web.xml]: Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Unsupported configuration attributes: [ROLE_DATASOURCE]

    It's strange because the applicationContext-security-web.xml wasn't modified during the configuration.

    Do you have an idea about what can create an error like this ?

×
×
  • Create New...