logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Ott  
#1 Posted : Wednesday, May 26, 2021 9:07:13 PM(UTC)
Ott

Rank: Member

Groups: Registered
Joined: 6/9/2017(UTC)
Posts: 29
Canada

Thanks: 1 times
Hi,

I just noticed that every Enumerated Lists are getting refreshed from the database when the Web Report Designer starts. This is causing a long unnecessary delay.

An Enumerated list should only be refreshed when invoked by the user.

I also noted that the Enumerated Lists are getting refreshed using the default username in the Source definition, instead of using the currently connected user.

Yves
epf  
#2 Posted : Thursday, May 27, 2021 9:32:45 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,001
Switzerland

Thanks: 14 times
Was thanked: 172 time(s) in 166 post(s)
yes, enums are refreshed because when you edit a restriction based on an enum, you need all the values to be proposed...

enum values can depend on the connected user at report execution if you set the property 'List is refreshed before the report execution',
may be time consuming...

a new option allow to define enum values for a given connection (but this will not fit your requirement with the user connection)
Ott  
#3 Posted : Thursday, May 27, 2021 12:56:49 PM(UTC)
Ott

Rank: Member

Groups: Registered
Joined: 6/9/2017(UTC)
Posts: 29
Canada

Thanks: 1 times
I understand that enums are refreshed when the user creates a restriction, they need to have all values available. But refreshing every single enums when the Web Report Designer starts should not be done at that time, especially if a user will create a report that doesn't even need an enum. The refresh should be only be done when a user creates a restriction on a field with an enum, moreover, the refresh should only be done for that specific enum.

The refresh of enums needs to be done using the user's current connection to the database so that the security built in the database can kick in to restrict the values available to the user. Do you have any suggestions for implementing this?
epf  
#4 Posted : Thursday, May 27, 2021 4:07:53 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,001
Switzerland

Thanks: 14 times
Was thanked: 172 time(s) in 166 post(s)
Well, of course loading the enum when the user use it is better than loading all enums. It is a kind of optimisation...

This improvement is not so easy to implement and would requires so effort.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.