Search results matching tag 'Auto-filtering'

AutoFilter popup width

David — Thu, 20 Dec 2012 16:37:09 GMT

I've enabled autofilter popups on my grid, which works well. However on one of the columns the text is too wide for the popup. How do I resize the popup to fit the text or enable a horizontal scroll bar?

Dave

Autofilter with additional rules

Chris — Thu, 09 Aug 2012 16:50:16 GMT

The autofilter control currently has a Clear button, and a checklist box, allowing one to check multiple values for filtering in a column. I'd like to add a 'Custom Filter Rules' entry to this control, which brings up a dialog that I would make, allowing the user to define one or more advanced filtering rules. Examples would be "Column Value [dropdown selection of: contains text/starts with/ends with/is greater than/etc] [user entered value]".

1. How would I add these custom rules to the Datagrid's filtering engine?

2. How would I update the autofilter control to add an item that would bring up this dialog?

Set Background on xcdg:ColumnManagerCell when AutoFilter is applied

Jason — Fri, 01 Jun 2012 06:51:03 GMT

My users would like the background of the column header to change when an autofilter is applied. I presume I need to do something similar to the following:

I can't figure what to put in the trigger property. I imagine I could use something like AutoFilterValues.Count = 0. How do I link the ColumnManagerCell to the AutoFilter for the column?

How to filter a multi-valued column?

thomas — Thu, 08 Mar 2012 10:45:25 GMT

Hi. Is there an example available that shows how to implement filtering on a column that allows multiple values (is bound to a Collection)?

Say I have a grid that shows events, where each event can have multiple speakers. A column titled "Speaker" would be rendered as a ListBox, per each row.

I would like to get the filter row to work with the multi-valued speaker column, so a user can enter "Scott" and see only the rows where Scott is a speaker. And/or get the Excel-like filtering to work with the column as well (the drop-down filtering option).

All the examples I have found so far have been with single-valued columns.

Autofilter with LinqToSql and SqlCE

Mike — Mon, 05 Apr 2010 23:02:58 GMT

I am using LinqToSql and SqlCE. When I do a autofilter in the Grid I
get the exception below. If I use the 3.5.9616.13400 version of the grid
I do not get a error. Is this a known issue? I filled out a Support Form with repro code.

System.NullReferenceException was unhandled
Message="Object reference not set to an instance of an object."
Source="Xceed.Wpf.DataGrid"
StackTrace:
       at Xceed.Wpf.DataGrid.FilterCell.UpdateFilterExpressionFromCriterion()
       at Xceed.Wpf.DataGrid.FilterCell.DataGridItemProperty_FilterCriterionChanged(Object sender, EventArgs e)
       at System.EventHandler.Invoke(Object sender, EventArgs e)
       at Xceed.Wpf.DataGrid.DataGridItemPropertyBase.RaiseFilterCriterionChanged()
       at Xceed.Wpf.DataGrid.DataGridItemPropertyBase.set_FilterCriterion(FilterCriterion value)
       at Xceed.Wpf.DataGrid.FilterCell.OnFilterExpressionChanged(DependencyObject sender, DependencyPropertyChangedEventArgs e)
       at System.Windows.DependencyObject.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
       at System.Windows.FrameworkElement.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
       at System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs args)
       at System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean coerceWithDeferredReference, OperationType operationType)
       at System.Windows.DependencyObject.SetValueCommon(DependencyProperty dp, Object value, PropertyMetadata metadata, Boolean coerceWithDeferredReference, OperationType operationType, Boolean isInternal)
       at System.Windows.DependencyObject.SetValue(DependencyProperty dp, Object value)
       at MS.Internal.Data.PropertyPathWorker.SetValue(Object item, Object value)
       at MS.Internal.Data.ClrBindingWorker.UpdateValue(Object value)
       at System.Windows.Data.BindingExpression.UpdateSource(Object value)
       at System.Windows.Data.BindingExpressionBase.UpdateValue()
       at System.Windows.Data.BindingExpression.Update(Boolean synchronous)
       at System.Windows.Data.BindingExpression.UpdateSource()
       at Xceed.Wpf.DataGrid.FilterCell.UpdateSource()
       at Xceed.Wpf.DataGrid.FilterCell.OnApplyFilterExecuted(Object sender, ExecutedRoutedEventArgs e)
       at System.Windows.Input.CommandBinding.OnExecuted(Object sender, ExecutedRoutedEventArgs e)
       at System.Windows.Input.CommandManager.ExecuteCommandBinding(Object sender, ExecutedRoutedEventArgs e, CommandBinding commandBinding)
       at System.Windows.Input.CommandManager.FindCommandBinding(CommandBindingCollection commandBindings, Object sender, RoutedEventArgs e, ICommand command, Boolean execute)
       at System.Windows.Input.CommandManager.FindCommandBinding(Object sender, RoutedEventArgs e, ICommand command, Boolean execute)
       at System.Windows.Input.CommandManager.OnExecuted(Object sender, ExecutedRoutedEventArgs e)
       at System.Windows.UIElement.OnExecutedThunk(Object sender, ExecutedRoutedEventArgs e)
       at System.Windows.Input.ExecutedRoutedEventArgs.InvokeEventHandler(Delegate genericHandler, Object target)
       at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
       at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
       at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
       at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
       at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
       at System.Windows.Input.RoutedCommand.ExecuteImpl(Object parameter, IInputElement target, Boolean userInitiated)
       at System.Windows.Input.RoutedCommand.ExecuteCore(Object parameter, IInputElement target, Boolean userInitiated)
       at System.Windows.Input.CommandManager.TranslateInput(IInputElement targetElement, InputEventArgs inputEventArgs)
       at System.Windows.UIElement.OnKeyDownThunk(Object sender, KeyEventArgs e)
       at System.Windows.Input.KeyEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
       at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
       at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
       at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
       at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
       at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
       at System.Windows.Input.InputManager.ProcessStagingArea()
       at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
       at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
       at System.Windows.Interop.HwndKeyboardInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawKeyboardActions actions, Int32 scanCode, Boolean isExtendedKey, Boolean isSystemKey, Int32 virtualKey)
       at System.Windows.Interop.HwndKeyboardInputProvider.ProcessKeyAction(MSG& msg, Boolean& handled)
       at System.Windows.Interop.HwndSource.CriticalTranslateAccelerator(MSG& msg, ModifierKeys modifiers)
       at System.Windows.Interop.HwndSource.OnPreprocessMessage(Object param)
       at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Boolean isSingleParameter)
       at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Boolean isSingleParameter, Delegate catchHandler)
       at System.Windows.Threading.Dispatcher.WrappedInvoke(Delegate callback, Object args, Boolean isSingleParameter, Delegate catchHandler)
       at System.Windows.Threading.Dispatcher.InvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Boolean isSingleParameter)
       at System.Windows.Threading.Dispatcher.Invoke(DispatcherPriority priority, Delegate method, Object arg)
       at System.Windows.Interop.HwndSource.OnPreprocessMessageThunk(MSG& msg, Boolean& handled)
       at System.Windows.Interop.HwndSource.WeakEventPreprocessMessage.OnPreprocessMessage(MSG& msg, Boolean& handled)
       at System.Windows.Interop.ComponentDispatcherThread.RaiseThreadMessage(MSG& msg)
       at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
       at System.Windows.Threading.Dispatcher.PushFrame(DispatcherFrame frame)
       at System.Windows.Threading.Dispatcher.Run()
       at System.Windows.Application.RunDispatcher(Object ignore)
       at System.Windows.Application.RunInternal(Window window)
       at System.Windows.Application.Run(Window window)
       at System.Windows.Application.Run()
       at XceedFilterRepo.App.Main() in C:\Users\mikebu\Documents\Visual Studio 2008\Projects\XceedFilterRepo\obj\Debug\App.g.cs:line 0
InnerException:

Add All DistinctValues To AutoFilterValues

Yaniv — Tue, 16 Mar 2010 11:08:38 GMT

Hi,

I added a button in the AutoFilterControl to enable the user selecting all the distinct values.

Code sample:

System.Collections.IList distinctValues = view.DistinctValues[sColumnFieldName];

foreach (object value in distinctValues)

{

view.AutoFilterValues[sColumnFieldName].Add(value);

}

The problem is that if i have a long list of distinct values that process takes a lot of time ...

My question : is there a way to add a range of values to the AutoFilterValues collection (i can see that it is xceed custom collection)

Null values in autofilters

Tony — Tue, 09 Feb 2010 00:52:07 GMT

Hi all.

I have a datagrid showing data from an ODE DataTable, and I have autofiltering enabled. Very cool. But I would like the autofilter drop-down lists to include "null" as one of the distinct values available for filtering. How can I achieve this?

AutoFilter FilterToggleButton Visibility

Yaniv — Mon, 01 Feb 2010 08:29:21 GMT

Hi,

How can i make the FilterToggleButton Visibility to be visible all the time (not only triggered by IsMouseOver)

Batch autofiltering

Turner — Wed, 13 Jan 2010 19:24:02 GMT

Is there a way to apply filter values in a batch, rather than adding each value to the DataGridCollectionView's AutoFilterValues collection, one by one?

Excluding some specific Row(s) from automatic filtering.

Aashay — Tue, 22 Sep 2009 08:58:22 GMT

Hi Support,

I am new to Xceed DataGridControl, however I am too much fascinated with the UI and features of this control.

I am using “ObservableCollection --> DataGridCollectionView --> DataGridControl” squad. I have a requirement where the grid should filter the records according to filter criterion selected by user. It is really cool to see the Excel like filtering in the XceedGrid using:

myDataGridCollectionView.AutoFilterMode = AutoFilterMode.And;

However at the same time I need to exclude some records from being filtered out, that is, they are required to be present all the time irrespective of the filters applied by user.

Is there any direct or indirect way to achieve this? If required for this particular problem, I can even group the records within two groups, i.e. filterable /non-filterable.

Waiting for the words of support