Home > Forum > General > SOLR Reports showing all instances for every user, instead of only the ones with access-rights

SOLR Reports showing all instances for every user, instead of only the ones with access-rights

0

10.02.2022

12:05

Hi,

because of the lately very, very poor performance of SQL-Reports I have changed some reports to Searchindex.

The SQL-Reports always only show the workflows that the user has access to, after I changed it to SearchIndex every user sees everything in the report, but of course then can't open the instances they dont have permission to. The predefined Filter is set to all.

Is there anything I can do to make SOLR reports to only show what the user has at least read rights?

Oh, our current version is 2021.1.4.36

Thanks!
Chris

SIMON Péter

14.02.2022

17:56

SIMON Péter

Hi Christian,
We are also experiencing poorer SQL-report performance. One advise which helps usually: exclude "assigned to" column. It will be much faster.
(...OUTER APPLY GetTaskForElement(....) will be excluded from query this way).
We use 2021.1.4.118, the issue with searchindex you wrote is still here.
Peter

Solution (0)

Helpful (1)

Wrong answer (0)

15.02.2022

15:23

In reply to: SIMON Péter

Hi Peter,

thank you for your input. I'll try out your suggestion with the SQL-Reports and hope this is running better in Version 2022.

I really like the possibilities of SOLR reports, but having everyone seeing all the data is a no-go.

Thanks a lot! :)
Christian

Solution (0)

Helpful (0)

Wrong answer (0)