Filter DateTime using 'Now()' or Getdate()

[cm]

Hi All,
I'm wondering if there is a best practice to filter DateTime Values - but using a runtime 'current time' value.
(Example: Filter All 'events' WHERE StartTime < getDate())
Thx

[Nikolay Rusev]

Hello Chris,

I am afraid that I do not completely understand your question. RadFilter offers UI for user to build complex filter criteria. Thus when filter on field which type is DateTime, the user should choose the date from UI.

Greetings,
Nikolay
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[chris mcmurray]

Hi,

To Clarify; The issue is about trying to use a "RunTime" Date when filtering by date.

We are using RadFilter to allow Users to Build & Save Filters. They will run at a later date.

I would like to use the Date that they Run...NOT the date they are Saved.

Example:

Data: Concerts Dates - From Jan 2009- Jan 2015

Objective: Show Next Available ConcertDates  (based on Runtime Date)

Filter Saved on April 2010

RunTime : May 2014

Filter Should kind of Look Like: 'SELECT * FROM Concerts WHERE DateStart <= eval'getDate()'

Anyway to do this kind of thing?

Thanks

CM

[Nikolay Rusev]

Hello Chris,

I am afraid that this is not supported by RadFilter. In general you can get the collection of build expression by RadFilter in RootGroup. Using the collection you can build your custom expression that will be saved.

Kind regards,
Nikolay
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[apb]

I have the same need for relative date filters. We also persist the filters and date filters such as "1 Day", "1 Week", etc, would  be far more useful.

[Nikolay Rusev]

Hello Al,

I can offer you implementing custom editor for RadFilter that have an option for choosing options. I have attached sample implementation to this post. Give it a try.

All the best,
Regards
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[cm]

Hi guys,
first of all - thanks for the Code & the effort.
My Question is this:

"OnFieldEditorCreating" and class RadFilterFieldEditorCreatingEventArg...

I don't seem to have these in my version of RadFilter...
Is this code for the upcoming Q2 release?

Thanks,

[Sebastian]

Hello chris,

If you use the latest SP release of the suite (2010.1.519), you should have OnFieldEditorCreating server event exposed for RadFilter. Upgrade instructions are available here.

Best regards,
Sebastian
the Telerik team

[Anne]

I try to add this code in my asp.net application in vb with visual studio 2008.

I add

<%

@ Register TagPrefix="custom" Namespace="FilterEditors" %>

 

 

 

 

 

 in my page
and FilterEditors.vb in my solution

but Imports FilterEditors is not recognize.
I have the same probleme with namespace CustomEditors to do RadFilterDropDownEditor

Will you add an expression like date() and date()+1, and 'RadFilterDropDownEditor' in a next release ?

Anne

[Nikolay Rusev]

Hello Anne,

Bellow you can find VB version of the page from my previous posts.

Regards,
Nikolay
the Telerik team

[Anne]

Thanks Nikolay
I will test it soon.

[Anne]

Hello Nikolay,

<

 

custom:MyEditor> is not recognize in my web application.

I add namespace="FilterEditors" in the web.config : no success !

Anne

 

 

[Anne]

Hello Nikolay,

I find my problem. My solution :

<%

@ Register TagPrefix="custom" Namespace="MyProject" Assembly="MyProject" %>
and I don't use namespace in the assembly 'MyEditor'

Anne

 

[Anne]

Hello Nikolay,

I undestand why my code doesn't work. I try to add FieldEditors to my RadFilter. But my RadFilter has a FilterContainerID.

Sometime, I have more than 50 columns in my container so I don't want make 50 FieldEditors.

So I make my owner filter to use getdate() or getdate()-1 or getdate()+4.

Anne