Support Request

[Martin]

Richard,

You may be aware of some support questions raised by Fathi Bellahcene at Total in Paris. He works for me. He's on a public holiday today in France so I can't contact him to get our support account details. I need to raise some support issues with you guys. Is it possible you could contact me at [e-mail] please ?

[Richard Slade]

Hello Martin,

Sadly, I don't work for Telerik, I am just another user of the forums. You can open support tickets in the normal way, or if you post your questions here in the forums, I (or one of the other regular visitors to the forums) will be happy to help.

All the best
Richard

[Martin]

Well thanks Richard, I really appreciate your earlier help particularly now, because I thought I was receiving responses from a telerik moderator. Thats great of you to help.

[Richard Slade]

No problem Martin. Glad to be able to help. Is there something I can do for you now?
Richard

[Martin]

Well if you're kind enough to offer - we have a major problem with the Telerik grid.

We bind some simple data to it (an IList<T>) and one of the columns contains a DateTime.

When we filter on that column the filter does not seem to offer the ability to alter the Time portion in the filter value.

Basically we want to filter a DateTime column without being concerned about the Time portion, just the Date value really.

Can't see a way to do that and it's a bit of a show stopper for us. The other problem is we are having to use Q2 2010 SP1 as there are some other bugs in SP2 that we can't go with.

Any pointers to events we could use, work-arounds etc would be very helpful.

Martin

[Richard Slade]

Hi Martin,

My immediate thought is to have a second column with just the date portion in it and allow filtering on that, and not on the one with the datetime, but I will look into this for you and let you know if I find another way as soon as possible.

Richard

[Martin]

Richard, thanks, yes I thought of that approach too. Problem is we can have quite a few DateTime columns and to split them all out is not ideal. Plus the grid seems to slow down noticeably when you go much beyond a dozen columns. I will wait to see if you come up with anything else with interest. Where are you based by the way ? any chance we could buy you a beer for your trouble ?

[Richard Slade]

Hi Martin,

I've come up with a workaround, but it does involve having another column. However, the extra column is hidden and therefore I don't think this would affect performance (which I think was your concern).

The below example changes the FilterExpression at the last possible moment to change the MyDateTime column in the filter expression to MyDate.

Let me know if that helps.

Imports Telerik.WinControls
Imports Telerik.WinControls.UI

Public Class Form1

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("en-US")

        Me.RadGridView1.Columns.Add(New GridViewDateTimeColumn("MyDateTime"))
        Me.RadGridView1.Columns.Add(New GridViewDateTimeColumn("MyDate"))

        Me.RadGridView1.Columns("MyDate").IsVisible = False

        Dim rowInfo As GridViewRowInfo = Me.RadGridView1.Rows.AddNew()
        rowInfo.Cells(0).Value = New DateTime(2010, 11, 20, 9, 23, 33)
        rowInfo.Cells(1).Value = New DateTime(2010, 11, 20)
        rowInfo = Me.RadGridView1.Rows.AddNew()
        rowInfo.Cells(0).Value = New DateTime(2010, 6, 15, 4, 20, 37)
        rowInfo.Cells(1).Value = New DateTime(2010, 6, 15)
        Me.RadGridView1.MasterTemplate.BestFitColumns()

    End Sub

    Private Sub RadGridView1_FilterExpressionChanged(ByVal sender As System.Object, ByVal e As Telerik.WinControls.UI.FilterExpressionChangedEventArgs) Handles RadGridView1.FilterExpressionChanged
        e.FilterExpression = e.FilterExpression.Replace("MyDateTime", "MyDate")
    End Sub

End Class

Richard


//Off topic - I live and work on the South Coast of England. May be a long way for a beer!, but I'm happy to be able to help.
Richard

[Martin]

Richard, thanks so much for your help with that suggestion. I will forward the code to my developer in Paris, he'll give that a go tomorrow I hope. I will let you know the outcome. Looks hopeful to me.
Cheers
Martin

[Richard Slade]

Hi Martin,

I'll look forward to hearing back from you. I'd only ask that if this works for you, that it is marked as answer, but if you need more help, just let me know.

All the best
Richard

[Richard Slade]

Hi Martin,

Just wondered how your developer got on with implementing the change, and if it worked for you.
Best wishes

Richard

[Stefan]

Hello guys, 

Martin, I hope that you find the solution provided by Richard helpful. Please let us know if you need further assistance.

Richard, thank you for your help.
 
Sincerely yours,
Stefan
the Telerik team

[Martin]

Thanks for your assistance Richard, I've just heard that the ideas you suggested led to a successful work-around for this problem. I've marked your suggestion as an answer.

Regards
Martin

[Richard Slade]

Hi Martin,

I'm really glad that worked for you.
All the best
Richard