Announcement

**Isomorphic** · 30 Jun 2011, 11:27

There's an entire folder of ComboBox samples in the Showcase (what were you doing for three weeks if not looking at these??).

Why are you using filterLocally with more than 7,000 items?

What's the purpose of this code:

Code:

			firstNamesDS.fetchData(criteria, new DSCallback() {
				@Override
				public void execute(DSResponse response, Object rawData,
						DSRequest request) {
					// this works sometimes !!!!!!!!!!!!!!!!!
					firstNameItem.setValue(9114);
				}
			}, dsRequest);

It seems to fetch data and do nothing with it.

**paatal** · 30 Jun 2011, 13:40

thank you very much Isomorphic for your quick reply.
1. why I have this :

Code:

firstNameItem.setFilterLocally(true);

without this attribute :

Code:

firstNameItem.setAddUnknownValues(false);

I had an error :

Code:

01:14:31.718 [ERROR] [callcenter] 01:14:31.708:XRP0:WARN:fetchMissingValues:isc_ComboBoxItem_1:FetchMissingValues - filterLocally is false yet optionDataSource fetch included records that do not match our current data value. Ignoring these values.
com.smartgwt.client.core.JsObject$SGWT_WARN: 01:14:31.708:XRP0:WARN:fetchMissingValues:isc_ComboBoxItem_1:FetchMissingValues - filterLocally is false yet optionDataSource fetch included records that do not match our current data value. Ignoring these values.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.google.gwt.dev.shell.MethodAdaptor.invoke(MethodAdaptor.java:105)
    at com.google.gwt.dev.shell.MethodDispatch.invoke(MethodDispatch.java:71)
    at com.google.gwt.dev.shell.OophmSessionHandler.invoke(OophmSessionHandler.java:167)
    at com.google.gwt.dev.shell.BrowserChannelServer.reactToMessages(BrowserChannelServer.java:281)
    at com.google.gwt.dev.shell.BrowserChannelServer.processConnection(BrowserChannelServer.java:531)
    at com.google.gwt.dev.shell.BrowserChannelServer.run(BrowserChannelServer.java:352)
    at java.lang.Thread.run(Thread.java:662)

but

Code:

firstNameItem.setAddUnknownValues(false);

resolve this problem.

OK. I will remove this :

Code:

firstNameItem.setFilterLocally(true);

2. And what about this code :

Code:

firstNamesDS.fetchData(criteria, new DSCallback() {
				@Override
				public void execute(DSResponse response, Object rawData,
						DSRequest request) {
					// this works sometimes !!!!!!!!!!!!!!!!!
					firstNameItem.setValue(9114);
				}
			}, dsRequest);

I have customer's grid, which has firstname, lastname and other properties, after selecting record I want edit this properties.

how I can set select firstname,lastname and other properites into ComboboxItems ?

also I tried this code instead of above code :

Code:

//this is test example.
firstNameItem.setValue(9114); 

//This is real code snippet from my application.
//firstNameItem.setValue(customersGrid.getSelectedRecord().getAttributeAsInt("firstname_Id"));

Of course I found examples into showcase, but I can't resolve this "setValue" Problem yet.

Regards,
Paata Lominadze.

**Isomorphic** · 30 Jun 2011, 13:44

Both that warning and your general problem have the same cause: your whereClause is hardcoded to ignore any criteria but firstName, whereas fetchMissingValues requests records by primary key. When this fetch arrives, it looks like you send all records back, which is wrong.

**paatal** · 30 Jun 2011, 22:42

ok, I made some changes :
1. DS for dynamic where clause as described here :

http://www.smartclient.com/smartgwt/javadoc/com/smartgwt/client/docs/CustomQuerying.html

Code:

<operationBindings>
		<operationBinding operationId="searchFromDBCustomForCombos" operationType="fetch">
    		<selectClause>   			
    			t.firstname_Id,
    			t.firstname
			</selectClause> 
			<tableClause>firstnames t</tableClause>	
			<whereClause>($defaultWhereClause) AND t.deleted = 0</whereClause>			
    	</operationBinding>

2. Client :

Code:

// comboboxitem
			final ComboBoxItem firstNameItem = new ComboBoxItem();
			// title for this comboboxitem
			firstNameItem.setTitle("Firstname : ");
			firstNameItem.setName("firstname_Id");
			firstNameItem.setWidth(270);
			firstNameItem.setFetchMissingValues(true);
			firstNameItem.setFilterLocally(false);
			firstNameItem.setAddUnknownValues(false);

			// datasource
			DataSource firstNamesDS = DataSource.get("FirstNameDS");

			// fetch name
			firstNameItem.setOptionOperationId("searchFromDBCustomForCombos");
			firstNameItem.setOptionDataSource(firstNamesDS);
			firstNameItem.setValueField("firstname_Id");
			firstNameItem.setDisplayField("firstname");

			Criteria criteria = new Criteria();
			criteria.setAttribute("deleted", 0);

			firstNameItem.setOptionCriteria(criteria);
			firstNameItem.setAutoFetchData(true);
			
			// FOR TESTING !!!!!!!!!!!!!!!!!!!
			firstNameItem.setValue(9114);

Now problem is that SQL generated by the datasource returns only one item(fetchMissingValues requests records by primary key), And when typing symbols nothing happened (request is not generated), I have only 1 item to select.

Miss I some parameters to set for datasource or comboboxitem ?

Thank you very much again in advance.

__________________
Regards,
Paata Lominadze

**Isomorphic** · 1 Jul 2011, 07:22

fetchMissingValues should fetch exactly one item, that's it purpose. Separately, the ComboBoxItem will issue fetches that do not contain a primary key as you type. But since you've called setValue(), this obviously only happens once the user deletes the value in the field, otherwise, there's at most one match.

**paatal** · 1 Jul 2011, 09:53

Hi again.

Sorry for disturbing. Can you hint any workaround for this case ?

What is my task :
I have customers Grid. Customer has firstname and lastname properties, both attributes are another datasources and must be selectable not enterable.

Aso I have 2 buttons on top of grid : "New Customer" And "Edit Customer" (When selected customer into grid).
After click this buttons Pop-up dialog is shown and I want to add or edit customers firstname and lastname.

Any hint will be appreciated,

Thank's In Advance.

_____________________
Regards,
Paata Lominadze

Announcement

Combobox and OptionDataSource (How to make it work ?)

Comment

Comment

Comment

Comment

Comment

Comment