Ticket S20272
Visible to All Users
Duplicate

We have closed this ticket because another page addresses its subject:

Add a control allowing the creation of any valid CriteriaOperator

FilterControl - Add a capability to add filter criteria for involving child objects

created 17 years ago

The filter control is a very nice addition to the XtraEditors library. However, I feel that it is limited in its usage due to the fact that you are only able to select properties that exist at the parent level. For example, if you have a 'Contact' object that has an 'Address' object which has properties like City, State and Zip Code, you can't filter a group of contacts based on a particular city or state becuase these are not exposed at this level. You could obviously create properties on the Contact object that simply refer to the Address.City etc. but this is merely a workaround. Neither does this solution work for collections of objects, for example maybe each Contact has a collection of Addresses.
I have been able to successfully modify the source code (not something easy but not something very hard either, especially for DevExpress) which gives me this capability with XPCollections. But I believe this should definately be something that is built into the control and would greatly improve its capabilites. Attached are some screen shots of what I have been able to accomplish. On the picture with the FilterControl, every column that has a "." (period) in it is accessing another objects properties. The picture with the drop down menu is using an XtraBars.PopupMenu (to get the 'LookAndFeel', however something that has a max size and scrollbars would be nice… I think that there is already a suggestion for this.)
Proposed Solution:
The filter editor should have the following capabilites:

  1. Able to filter any child objects whether a single object or a collection of objects and be able to do this to any level.
  2. Collections should be able to be filtered by count (equals, does not equal, greater than, less than, etc.)
  3. Collections should be able to be filtered by object type (if the collection is of a base type) (equals, does not equal)
  4. You should be able to up-cast a collection of objects to a derived type so that you can delve into the heirarchy of the derived type.
Comments (3)
SR SR
Steven Rasmussen 17 years ago

    Attached new document. The document explains additional capabilities and shows screenshots of how it is accomplished.

    Dennis Garavsky (DevExpress) 14 years ago

      We are planning to enhance the FilterControl in future versions of our libraries, by introducing features demonstrated in the XAF - Filter Editor Improvements in List Views (coming in v2011 vol1) blog. Please let us know your thoughts in comments to this blog.
      See Also:
      ASPxFilterControl - show properties list in a tree to provide a capability to use properties of the referenced objects in criteria
      Thanks,
      Dennis

      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.