Hi,

Is there any way we can have multiple columns based filtering in MultiColumnCombo...

Example:

RadMultiColumnComboBoxElement

 

multiColumnComboElement = this.mcboSample.MultiColumnComboBoxElement;

 

multiColumnComboElement.EditorControl.MasterGridViewTemplate.AutoGenerateColumns =

false;

 

multiColumnComboElement.Columns.Add(

new GridViewTextBoxColumn("Code"));

 

multiColumnComboElement.Columns.Add(

new GridViewTextBoxColumn("RealName"));

 

multiColumnComboElement.Columns.Add(

new GridViewTextBoxColumn("NickName"));

 

multiColumnComboElement.Rows.Add(

"1011", "Paul Wight, Jr.", "Big Show");

 

multiColumnComboElement.Rows.Add(

"1022", "Carlos Colón, Jr.", "Carlito");

 

multiColumnComboElement.Rows.Add(

"2031", "Matthew Korklan", "Evan Bourne");

 

multiColumnComboElement.Rows.Add(

"2032", "Mike Mizanin", "The Miz");

 

multiColumnComboElement.Rows.Add(

"4101", "Paul Levesque", "Triple H");

 

 

 

this.mcboSample.AutoFilter = true;

 

 

this.mcboSample.DisplayMember = "NickName";

 

 

 

FilterExpression filter = new FilterExpression(this.mcboSample.DisplayMember, FilterExpression.BinaryOperation.AND,

 

 

GridKnownFunction.Contains, GridFilterCellElement.ParameterName);

 

filter.Parameters.Add(

GridFilterCellElement.ParameterName, true);

 

 

this.mcboSample.EditorControl.MasterGridViewTemplate.FilterExpressions.Add(filter);

The above works fine based on NickName but I would have like have one more filter option based on RealName as well.

Thanks

Br,
MKK

 

Hi Mukesh Kapoor,

Thank you for contacting us. You may find more information regarding filter expressions here. You can create a second filter expression as follows:


Please provide the reason that the type of the parameter value is Boolean when the filtered columns is a string type?

Best wishes,
Svett
the Telerik team

Hello,
still am having some problem while selecting the values from the GridViewMultiComboBoxColumn.

For Example:

In TextChanged event while filter the values it throws an exeception "The collection already contains a FilterExpresion for the field 'RealName'.

 

using

 

System.Windows.Forms; 
using Telerik.WinControls.UI;

 

 

 

using Telerik.WinControls.Data;

 

 

 

using System.Data;

 

 

 

using Telerik.WinControls;

 

 

using System.Threading;

 

 

 

 

namespace

 

 

MultiComboApp

 

{

 

 

public partial class Form3 : Form

 

 

 

 

{

 

 

public Form3()

 

{

InitializeComponent();

}

 

 

FilterExpression filterRealName;

 

 

 

FilterExpression filterNickName;

 

 

 

FilterExpression filterCode;

 

 

 

DataTable dtData;

 

 

 

private void LoadTable()

 

{

dtData =

 

new DataTable();

 

dtData.Columns.Add(

 

"Code");

 

dtData.Columns.Add(

 

"RealName");

 

dtData.Columns.Add(

 

"NickName");

 

dtData.Rows.Add(

 

new object[] { "1011", "dinesh", "din13" });

 

dtData.Rows.Add(

 

new object[] { "1022", "dineshkumar", "Guru23" });

 

dtData.Rows.Add(

 

new object[] { "2031", "Vijay", "Vin31" });

 

dtData.Rows.Add(

 

new object[] { "2032", "Vignesh", "Vick32" });

 

dtData.Rows.Add(

 

new object[] { "4101", "Senthil", "sen01" });

 

}

 

 

private void FillGrid()

 

{

 

 

 

GridViewMultiComboBoxColumn gvmcTest = new GridViewMultiComboBoxColumn();

 

gvmcTest.DataSource = dtData;

gvmcTest.AutoCompleteMode =

 

AutoCompleteMode.SuggestAppend;

 

gvmcTest.DropDownStyle =

 

RadDropDownStyle.DropDown;

 

gvTest.Columns.Add(gvmcTest);

gvTest.Columns[0].Width = 300;

filterRealName =

 

new FilterExpression("RealName", FilterExpression.BinaryOperation.OR,

 

 

 

GridKnownFunction.StartsWith, GridFilterCellElement.ParameterName);

 

filterNickName =

 

new FilterExpression("NickName", FilterExpression.BinaryOperation.OR,

 

 

 

GridKnownFunction.StartsWith, GridFilterCellElement.ParameterName);

 

filterCode =

 

new FilterExpression("Code", FilterExpression.BinaryOperation.OR,

 

 

 

GridKnownFunction.StartsWith, GridFilterCellElement.ParameterName);

 

}

 

 

 

private void Form1_Load(object sender, System.EventArgs e)

 

{

LoadTable();

FillGrid();

}

 

 

 

private void gvTest_CellEditorInitialized(object sender, GridViewCellEventArgs e)

 

{

 

 

RadMultiColumnComboBoxElement comboColumn = (RadMultiColumnComboBoxElement)this.gvTest.ActiveEditor;

 

comboColumn.AutoSizeDropDownToBestFit =

 

true;

 

comboColumn.AutoFilter =

 

true;

 

comboColumn.TextChanged +=

 

new System.EventHandler(editor_TextChanged);

 

}

 

 

void editor_TextChanged(object sender, System.EventArgs e)

 

{

 

 

RadMultiColumnComboBoxElement editor = (RadMultiColumnComboBoxElement)this.gvTest.ActiveEditor;

 

 

 

string sText = editor.Text.Trim();

 

 

 

// When the lock is obtained, add an element.

 

 

 

 

 

 

editor.EditorControl.MasterGridViewTemplate.FilterExpressions.Remove(filterRealName);

editor.EditorControl.MasterGridViewTemplate.FilterExpressions.Remove(filterNickName);

editor.EditorControl.MasterGridViewTemplate.FilterExpressions.Remove(filterCode);

filterRealName.Parameters.Clear();

filterNickName.Parameters.Clear();

filterCode.Parameters.Clear();

filterRealName.Parameters.Add(

 

GridFilterCellElement.ParameterName, sText);

 

filterNickName.Parameters.Add(

 

GridFilterCellElement.ParameterName, sText);

 

filterCode.Parameters.Add(

 

GridFilterCellElement.ParameterName, sText);

 

editor.EditorControl.MasterGridViewTemplate.FilterExpressions.Add(filterRealName);

editor.EditorControl.MasterGridViewTemplate.FilterExpressions.Add(filterNickName);

editor.EditorControl.MasterGridViewTemplate.FilterExpressions.Add(filterCode);

editor.EditorControl.GridElement.Update(

 

GridUINotifyAction.FilteringChanged);

 

}

 

}

}

 

Hello dinesh kumar,

Thank you for contacting us. You can try to Clear the FilterExpresionCollection before adding the new filter expressions:


Sincerely yours,
Julian Benkov
the Telerik team

Hi there,
I was actually using the same code snippet in the TextChanged event handler but still that does not work properly. It does filtering but when trying to select value from the filtered drop down list(in my example typing 'C' filters the list and displays 3 items in the drop down list: Cabbage, Carrot, Corn). But when I try to select any of them the first value from the DataSource(in my case it is List<string>) is picked up and displayed in the drop down automatically. Any ideas?

Thanks,
Dima

Hello Dzimitry,

Although it is possible to define multiple filter expressions based on different columns in the grid view of the RadMultiColumnComboBox, this control is not particularly designed to handle this case. Each time a row is selected in the gridview the value of the current display member is considered and displayed in the text box part of the control. Currently, we do not recommend inserting multiple filter expressions in the grid view of the RadMultiColumnComboBox since undesired behavior will occur.

I would also like to inform you that we have plans to rewrite this control and extend its functionality (also addressing the limitations of the filtering functionality), but I cannot give you an exact estimation when this will happen.

Thanks for the understanding and do not hesitate to write back in case you have further questions.

Kind regards,
Deyan
the Telerik team

The FilterExpression method seems to be obsoulted in Q2. Do you have an example code for FilterDescriptor?
Also in the documentation the obsoluted FilterExpression method is described only.

thanks,
Levente

Hi Levente Mihály,

Thanks for contacting us and for your question.

Please take a look at the source code of the RadMultiColumnComboBox example in our Examples Application where you can find sample code demonstrating how to use the FilterDescriptor class to implement AutoFilter in the control:

I hope this helps.

Kind regards,
Deyan
the Telerik team

Thanks!

I am also trying to use multi column filtering.

in my case the code looks like:

public MainForm()
{

RadMultiColumnComboBoxElement

 

multiColumnComboElement = cbSecurity.MultiColumnComboBoxElement;

 

multiColumnComboElement.EditorControl.MasterGridViewTemplate.AutoGenerateColumns =

false;

 

multiColumnComboElement.Columns.Add(

new GridViewTextBoxColumn("SecurityId"));

 

multiColumnComboElement.Columns.Add(

new GridViewTextBoxColumn("Symbol"));

 

multiColumnComboElement.Columns.Add(

new GridViewTextBoxColumn("SymbolDescription"));
}

 

protected

 

override void OnLoad(EventArgs e)

 

{

 

base.OnLoad(e);

cbSecurity.AutoFilter =

true;

 

cbSecurity.DataSource = securities;

cbSecurity.DisplayMember =

"Symbol";

 

 

FilterDescriptor symbolDescriptor = new FilterDescriptor("Symbol", FilterOperator.StartsWith, string.Empty);

 

 

FilterDescriptor nameDescriptor = new FilterDescriptor("SymbolDescription", FilterOperator.StartsWith, string.Empty);

 

cbSecurity.EditorControl.FilterDescriptors.Add(symbolDescriptor);

cbSecurity.EditorControl.FilterDescriptors.Add(nameDescriptor);

cbSecurity.DropDownStyle =

RadDropDownStyle.DropDown;
}

The problem is that the filter only seems to work on "Symbol".  I would like to have it filter based on either column.  Is this possible?

 

Hi John Seifert,

Thank you for writing.

RadMultiColumnComboBox does not supports auto-filtering based on more than one field. That is why adding two or more FilterDescriptors does not work as expected. We will consider including this feature in one of the next releases.

Let me know if you have any other questions.

Greetings,
Martin Vasilev
the Telerik team

Dear Telerik-Team,

I am using RadMultiColumnComboBox in combination with an FilterExpression. Now I want to change the the filter for the RadMultiColumnComboBox.


Initially the filter is applier correctly, but when i am using the code shown, the filter is not correctly applied on the content.

Could you please give me some hints how to fix the problem?

Thx,
Georg

Dear Telerik-Team,

it seems that i had a problem with my code. It work now like a charm. But I've got an other problem. How can I programmatically select an item in the MultiColumnCombo and show the displayMember-Value correct in the MultiColumnCombo (so the value shoud be in the Text member of the Combo element).

Thanks,
Georg

Hello Georg,

Thank you for writing.

I am not sure if I understand correctly your requirement. Do you want to set the selected item? If yes, then you can use one of the RadMultiColumnComboBox's SelectedIndex, SelectedItem or SelectedValue properties.

Let me know if you have any additional questions.

Best wishes,
Martin Vasilev
the Telerik team

Hello...

Please help me. Can't filter by Kode. but filter by nama is work. 

For reference, here is my example again which is now working correctly

Hello Agung,

Thank you for writing.

I managed to use all of your code and build an example project. On my side the data is filtered correctly either by "Kode" or by "Nama".  In your last message you also mention that your example is now working correctly, this is what I also observed on my end.

Just in case I am sending you a sample project as well as a gif file showing the result on my side.

I hope this helps. Should you have further questions please do not hesitate to write back.

Regards,
Hristo Merdjanov
Telerik

Yeah right, fix problem when I do update telerik in 2015 version. Code can't work in 2014 version.

Thx Hristo Merdjanov

Hello Project downalod 

Hello Veton,

Thank you for writing. 

Do you have any question related to this forum thread? I would be glad to help. 

Regards,
Dess
Telerik by Progress