Intersoft Solutions - Community - WebGrid Enterprise - How do I filter values of an Unbound WebCombo in a WebGrid?

Create New

New Discussion
New Question
New Product Feedback

Post Reply

Douglas BadinMember

Posted: May 15, 2013 2:51 PM

Hi,

I replied to a posting that was answered and could not figure out how to un-answer it to make sure Support would look at it so I created this post. Please refer to:

http://www.intersoftpt.com/Community/WebGrid/How-do-I-set-multiple-values-for-an-Unbound-WebCombo-in-a-WebGrid-to-show-up-in-the-DropDown/

How do I filter the List Items in the Unbound WebCombo?

I tried to use the WebCombo Client Side Method SetAdditionalFilters in the WebGrid ClientSideEvent OnEnterEditMode based on a value in the row but on the first time a row

is selected it does not filter and on subsequent rows selected nothing is in the Drop Down List.

I modified the code Hans supplied with:

<ClientSideEvents
	OnEnterEditMode="WebGrid1_OnEnterEditMode"
/>

<script language="javascript" type="text/javascript">

	function WebGrid1_OnEnterEditMode(controlId, TableName, editObject)
	{
		var _WebGrid = ISGetObject(controlId);
		var _WebGridCell = editObject.ToCellObject();
		if (_WebGridCell.Name == "Roles")
		{
			var _WebCombo = editObject.element;
			var FilterValue_String ;
			var EmployeeID_String = _WebGridCell.Row.GetCell("EmployeeID").Value
			if (true)
			{
				switch (EmployeeID_String)
				{
					case "1":
						FilterValue_String = "1";
						break;
					default:
						FilterValue_String = "2";
				} 
				_WebCombo.SetAdditionalFilters("[RoleId] = " + FilterValue_String);
			}
			else
			{
				switch (EmployeeID_String)
				{
					case "1":
						FilterValue_String = "Research Staff";
						break;
					default:
						FilterValue_String = "Research Manager";
				}
				_WebCombo.SetAdditionalFilters("[RoleName] = " + "'" + FilterValue_String + "'");
			}
			_WebCombo.SetText(_WebGridCell.Text, true);
		}
		return true;
	}

</script>

Please see attached screenshots and code.

Thanks,

Doug

3 attachments

UsingWebComboNETwithMultipleSelection.zip

UsingWebComboNETwithMultipleSelection.DropDown.Filter.Row.1.PNG

UsingWebComboNETwithMultipleSelection.DropDown.Filter.Row.2.PNG

Quick Reply

Quote

All Replies

Hans KristianMember

Posted: May 16, 2013 6:02 AM in response to Douglas Badin

Hello,

I am truly sorry for the late response. Currently we had some problems in our server.

Thank you for your information and code.

I will investigate code and I will let you know about the result regarding this problem.

Regards,
Hans.

Quick Reply

Quote

Douglas BadinMember

Posted: May 19, 2013 2:18 PM in response to Hans Kristian

Hello,

Is your server still having problems? (Other people are getting responses.)

Since you already replied about server problems, does that mean I dropped out of your To Do queue?

Have you done any investigation prior to this reply?

Please respond.

Thanks,

Doug

Quick Reply

Quote

Hans KristianMember

Posted: May 20, 2013 6:51 AM in response to Douglas Badin

Hello,

Yes, currently we are still investigating your issue to find the right solution.
I am sorry for the late response.

Regards,
Hans.

Quick Reply

Quote

Hans KristianMember

Posted: May 21, 2013 2:17 AM in response to Hans Kristian

Hello,

I apologize for keep you waiting.

Basically, The SetAdditionalFilters() method can’t be used in Unbound WebCombo indeed. So it will make the issue occurs.

However, I have a workaround that you might try. I modified your validation code in OnEnterEditMode WebGrid’s client side event.
In that event, I try to get all rows in WebCombo result box and then I try to hide the row that doesn’t have the same value with WebCombo value.

Here’s the example snippet validation code:

function WebGrid1_OnEnterEditMode(controlId, TableName, editObject) {    var _WebGrid = ISGetObject(controlId);
    var _WebGridCell = editObject.ToCellObject();
    if (_WebGridCell.Name == "Roles") {
        var _WebCombo = editObject.element;
                
        //So I can get WebCombo rows
        _WebCombo.ShowDropDown(); 
                
        window.setTimeout(function () {
            //To get WebCombo value
            var WebComboValue = _WebCombo.Values[0].Value; 
            //To get WebCombo rows
            var WebComboRows = _WebCombo.GetRows();
            var RowsLength = WebComboRows.length;
                    
            for (i = 0; i < RowsLength; i++) {
                var Row = WebComboRows[i];
                var RowValue = Row.Value;
                        
                if (RowValue != WebComboValue)
                    Row.RowElement.style.display = "none";
            }
            //To hide the dropdown again
            _WebCombo.HideDropDown();
        }, 500);
    }
    return true;
}

I attached the modified sample as well. Hope this helps.
Thank you.

Regards,
Hans.

1 attachment

UsingWebComboNETwithMultipleSelection_Badin.zip

Quick Reply

Quote

Douglas BadinMember

Posted: May 21, 2013 5:33 PM in response to Hans Kristian

Hi Hans,

I will try it and let you know the results.

Thanks,

Doug

Quick Reply

Quote

Douglas BadinMember

Posted: May 23, 2013 2:43 PM in response to Douglas Badin

Hi,

One problem with the code is eventually with different values it displays nothing which can be corrected by setting the values to display with style.display = "inline".

if (RowValue != WebComboValue)
{
	Row.RowElement.style.display = "none";
}
else
{
	Row.RowElement.style.display = "inline";
}

Now the next step is I want to filter based on the [Roles].[DepartmentId] column.

1. It probably needs to be added to the SqlDataSource2 SelectCommand.

<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:SqlSampleConnection %>"
    SelectCommand="SELECT [RoleId], [RoleName], [DepartmentId] FROM [Roles]"></asp:SqlDataSource>

2. I do not want [Roles].[DepartmentId] to be displayed as a column in the DropDown

How do I reference the [Roles].[DepartmentId] Value in the OnEnterEditMode Event so I can Filter by it?

Thanks,

Doug

Quick Reply

Quote

Hans KristianMember

Posted: May 27, 2013 2:58 AM in response to Douglas Badin

Hello,

I made a workaround to get “DepartmentId” value that you might try.
I set the ComboMode to “MultipleColumns” and I add “DepartmentId” column to WebCombo as well.
In OnEnterEditMode client side event, I add a couple line of code the get the “DepartmentId” value.

Please kindly have review on the modified sample to see the result.

Thank you.

Regards,
Hans.

1 attachment

UsingWebComboNETwithMultipleSelection_Badin_2.zip

Quick Reply

Quote

Douglas BadinMember

Posted: May 28, 2013 4:51 PM in response to Hans Kristian

Hi,

That is working for me.

Thanks,

Doug

Quick Reply

Quote