Announcement

**Isomorphic** · 30 Nov 2011, 11:31

Be sure to mention which specific nightly (the string from the Developer Console lower-left-hand corner is the best indicator). Can you show the rest of your DataSource file? It looks like there's some confusion going on regarding the list of output fields.

**azuniga** · 30 Nov 2011, 12:16

Originally posted by Isomorphic

Be sure to mention which specific nightly (the string from the Developer Console lower-left-hand corner is the best indicator). Can you show the rest of your DataSource file? It looks like there's some confusion going on regarding the list of output fields.

SC_SNAPSHOT-2011-08-02/PowerEdition Deployment (built 2011-08-02)

I had to edit the ds.xml file since it is proprietary but here it is

Code:

 <fields>
        <field name="NAME" type="text" length="80">
            <tableName>p_t</tableName>
        </field>            
        <field name="c_type" type="text" length="5">
            <tableName>p_t</tableName>
        </field>
        <field name="b_number" type="integer">
            <tableName>i_b</tableName>
        </field>
        <field name="i_name" type="text" length="10">
            <tableName>i_b</tableName>
        </field>
        <field name="avg_a" type="float" customSQL="true"/>
        <field name="min_a" type="float" customSQL="true"/>
        <field name="max_a" type="float" customSQL="true"/>
    </fields>

<operationBindings>
        <OperationBinding>
        	<operationId>summary</operationId>
            <operationType>fetch</operationType>
            <customFields>avg_a, min_a, max_a"</customFields>
            <selectClause>p_t.NAME, p_t.c_type, 
           		i_b.i_name, i_b.b_number,
				avg(p_a.value) AS avg_a, 
				min(p_a.value) AS min_a, 
				max(p_a.value) AS max_a
            </selectClause>
            <tableClause>p, p_a_t, 
    			p_a, p_t, i_b</tableClause>
            <whereClause><![CDATA[
            	p.p_id = p_a.p_id 
            	AND	p_a.p_a_t_ID = 
    			p_a_t.p_a_t_ID AND
    			p_t.p_t_ID = p.p_t_ID AND
    			p_t.i_b_ID = 
    			i_b.i_b_ID AND
    			(p_a_t.NAME = 'apple' OR 
    			p_a_t.NAME = 'orange') AND
    			p.START_TIMESTAMP between $advancedCriteria.startDateTime AND
    			$advancedCriteria.endDateTime AND
    			$defaultWhereClause]]>
    		</whereClause>
    	<groupClause>
    		p_t.NAME, p_t.c_type, 
    		i_b.i_name, i_b.b_number
    	</groupClause>
    	<groupWhereclause>($defaultWhereClause)</groupWhereclause>
        </OperationBinding>
    </operationBindings>

**azuniga** · 30 Nov 2011, 12:41

I get another error also and I don't know if it can be related but here it is

Code:

20:38:06.989 [ERROR] [myproject] 20:38:06.988:TMR2[E]:WARN:VLayout:page4:members array: [ToolStrip ID:isc_ToolStrip_6],,[TabSet ID:isc_TabSet_5] includes null entry at position 1. Removing
com.smartgwt.client.core.JsObject$SGWT_WARN: 20:38:06.988:TMR2[E]:WARN:VLayout:page4t:members array: [ToolStrip ID:isc_ToolStrip_6],,[TabSet ID:isc_TabSet_5] includes null entry at position 1. Removing
    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)

**Isomorphic** · 30 Nov 2011, 12:43

That doesn't look related - that would result from an addMembers() call in which nulls were passed in an Array.

**Isomorphic** · 1 Dec 2011, 02:51

The server-side NPE is happening because the server is being passed explicit null in field names in the criteria - note the

Code:

fieldName:null,

lines in the criteria reported in the log.

**azuniga** · 1 Dec 2011, 09:05

The error was that I was adding bad criteria to the initial criteria of the listgrid. So I managed to get rid of the error. Now I am still faced with the filtering issue. When I click on the filtereditor filter button, it doesn't display the correct results. It isn't matching anything. When I click my filter button under the dynamic form, then i pass the dynamic form criteria along with the listgrid criteria and it displays the correct results. What could be the problem?

**Isomorphic** · 1 Dec 2011, 14:54

This probably indicates that server-side filtering does not match client-side filtering. For example, you are providing filter criteria for a given DataSource field and via your customized SQL this will return results. However if the same criteria were applied to the records you actually deliver to the client there would be no match.

If it's impossible or just inconvenient to reconcile server and client-side filtering, you can disable client-side filtering for the grid by setting resultSet.useClientFiltering to false using ListGrid.dataProperties.

Announcement

Server returned FAILURE with no error message performing operation 'summary'

Comment

Comment

Comment

Comment

Comment

Comment

Comment