Dashboard Begins Filter Error

Kinetic ERP
1

I’m trying to create a dashboard that filters using “BEGINS”.

image
image1196×542 23.7 KB

I added the “Begins” filter to the grid properties which works just as you’d expect; however, once I deploy the dashboard I get the following error and all of my filters seem to not work.

 Application Error

Exception caught in: Ice.Lib.EpiClientLib

Error Detail 
============
Message: Specified cast is not valid.
Program: Ice.Lib.EpiClientLib.dll
Method: NotifyAllOthers

Client Stack Trace 
==================
   at Ice.Lib.Framework.EpiTransaction.NotifyAllOthers(EpiDataView sourceView, Boolean changeGridPropsCurrentRowOnly, Boolean notifyTree, Guid notifyId)
   at Ice.Lib.Framework.EpiDataView.InnerNotify(EpiNotifyArgs args)
   at Ice.Lib.Framework.EpiDataView.SetCurrentRow(Int32 newRow, Boolean currentRowOnly)
   at Ice.Lib.Framework.EpiUltraGrid.OnBeforeCellActivated(Object sender, CancelableCellEventArgs ea)

I removed the begins filter from the grid and the error went away.

I also found that when I use “BEGINS” as a filter on the query itself it doesn’t error out but it goes too slow.

Has anyone else ran into this issue?

Thanks

2

Check your variable types - sounds like they’re different.

3

I wondered the same thing but the data types seem to match. Both are nvarchar x(500).

This is the data type of what is being published
BAQ Calculated Field

image
image2137×1331 139 KB

Dashboard Published Field
image
image3063×1885 194 KB

This is the data type of the field that is subscribing to the published field
BAQ Calculated Field

image
image2683×1371 203 KB

Dashboard Filter Subscriber
image
image3119×1871 193 KB

4

Was a solution ever found to this? I’m having similar issues when using the “begins” filter on my dashboard. It works when I am designing it but when I preview the dashboard it doesnt work just displays everything.

5

No sadly. My work around was modifying the query to take a parameter and use the begins functionally in the query. This worked but performance took a huge hit because it has to keep rerunning the query.

I’ve given up on classic dashboards and moved on to Kinetic, which has its own set of problems. I haven’t rebuilt this dashboard in Kinetic yet but I would be curious if the begins logic would work in Kinetic. When I get the time I’ll look at rebuilding it and post my results here.