I have classic ux dashboard that is was working fine, but over time it has slowed as the data increase. I have a created an external table to gather all the data required for the old dashboard. I created a new dashboard referencing the external database table. I have four tracker query controls, three work great, but the fourth does not. These are copied from the setup of the old dashboard. This EpiCombo differs from the others in that it uses BO:Warehse to populate the dropdown list. The value member and display member exists in the new eternal table and warehouse codes match exactly to those in the Epicor Warehouse table. This work great in the old dashboard, but will not filter in the new dashboard with the external table. I can’t see why it would not work as the value member selected in the EpiCombo exists in the new table. Any ideas?
This is a long shot, but try changing from ListDataSet to RowsDataSet, we had to do that every time we used the UserCodes table. Maybe that table also needs it.
Hi, Mike,
It’s been a while since I looked at a Classic Dashboard. Just to cover the bases, in your Grid properties, do you have the filter to use the input prompts only, and that pointing to the Combo Box for the Warehouse Codes?
