Hi, I'm having issue with save/load layout of a grid control.

I have a date column that I filter between date 1 and date 2. If I save the layout I cannot reload it. I get an error message in Visual Studio :

Exception has been thrown by the target of an invocation.
{"Invalid filter expression."}

I noticed that the filter menu changed since last version and I can now select dates with a calendar control instead of a textbox. Maybe it has something to do with it...


thanks

Hello,

Perhaps you can post a sample. I know that whenever we upgrade to a new version of the controls, we delete all of the saved layout files as changes in the grid often make older ones incompatible with the newer versions. I'd first try deleting all of your saved layout files and then firing up the app and saving and loading the layout again.

regards,
Richard

Hi Richard, thanks for your quick response.

I tried deleting the old layout. I works fine until you set a range of date again.  I have a complex project so it's hard to post a sample but I guess it can be reproduced by doing these steps :

1- Apply filter in a date column by choosing Between.
2- Leave default settings (change dates) and confirm
3- Save layout
4- Close the form
5- Open the form and load the layout

Let me know if I can provide further details

thanks a lot

Hey again, I have other information.

I tried to filter using Between again, but this time I didn't change the dates, left them as is. I got no problem. So it seems that it happens if you change the dates.

The other thing I noticed, today on my computer is 04-01-2011 which is January 4th 2011. When I do that in the filter section and I save the layout and load it back, it shows 01-04-2011 which is April 1st 2011. I'm not sure what I can do about that?

Thanks a lot

Hello Marc André

I can reproduce a similar bug here with my app (2010Q3). When I load a layout with a Between Filter on a Date Column.

Telerik.WinControls.Data.FilterExpressionException: Invalid filter expression. ---> Telerik.Data.Expressions.InvalidExpressionException: Cannot perform '>=' operation on System.DateTime and System.String.
   at Telerik.Data.Expressions.Operator.BinaryCompare(Object value1, Object value2, StorageType resultType, Operator op, IFormatProvider formatProvider)
   at Telerik.Data.Expressions.Operator.GreaterOrEqualFunc(Operand lhs, Operand rhs, OperatorContext context)
   at Telerik.Data.Expressions.BinaryOpNode.Eval(Object row, Object context)
   at Telerik.Data.Expressions.Operand.get_Value()
   at Telerik.Data.Expressions.Operator.AndFunc(Operand lhs, Operand rhs, OperatorContext context)
   at Telerik.Data.Expressions.BinaryOpNode.Eval(Object row, Object context)
   at Telerik.Data.Expressions.Operand.get_Value()
   at Telerik.Data.Expressions.Operator.RValueFunc(Operand rhs, OperatorContext context)
   at Telerik.Data.Expressions.UnaryOpNode.Eval(Object row, Object context)
   at Telerik.WinControls.Data.RadCollectionView`1.PerformExpressionFilter(TDataItem item)
   --- End of inner exception stack trace ---
   at Telerik.WinControls.Data.RadCollectionView`1.PerformExpressionFilter(TDataItem item)
   at Telerik.WinControls.Data.RadCollectionView`1.PassesFilter(TDataItem item)
   at Telerik.WinControls.Data.AvlIndex`1.Perform()
   at Telerik.WinControls.Data.AvlIndex`1.get_Items()
   at Telerik.WinControls.Data.RadDataView`1.get_Items()
   at Telerik.WinControls.Data.RadCollectionView`1.get_Count()
   at Telerik.WinControls.Data.RadCollectionView`1.get_CurrentItem()
   at Telerik.WinControls.Data.RadDataView`1.RebuildData(Boolean notify)
   at Telerik.WinControls.Data.RadDataView`1.RefreshOverride()
   at Telerik.WinControls.Data.RadDataView`1.ProcessCollectionChanged(NotifyCollectionChangedEventArgs args)
   at Telerik.WinControls.Data.RadCollectionView`1.source_CollectionChanged(Object sender, NotifyCollectionChangedEventArgs e)
   at Telerik.WinControls.Data.NotifyCollectionChangedEventHandler.Invoke(Object sender, NotifyCollectionChangedEventArgs e)
   at Telerik.WinControls.Data.RadListSource`1.OnCollectionChanged(NotifyCollectionChangedEventArgs e)
   at Telerik.WinControls.Data.RadListSource`1.EndUpdate(Boolean notifyUpdates)
   at Telerik.WinControls.UI.GridViewTemplate.EndUpdate(Boolean notify, DataViewChangedEventArgs e)
   at Telerik.WinControls.UI.MasterGridViewTemplate.EndUpdate(Boolean notify, DataViewChangedEventArgs e)
   at Telerik.WinControls.UI.GridViewTemplate.EndUpdate()
   at Telerik.WinControls.UI.RadGridView.LoadLayout(XmlReader xmlReader)
   at Telerik.WinControls.UI.RadGridView.LoadLayout(String fileName)
   at puttymgr.Controls.QueryViewUserControl.Initialize()
   at puttymgr.MainForm.n1spsPage_HandleCreated(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnHandleCreated(EventArgs e)
   at System.Windows.Forms.Control.WmCreate(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3615 (GDR.050727-3600)
    CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
puttymgr
    Assembly Version: 2.1.4003.23680
    Win32 Version: 2.1.0.0
    CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/puttymgr.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3614 (GDR.050727-3600)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Telerik.WinControls.UI
    Assembly Version: 2010.3.10.1109
    Win32 Version: 2010.3.10.1109
    CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/Telerik.WinControls.UI.DLL
----------------------------------------
Telerik.WinControls
    Assembly Version: 2010.3.10.1109
    Win32 Version: 2010.3.10.1109
    CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/Telerik.WinControls.DLL
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
TelerikCommon
    Assembly Version: 2010.3.10.1109
    Win32 Version: 2010.3.10.1109
    CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/TelerikCommon.DLL
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
y6thyy47
    Assembly Version: 2010.3.10.1109
    Win32 Version: 2.0.50727.3614 (GDR.050727-3600)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Telerik.WinControls.GridView
    Assembly Version: 2010.3.10.1109
    Win32 Version: 2010.3.10.1109
    CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/Telerik.WinControls.GridView.DLL
----------------------------------------
System.Core
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.1 built by: SP
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.DirectoryServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.DirectoryServices/2.0.0.0__b03f5f7f11d50a3a/System.DirectoryServices.dll
----------------------------------------
Npgsql
    Assembly Version: 2.0.11.0
    Win32 Version: 2.0.11.0
    CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/Npgsql.DLL
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Mono.Security
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.0.0
    CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/Mono.Security.DLL
----------------------------------------

forgot to mention that I'm using Q3 2010 SP1

Hello,

I can confirm I can also replicate it on our system. I set a between filter on a date column and save the layout. Re-load and have the error stack as shown by Erwin. Telerik admins are quick to read these forum posts, so hopefully this will be fixed in the next release.
Richard

OK, have narrowed it down further:

Seems to be connected to the locale setting of the computer. In European Countries, when loading the date, day and month are exchanged. If there is still a valid date, no problem (for example  01-05-2010 / 05-01-2010 will just give unexpected results, but no exception, 12-31-2010 / 31-12-2010 however will throw an exception.

Also I guess that with a less or equal filter on a date/time, the time value should be 23:59:59 not 00:00:00.

Another bug I have noticed is that the between filter dialog does not keep its previous values.

Regards
Erwin

I would suggest that the layout should persist date/time values using an XML standard format such as
2002-05-30T09:00:00
and not something that depends on the current locale settings.

Any suggestion in a way to work around this?

thanks for your efforts guys

Maybe fiddling around with the locales before save / load of layout could help until the bug is fixed.
Make sure to restore to the previous values afterwards.

However, IMHO best solution is to wait for the bugfix release from Telerik. At least my user base seems not to use complex filters like this much, otherwise I would have got a bug report since the 2010Q3 based release (Mid November 2010).

Regards
Erwin

Hi,

Yes, it does seem to be fine as you've suggested Erwin just by setting the

We have to keep our dates in en-GB format but like you, our users don't implement complex filters.
@Marc-Andre - as Erwin suggested, I think this may be the only useable option for the time being.

Regards,
Richard

Be aware though that this may lead to other problems if locale dependent formatting is used on the values of any other filter in the grid.

IMHO the persistence format for load layout / save layout should be absolutely neutral to locale settings. Think of layout files that are used on a computer with a different locale than they were generated.

Regards
Erwin

Thanks for provinding these solutions. I will try your suggestions and let you know.

Hi guys, I tested the use of different culture before loading the layout and it seems to help preventing the annoying exception. But I still experience an issue when I try to change the filter, it says: String was not recognized as a valid DateTime..


Thanks again for your help

Hello everybody, I filed a bug report Ticket ID 381468, to keep track on this bug, would like to see it in PITS.

Regards
Erwin

Hi guys,

Thank you for investigating the issue in detail. We are aware of it and it will be addressed in one of the next releases. We have logged the issue in our Public Issue Tracking System.

Regards,
Martin Vasilev
the Telerik team

I would like to add another issue. I think it is related to the same thing. Here's what I did to reproduce the problem.

• Set the date column filter to : greater or equal to
• Select a date from the filter
• The grid shows me correct information.
• Before I save the layout, I remove the filter from the date column otherwise I'm going to get the error message described previously.
• Save the layout.
• Close the form and reopen it.
• Load grid's layout.
• Set the column filter to : greater or equal to
• Select a date from the filter

The grid doesn't show me the correct information, it shows only the values greater than. The thing is, on my computer I do not have the issue. But on some of the client workstations, it does that. My point of view is that the grid's filter is not using the proper date format...

If this can be addressed at the same time it would be great.

Thanks

Hi,

Just a thought - sometimes had issues like this (in my own code, not with the grid so far) if the datetime/timestamp resolution was not exactly the same.
For example internal resolution in the database is in milliseconds and the value you store/compare to has just seconds. You will not find an exact match unless you are really lucky (1:1000) 

Regards
Erwin

Thanks Erwin.. I wish it just that.. but the behavior is always the same if I repeat these steps and it differs from one PC to another depending on the locale.. there's got to be something wrong in the save layout procedure.

thanks

Hi folks,

We have made the save/load layout feature culture independent and the change will be available in the upcoming Q1 2011 release. I hope this will resolve the described DateTime filtering issues.

Regards,
Martin Vasilev
the Telerik team

apparently does not work with Q1 2011, still throws invalid filter expression exception.

The filter is still serialized in US American Format MM/DD/YY where a standard with no possibility of confusion should be used such as ISO:
YYYY-MM-DD.

Hi erwin,

Thank you for contacting us.

Although we have changed the save/load layout to work only with invariant culture, we have still missed some specific scenarios, which leads to described exception. The fix for them will be available in Q1 2011 Service Pack 1 release.

Write me back if you have any other questions.

All the best,
Martin Vasilev
the Telerik team

Hi,

I am getting a similar issue using version 2012.3.1211.40 wherby dates used in the between filter are being saved in an American format. This then gives rise to the error below when trying to perform a LoadLayout.

"String was not recognized as a valid DateTime"

thanks,
John.

Hello John,

Thank you for reporting this issue.

This is a regression one and I am reopening the case. Is it possible to send us the problematic XML file? This will allow us to make sure that your case is covered.

Note that you have to open a new support ticket in order to be able to attach your file.

Regards,
Peter
Telerik

Hi Peter

The first xml is saving a between dates filter for 24th May 2013. You can see the format is American (mm/dd/yyyy). The second xml is saving an equals date filter and the format is correct, UK (dd/mm/yyyy).

Hope this helps,
Thanks,
John.

Hello John,

Thank you for the provided XML files. 

Are these files generated on the same PC? Could you share more details about the PC the files were generated on, like Operating System, Regional Settings, which versions of our controls are installed on these machines?

Regards,
Peter
Telerik

Hi Peter,

Yes, same pc. Windows 7. Grid version 2012.3.1211.40. Regional setting English (United Kingdom).

A tester also replicated on windows xp.

thanks,
John.

Hello John,

Thank you for the provided details. As I mentioned before I reopened the case and we will address it accordingly in a future release. I hope that the workaround from this forum thread is applicable for your case, until the issue is resolved.

Regards,
Peter
Telerik