Rank: Member
Groups: Registered
Joined: 6/9/2017(UTC) Posts: 29  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
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 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)
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 6/9/2017(UTC) Posts: 29 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?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 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.
|
|
|
|
|
|
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.
