Announcement

**edulid** · 31 Oct 2013, 03:34

I created a testcase which shows the problem. Please take look at it.

TestingModule

Code:

public class TestingModule implements EntryPoint {

	public void onModuleLoad() {

		final ListGrid personListGrid = new ListGrid();
		personListGrid.setWidth(500);
		personListGrid.setDataSource(DataSource.get("personListGrid"));
		personListGrid.setAutoFetchData(false);

		ListGridField personId = new ListGridField("person_id", "ID");
		ListGridField personName = new ListGridField("person_name", "Name");
		ListGridField categoryText = new ListGridField("category_text", "Category text");

		personListGrid.setFields(personId, personName, categoryText);
		personListGrid.setAutoFitData(Autofit.VERTICAL);
		personListGrid.setAutoFitMaxRecords(10);
		
		IButton showAButton = new IButton("Show category A");
		showAButton.setWidth(300);
		showAButton.addClickHandler(new ClickHandler() {
			
			@Override
			public void onClick(ClickEvent event) {
				Criteria c= new Criteria();
				c.addCriteria("categoryText", "A");
				personListGrid.fetchData(c);
			}
		});
		
		IButton showBButton = new IButton("Show category B");
		showBButton.setWidth(300);
		showBButton.addClickHandler(new ClickHandler() {
			
			@Override
			public void onClick(ClickEvent event) {
				Criteria c= new Criteria();
				c.addCriteria("categoryText", "B");
				personListGrid.fetchData(c);
			}
		});
		
		IButton showAllButton = new IButton("Show all categories");
		showAllButton.setWidth(300);
		showAllButton.addClickHandler(new ClickHandler() {
			
			@Override
			public void onClick(ClickEvent event) {
				personListGrid.fetchData();
			}
		});
		
		IButton changeAnnaCategory = new IButton("Change anna category A->B");
		changeAnnaCategory.setWidth(300);
		changeAnnaCategory.addClickHandler(new ClickHandler() {
			
			@Override
			public void onClick(ClickEvent event) {
				/* Change Anna's category from A to B. */
				Record updateRec = new Record();
				updateRec.setAttribute("person_id", 3);
				updateRec.setAttribute("category_id", 2);
				DataSource.get("personForm").updateData(updateRec);
			}
		});
		
		
		VLayout layout = new VLayout(15);
		layout.setHeight(300);
		layout.addMember(showAButton);
		layout.addMember(showBButton);
		layout.addMember(showAllButton);
		layout.addMember(personListGrid);
		layout.addMember(changeAnnaCategory);

		layout.draw();
	}

}

personListGrid

Code:

<DataSource  
        ID="personListGrid"  
        tableName="person"  
        serverType="sql"  
    >  
        <fields>  
            <field name="person_id" type="integer" primaryKey="true" />  
            <field name="person_name" type="text"  />  
            <field name="category_id" type="integer" customSQLExpression="person.category_id" />
            <field name="category_text" type="text" customSQLExpression="categories.category_text" />
        </fields>  
        
        
        <operationBindings>

		<operationBinding operationType="fetch" >
		
			<tableClause>
			person left join categories on categories.category_id = person.category_id
			</tableClause>
			<whereClause>
			
			categories.category_id in
			(select cat.category_id from categories as cat where
			1=1
			
			#if($criteria.categoryText)
			AND cat.category_text=$criteria.categoryText
			#end
			
			)
			
			AND
				 
			($defaultWhereClause)
			
			</whereClause>
		</operationBinding>
		
		<operationBinding operationType="fetch" operationId="fetch_simple" >
			<tableClause>
			person left join categories on categories.category_id = person.category_id
			</tableClause>
			<whereClause>
			 
			($defaultWhereClause)
			
			</whereClause>
		</operationBinding>
		</operationBindings>
          
    </DataSource>

personForm

Code:

<DataSource  
        ID="personForm"  
        tableName="person"  
        serverType="sql"  
    >  
        <fields>  
            <field name="person_id" type="integer" primaryKey="true" />  
            <field name="person_name" type="text"  />  
            <field name="category_id" type="integer" />
        </fields>  
        
        <operationBindings>
        
        	<operationBinding operationType="update">
				<serverObject className="zedes2.server.dmi.TestDMIHandler"
					methodName="doUpdate" />
			</operationBinding>
		
		</operationBindings>
        
    </DataSource>

TestDMIHandler

Code:

public class TestDMIHandler {

	public DSResponse doUpdate(DSRequest dsRequest,
			HttpServletRequest servletRequest) throws Exception {

		DSResponse response = dsRequest.execute();

		Integer personId = (Integer) response.getRecord().get("person_id");
		DSRequest newRequest = new DSRequest("personListGrid",
				DataSource.OP_FETCH);
		newRequest.setOperationId("fetch_simple");

		newRequest.setCriteria("person_id", personId);
		newRequest.setRPCManager(dsRequest.getRPCManager());
		DSResponse fetchResponse = newRequest.execute();
		fetchResponse.setOperationType(DataSource.OP_UPDATE);

		response.addRelatedUpdate(fetchResponse);

		return response;

	}

}

So basically we have two tables:
person and categories. Let them have this content:

person

Code:

person_id, person_name, category_id
1, john, 1
2, marc, 2
3, anna, 1

categories

Code:

category_id, category_text
1, A
2, B

You have 3 Buttons in the form:
"Show category A", "Show category B", "Show category C".

When you click on the respective button, you see the people with this category. In my application I have similar parameters, and depending on the button clicked, parameters are set in a similar way.

So please click on "Show category A". You see people with category A: john and anna. This is correct.

Then I have a button "Change anna category A->B", which changes anna's category from A to B. This is a simulation of my complex form. That is why I use another datasource for this.
When the button is pressed, the change happens correctly, and the DB is updated correctly. The record in the listGrid is also updated: you see the new category from anna.

BUT: this record shouldn't be visible anymore!! Since we pressed the button "Show category A", we should only see the people with category A!. Anna does not have this category any more!

So how to update the grid accordingly?

I hope with this testcase my use case is clearer.

It would be great for the listGrid to reevaluate its current criteria (with a fetch for example) when it gets the result from addRelatedUpdate(), so it shows the received record only when it applies.

As I explained in my first post, the only solution until now is calling listGrid. invalidateCache() to load ALL records again with the current criteria. But this isn't nice and very slow, only for just a small update.

**Isomorphic** · 7 Nov 2013, 09:47

Note for anyone finding this thread: this issue was solved in this thread.

Announcement

My weird requirement

Comment

Comment