Ticket T166826
Visible to All Users

ASPxFilterControl - Support predefined operations for date columns like in WinForms

created 10 years ago

Hi. I'm using the OperationVisibility event of the ASPxFilterControl to customise the list of operators available for each column. I notice under ClauseType there are a variety of predefined date filters like IsToday, IsTomorrow, IsEarlierThisWeek, however I can't make them visible. I presume this is because they're used by the WinForms controls instead, but is there any reason they couldn't be made available in the ASPxFilterControl as well?

Regards,
Stuart.

Answers approved by DevExpress Support

created 10 years ago

Hi,

These operations weren't implemented in ASPxFilterControl, so you can't make them visible. However, ASPxGridView can work with these criteria, so you can apply this filter using the ASPxGridView.FilterExpression Property. Let me know if you have further questions.

    Show previous comments (4)
    EP EP
    Eugene Paradizov 10 years ago

      This functionality is sorely needed. Many of our users are asking for this. We allow our user to save grid layout. They can later pick it from a list and restore the layout as they had it. However, the need to be able to filter date fields based on relative dates. They need to be able to say [SomeDateField] >= TODAY. And, be able to save that as grid's layout for later retrieval. Please provide a work-around on how this can be done. Also, besides being able to use relative dates, they need to retain the ability to filter using absolute values.
      If the grid control would allow to compare fields, such as [Field1] [Comparison] [Field2], then I could add a field called [Today] into the grid and let users compare to that field. But, this option is also missing. Please provide a usable work-around.

      Anthony (DevExpress Support) 10 years ago

        Hello,

        To process your recent post more efficiently, I created a separate ticket on your behalf: T268885: ASPxGridView - How to use date constants in filter. This ticket is currently in our processing queue. Our team will address it soon.

        Svetlana Nikulina (DevExpress) 9 years ago

          Please take note of a similar functionality implemented in version 15.2 in the context of the following feature: ASPxFilterControl - Support predefined operations for date columns

          Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

          Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.