No data when clear all filters (related to Last N period(s) parameter)
When doing again some tests on the DE, I made an action I didn't do during the previous tests: "Clear all filters".
For the following DF https://de-qa.siscc.org/vis?lc=en&df[ds]=qa%3Astable&df[id]=SNA_TABLE1&df[ag]=OECD&df[vs]=1.0&av=true&pd=%2C&dq=..&to[TIME_PERIOD]=false&lo=5&lom=LASTNPERIODS&vw=tb
When cleaning all filters, the message "There is no data for the current selection. Please change the selection." is displayed while it should return a table with data as done on staging or on Prod. In the example there is data for year 2017 and 2018. When cleaning all filters, the query is asking for data for 2019 !! https://nsi-qa-stable.siscc.org/rest/data/OECD,SNA_TABLE1,1.0/all?startPeriod=2019&dimensionAtObservation=AllDimensions while it should ask for all data, https://nsi-qa-stable.siscc.org/rest/data/OECD,SNA_TABLE1,1.0/all?dimensionAtObservation=AllDimensions.
If you start to select from another filter than the time period, the message is maintained. If you start to select the Time period and specifically the last N period, it's working properly. I had the same issue with the DF https://de-qa.siscc.org/vis?lc=en&df[ds]=qa%3Astable&df[id]=DF_A3205&df[ag]=LU1&df[vs]=11.0&av=true&pd=%2C&dq=.A&to[TIME_PERIOD]=false&lo=5&lom=LASTNPERIODS&vw=tb.
This doesn't happen with all DFs. The one below didn't encounter the same issue. Could be link with the DF size?? (I didn't go deeper on this way)
2023-09-15_19h05_29
I made the same test with the DF: https://de-qa.siscc.org/vis?locale=en&dataflow[datasourceId]=qa:stable&dataflow[agencyId]=FAO&dataflow[dataflowId]=DF_AG_PRD_FIESMS_SDG_2_1_2&dataflow[version]=1.0&hasDataAvailability=true
I didn't encounter the issue but performance issue with a need twice on Table to start to display the table (or perf. issue also). See the video.
2023-09-15_19h14_00