Global controllers that are queried immediately do not work when the number of records is large, such as more than 100,000 rows

[ussr2000]

In dashboard, if the global controller USES automatic query, some widgets in the page will download less data, but change the global controller to manual query, after the selection of conditions, click the query button, and then download the data, the number of records is normal

[ussr2000]

davinci-0.3.0-beta.9 release

[scottsut]

Please provide a reproducible scenario.

[ussr2000]

1.create a widget，select table view

2.create a dashboard

3.add a dashboard in the left list

4.add a widget to the dashboard

5.add a global controller with refresh immediately option


6.chose a value from global controller ,the widget will refresh automatically ,when the records in the table are more than 100000，then download ,the excel will only have part of the 100000 records ,is not completed

7.but when use global controller with manual refresh is ok ,the download excel will have all records

[scottsut]

When you use manual query, Did you also select values from global controls and press the search button before downloading?

[ussr2000]

yes, after I select values from global controls and press the search button,then download ,the excel have all data ,it is ok

[scottsut]

We think the behavior in immediate query mode is as expected. Thanks for discovering the problem in manual query mode, the downloaded data should be filtered by global controls whether you press the search button or not.

[ussr2000]

but in immediate query mode，the data in downloaded excel is incomplete

[scottsut]

The downloaded data is not full data, but the data presented by current dashboard.

[ussr2000]

hello,I think you misunderstood my issue,I mean when I use immediate query mode,when I download the excel ,the data in downloaded excel is incomplete(for examle 70000 ),but when I query data from datebase with the same parameter as the global controller ,the data is complete(for examle 110000 ).
And then when I use manual query mode,the data in downloaded excel is complete(for examle 110000 ).

[scottsut]

Well...Check if this configuration causes

[ussr2000]

Thank you ,I didn't change the configuration of the widget .The configuration of "immediate query mode" is the same to " manual query mode"