Parameter of dynamic data

Question

Hello,
I need your help to create a dashboard.
The company for which it is the dashboard, works with commercial dates, which do not coincide with calendar dates.
They are stored in a table of the database, and at the same time each sale is assigned to which commercial date corresponds.
I need to be able to filter the information based on a certain business date.
The first thing I tried was to create a Data Colunm parameter (using the commercial dates table) and use it in the sql query. The filtering works fine, but when you insert a new business date in the table, it is not reflected in the options of the parameter.
Then I tried using a master filter (in the filter panel). In this case, the filter options are updated with the database, but it gives the user the option to remove all the filters.
I hope I have been clear and they understand what I need.

Bruno Martoglio
Argentina

Anandaraj Radhakrishnan · Answer

Hi Bruno Martoglio,   
   
Thank you for contacting Syncfusion support.   
   




when you insert a new business date in the table, it is not reflected in the options of the parameter.   

We were able to reproduce this issue and logged it in our issue tracking list. This fix will be available in our upcoming official release which planned on end of Feb 2018.    


I tried using a master filter (in the filter panel). In this case, the filter options are updated with the database, but it gives the user the option to remove all the filters.   

Please confirm your actual requirement, whether you want to set a predefined static filter item as master filter for all the user and which is not editable by other users?   
   
Also current behavior is, if the user cleared the filter, it removed only for that particular user instance not for all the dashboard instances.   
   
   
Please let us know if you have any concerns.   
   
Regards,    Anandaraj R

Bruno Martoglio · Answer

Thank you very much for the quick  answer.
What I'm trying to do is to filter the information that the board shows, which only shows a commercial month. That's why the first thing I tried was to use a parameter. When I did not achieve it, I tried the filter.
But the ideal would be to use a parameter like this at sql query level.
I wait until the update.
Thank you very much.
regards

Sammanasu Mary Jesuraj · Answer

Hi Bruno,  

When you insert a new business date in the table, it will not reflect in the options of the parameter.   

If once data is updated in the data base, we need to update the dashboard parameter.  

Please follow the below steps to update dashboard parameter.  

Open the “Dashboard Parameter” window.
Select the parameter which was applied in the query.
Select any other column name on the display member .
Again choose the required column name in display member.
Now “Update” button will get enabled in Dashboard parameter window and click on “Update” button.
Now newly added data will be updated in parameter also.

Please let us know if you have any concerns. 

Regards,  Sammanasu Mary J

when you insert a new business date in the table, it is not reflected in the options of the parameter.	We were able to reproduce this issue and logged it in our issue tracking list. This fix will be available in our upcoming official release which planned on end of Feb 2018.
I tried using a master filter (in the filter panel). In this case, the filter options are updated with the database, but it gives the user the option to remove all the filters.	Please confirm your actual requirement, whether you want to set a predefined static filter item as master filter for all the user and which is not editable by other users? Also current behavior is, if the user cleared the filter, it removed only for that particular user instance not for all the dashboard instances.