Intersoft Community - WebCombo - Webcombo 2 client side filtering

Webcombo 2 client side filtering

aloisius — Thu, 22 Oct 2009 07:03:27 GMT

hi yudi

i will modify webschedule event editing form (EditingForm.aspx - intersoft default form). i need modify wcResources, adding filter to this combo box in client side. but if runs the filter always get clear combobox.

it my script :

function filterLocation()
{
var wcResources = ISGetObject("wcResources");
wcResources.SetAdditionalFilters("[ResourceDescription]='loc1'" );
}

regards

aloisius

Webcombo 2 client side filtering

grhind@coyotecorp.com — Fri, 11 Sep 2009 09:15:14 GMT

Thank you very much

Webcombo 2 client side filtering

yudi@intersoftpt.com — Thu, 10 Sep 2009 23:13:39 GMT

I checked the attached sample in your first post and I suspect that the SetAdditionalFilter fails because you are using unbound WebCombo.

The cboResource is unbound WebCombo (I conclude this from PopulateUnboundData method that is used in LoadUnboundWebCombo_v2 server side event). I suggest you to use bound WebCombo.

Hope this helps.

Webcombo 2 client side filtering

grhind@coyotecorp.com — Thu, 10 Sep 2009 08:31:11 GMT

Thanks Yudi... I don't have the Northwind database installed so i can't test your sample... would you be able to take a look at the sample i attached in my first post? As you can see i've attempted to use many attempts at the right syntax and nothing seems to work.

Webcombo 2 client side filtering

yudi@intersoftpt.com — Thu, 10 Sep 2009 06:05:43 GMT

Thank you for submitting your issue in our community forum. However, WebCombo 2.0 was discontinued for quite sometime. I’d recommend you to upgrade to WebCombo 4 as it includes many new features and fixes over the previous version. You might want to evaluate the 30-day trial of WebCombo 4 from the following link, http://www.intersoftpt.com/RequestTrial.aspx.

I will try to do my best to assist you to solve the issue.

Please try to set the additional filter of WebCombo 2.0 by using following syntax.
Wc_setAdditionalFilters(‘WebCombo instance ID’, “[Column name] = “ + the additional filter value);

For example, if there are two WebCombo, product WebCombo and category WebCombo. Product WebCombo is a WebCombo that shows list of products from Product table of Northwind database. And Category WebCombo is a WebCombo that shows list of categories from Categories table of Northwind database. The product WebCombo is filtered based on certain category selected in the category WebCombo. Please try to use following code.

wc_setAdditionalFilters( 'wcbProducts', "[CategoryID] = " + wc_States['wcbCategories'].Value );

For more detail, please download the sample from here.

Webcombo 2 client side filtering

grhind@coyotecorp.com — Wed, 09 Sep 2009 09:25:35 GMT

I'm using version 2.0 of the Webcombo so hopefully i'm not to far out of date

I'm trying to get client side filtering to work... i've supplied a sample project with just one combo and one button...

the combo is loaded with 2 columns and 6 rows of data

the button calls a javascript function called UpdateFilter which in turn calls wc_setAdditionalFilters

I've used the following commands and everytime it runs it just clears out the whole combo... what am i doing wrong?

None of these commands seem to work

wc_setAdditionalFilters('cboResource' , 'ID="6"');

wc_setAdditionalFilters('cboResource' , '[ID]="6"');

wc_setAdditionalFilters('cboResource' , '[ID]=6');

wc_setAdditionalFilters('cboResource' , 'ID=6');

wc_setAdditionalFilters('cboResource' , '[Name]="name6"');

wc_setAdditionalFilters('cboResource' , 'Name="name6"');

Anyone have any ideas?