I’m facing this issue and I’m wondering if any of you have a solution to the following problem:
I have a widget that has a data range filter. So, basically in function of the data range filled a table is generated. The query is parameterized in function of the data range data.start and data.end.
I would like somehow to have the possibility to execute the query with data range (if the filter is enabled) and execute the query without any date range filter (if the filter is disabled). In other words, is there a possibility to execute the query without filled the data range? I mean, if the data range is not filled it means that I want to take all the values (without any “where” condition). For how it is now if the data range is empty I received this error: Error running query: missing value