Intersoft Community - WebScheduler - WebCombo filter on client

WebCombo filter on client

Hans — Thu, 10 Oct 2013 23:24:13 GMT

Hello,

I glad to hear that you have resolved your filtering scenario.

For the “first key stoke” issue, since this is a different (new) topic, please kindly create new thread / post regarding the “first key stoke” issue.
Later on, in the new thread, please kindly provide us the simple runnable sample that replicate the issue and the guidance how-to reproduce the issue as well.

Thank you very much for your help.

Regards,
Hans.

WebCombo filter on client

luwen — Thu, 10 Oct 2013 14:56:29 GMT

That works beautifully. Thanks!

I saw an another issue. When you use arrow keys to navigate the grid (with CellClickAction="CellSelect"), if the column is a webcombo or dropdownlist, your first key stoke is ignored. While if the column is a textbox, your first key stoke is NOT ignored. How to make the first key stoke accepted as a "real" user input for webcombo and dropdownlist?

Thanks,

Luwen

WebCombo filter on client

hans@intersoftpt.com — Wed, 09 Oct 2013 22:30:00 GMT

Hello,

Thank you for the reply.

I am sorry; I forgot to mention that you should define your data type of your column.

The error message occurs due to you haven’t define the data type or the filter expression doesn’t match with the column’s data type.

In my sample I have defined the data type:

textColumn.Name = textColumn.ColumnName = "Text";textColumn.DataType = "System.String";

Regards,
Hans.

WebCombo filter on client

luwen — Wed, 09 Oct 2013 11:18:16 GMT

Thank you Hans for your quick response.

I got error message "Invalid filter expressions." when used your code. I tried both "like" and "contains", same message.

My WebCombo version is 6.0.7200.

Regards,

Luwen

WebCombo filter on client

hans@intersoftpt.com — Wed, 09 Oct 2013 05:56:51 GMT

Hello,

Thank you for the question regarding WebCombo.

I use WebCombo sample, ClientBinding_ClientAPI.aspx, to find a work around that perhaps you could use.
It seems this sample (ClientBinding_ClientAPI.aspx) similar with your current scenario.

In that sample I use OnShowDropDown client side to filter the WebCombo’s result box.
Here’s the example snippet code how I filter the result box:

function wcClient_OnShowDropDown(controlId, left, top, width, height) {    var wcClient = ISGetObject("wcClient");
    var dataView = wcClient.GetView();
    if (dataView == null) {
        alert("Data is not created yet!");
        return;
    }
    else {
        if (wcClient.LastQuery != "") {
            wcClient.HideDropDown();
            dataView.Table.UserDefinedRowFilter = "[Text] like '" + wcClient.LastQuery + "%'";
            //Or you can use "[Text] contains '" + wcClient.LastQuery + "'"
            wcClient.RebindData(null, true);
        }
    }
}

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

Hope this helps. Thank you.

Regards,
Hans.

WebCombo filter on client

luwen — Tue, 08 Oct 2013 18:27:28 GMT

I used a WebCombo inside a grid. Everything works fine except the speed of loading the options in webcombo is slow when user start to type. Here is the code

<ISWebCombo:WebCombo ID="WebCombo1" runat="server" OnInitializeDataSource="WebCombo1_InitializeDataSource UseDefaultStyle="True" Width="350px" > <LayoutSettings EntryMode="AutoComplete"> </LayoutSettings>

</ISWebCombo:WebCombo>

So I changed to use JSON and clientBindering. The problem is that the options in webcombo are not filtered as they are supposed to when user start typing.

This is the format options in WebCombo. They contains two parts: number and description. For example:

1 - U.S. Government Interest Reported as Nonqualified Dividends

2 - U.S. Corporate Dividends from Foreign Source

3 - Foreign Dividends

12 - Partnership Income

123 - Exempt Interest Subject to AMT - Territories

What I want is when user types "1", all options starting with "1" are shown,

1 - U.S. Government Interest Reported as Nonqualified Dividends

12 - Partnership Income

123 - Exempt Interest Subject to AMT - Territories

When user types 12, all options starting with "12" are shown

12 - Partnership Income

123 - Exempt Interest Subject to AMT - Territories

124 - xxxx

but now it always shows everything in the order of the list without filtering

1 - U.S. Government Interest Reported as Nonqualified Dividends

2 - U.S. Corporate Dividends from Foreign Source

3 - Foreign Dividends

My question is

1. How to apply filter to the webcombo options in javascript ?

2. If (1) is not applicable, how to speed up the combo options loading?

Here is my code.

<ISWebCombo:WebCombo ID="WebCombo1" runat="server" DataTextField="text" DataValueField="key" BindingOperationMode="ClientBinding" UseDefaultStyle="True" >

<ISWebCombo:WebComboColumn Name="text" BaseFieldName="text" HeaderText="Item Text" Width="350"/>

</Columns>

</ISWebCombo:WebCombo>

function BindWebCombo() { // called when page load

var combo = ISGetObject("WebCombo1");

var webComboTable = new ISDataTable();

var keyColumn = new ISDataColumn(webComboTable);

var textColumn = new ISDataColumn(webComboTable);

webComboTable.Name = webComboTable.TableName = "TaxCodesDesc ";

keyColumn.Name = keyColumn.ColumnName = "key";

textColumn.Name = textColumn.ColumnName = "text";

webComboTable.Columns.Add(keyColumn);

webComboTable.Columns.Add(textColumn);

for (var j = 0; j < retData.TaxCodesDesc.length; j++) {

var dataRow = webComboTable.NewRow();

dataRow.Cells.GetNamedItem("key").Value = retData.TaxCodesDesc[j].key;

dataRow.Cells.GetNamedItem("text").Value = DecodeXmlText(retData.TaxCodesDesc[j].value);

webComboTable.Rows.Add(dataRow);

}

combo.SetDataSource(webComboTable);

combo.DataBind();

combo.Render();

combo.ShowDropDown();

}

</script>

Thanks,

Luwen