Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Custom reports does...
 
Notifications
Clear all

Custom reports does not display anymore after upgrading to version 5.0.x

7 Posts
3 Users
0 Reactions
11.2 K Views
jean pierre huart
(@jphuart)
Posts: 35
Active Member
Topic starter
 
[#2592]

Hi,

I was using 2 custom reports in version 3.x and 4.x.
Upgrading to version 5.0;5 they do not display anything and no errors are mentioned in the log.
Is there a change log that can help me to find out what has been modified in version 5 concerning report management or syntax?

Thanks a lot

Jean Pierre


 
Posted : 11 Sep 2015 14H38
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Hi,

No, there is no log about "custom" reports.
What is possible is that you used id for reports that have been reused in new version.
Advice is always to use high value ids for your own report (>10000)

First check access rights to reports : are they visible, if yes, just try and save.
Then check db : are they still in reports table ?


 
Posted : 11 Sep 2015 14H49
jean pierre huart
(@jphuart)
Posts: 35
Active Member
Topic starter
 

Hi,
I was not clear enough in my question. The reports appear correctly in the list of reports, they are still present in the database, but launching them does not display any result and there are no php errors reported in the logs (I tried inserting an obvious error and then an error log is added to the logs).

I builded them on the basis of existing reports, I will have to investigate how to make running them again, but I wanted to know what has been lastly modified in reports to orient my searches.

Thanks
Jean Pierre


 
Posted : 12 Sep 2015 17H18
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

V5.0 beings several habilitation control improvments.
So you should check security functions.

To be sure issue is habilitation, try and launch your reports as admin, witch widest acces rights. You should see data.


 
Posted : 12 Sep 2015 18H37
jean pierre huart
(@jphuart)
Posts: 35
Active Member
Topic starter
 

Thank you, my reports are present in the habilitation screen, they are marked as accessible by admin and supervisor.
When I connect as admin, they do not display anything.

I will review the php code to try to find out the problem.

Ciao
Jean Pierre


 
Posted : 12 Sep 2015 21H51
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Review the query criteria.
If you use one of the security functions to apply access control (what is done on standard default) your issue may come from there.


 
Posted : 12 Sep 2015 22H25
(@papjul)
Posts: 143
Active Member
 

I had an issue with the function getAccesRestrictionClause which was mispelled before 5.0.x, maybe you can check that?


 
Posted : 14 Sep 2015 12H41
Share:

Scroll to Top