This is a migrated thread and some comments may be shown as answers.

Support Request

13 Answers 113 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Martin
Top achievements
Rank 1
Martin asked on 11 Nov 2010, 10:30 AM
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 martin.ramsey@total.com please ?

13 Answers, 1 is accepted

Sort by
0
Richard Slade
Top achievements
Rank 2
answered on 11 Nov 2010, 10:33 AM
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
0
Martin
Top achievements
Rank 1
answered on 11 Nov 2010, 12:15 PM
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.
0
Richard Slade
Top achievements
Rank 2
answered on 11 Nov 2010, 12:19 PM
No problem Martin. Glad to be able to help. Is there something I can do for you now?
Richard
0
Martin
Top achievements
Rank 1
answered on 11 Nov 2010, 12:25 PM
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
0
Richard Slade
Top achievements
Rank 2
answered on 11 Nov 2010, 01:22 PM
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
0
Martin
Top achievements
Rank 1
answered on 11 Nov 2010, 01:43 PM
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 ?
0
Accepted
Richard Slade
Top achievements
Rank 2
answered on 11 Nov 2010, 03:09 PM
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
0
Martin
Top achievements
Rank 1
answered on 11 Nov 2010, 03:16 PM
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
0
Richard Slade
Top achievements
Rank 2
answered on 11 Nov 2010, 03:20 PM
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
0
Richard Slade
Top achievements
Rank 2
answered on 12 Nov 2010, 06:28 PM
Hi Martin,

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

Richard
0
Stefan
Telerik team
answered on 17 Nov 2010, 08:49 AM
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
See What's New in RadControls for WinForms in Q3 2010 on Wednesday, November 17, 11am Eastern Time: Register here>>
0
Martin
Top achievements
Rank 1
answered on 17 Nov 2010, 11:28 AM
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
0
Richard Slade
Top achievements
Rank 2
answered on 17 Nov 2010, 11:32 AM
Hi Martin,

I'm really glad that worked for you.
All the best
Richard
Tags
General Discussions
Asked by
Martin
Top achievements
Rank 1
Answers by
Richard Slade
Top achievements
Rank 2
Martin
Top achievements
Rank 1
Stefan
Telerik team
Share this question
or