Announcement

**Isomorphic** · 22 Aug 2011, 09:22

For any JavaScript error, please capture a stack trace from the SmartGWT Developer Console in compiled mode (see FAQ).

**davidk** · 23 Aug 2011, 00:35

It appears no stack trace is logged in the SmartGWT Developer Console; its only logged in the Eclipse Console. I've tried putting console logging in to DEBUG level but it didnt seem to produce anything related to the error. I'm not sure if i'm missing something.

Would this be a standard feature after we purchased the SmartGWT Power version? (The ability to get calculated formula builder record values by code).

Thanks!

**Isomorphic** · 23 Aug 2011, 09:39

No, it does not require Power.

You should look for the stack trace *in compiled mode*.

**davidk** · 23 Aug 2011, 20:11

Sorry I wasnt aware compiled mode would behave differently to hosted mode.

when ran in compiled mode, i'm actually not getting an exception, however the method "getFormulaFieldValue()" seem to always return a "." character when I try to convert the integer result to String (by adding it to empty string).

In addition, I also see a WARN logged when getFormulaFieldValue() is invoked:

Code:

12:05:19.903:MUP5:WARN:Log:findByKeys: passed record does not have a value for key field 'id'

I am also puzzled to why getFormulaFieldValue() and getSummaryFieldValue() both return integers. I'd expect the former to return a float or double and the latter to return a String. Am I misunderstanding something?

Thanks!

**Isomorphic** · 24 Aug 2011, 11:14

Can you put together a minimal runnable test case where we can see this value being returned?

**davidk** · 24 Aug 2011, 20:20

Here's the test code, i've pre-entered a formula that does not product the expected results. simply click the "Get formula values as CSV" and the a pop up appears with only periods and commas (eg: ".,.,.,.,.,.,.,.,")

when i changed the formula for column 1 to "random()*100" then click the button, I get an expected list of comma-separated values.

I'm using :
GWT v2.2.0
SmartGWT 2.5.0 (SC_SNAPSHOT-2011-08-08/EVAL Deployment)
JDK 1.6.0_25
Windows 7 - 64 bit

browsers tested:
IE9, Chrome v15, Firefox 5

Code:

package com.intelights.rtimms.client.ui.widgets.smartgwt;

import com.google.gwt.core.client.EntryPoint;
import com.smartgwt.client.data.DataSource;
import com.smartgwt.client.data.Record;
import com.smartgwt.client.data.RecordList;
import com.smartgwt.client.data.fields.DataSourceFloatField;
import com.smartgwt.client.data.fields.DataSourceIntegerField;
import com.smartgwt.client.util.SC;
import com.smartgwt.client.widgets.IButton;
import com.smartgwt.client.widgets.events.ClickEvent;
import com.smartgwt.client.widgets.events.ClickHandler;
import com.smartgwt.client.widgets.grid.ListGrid;
import com.smartgwt.client.widgets.grid.ListGridField;
import com.smartgwt.client.widgets.grid.ListGridRecord;
import com.smartgwt.client.widgets.layout.HLayout;
import com.smartgwt.client.widgets.layout.VLayout;

public class ListGridFormulaTest2 implements EntryPoint {

	@Override
	public void onModuleLoad() {
		VLayout layout = new VLayout(15);
		final ListGrid grid = new ListGrid();
		grid.setLeaveScrollbarGap(true);
		grid.setWidth(750);
		grid.setHeight(224);

		// set up test data
		ListGridRecord[] data = new ListGridRecord[10];
		for (int i = 0; i < data.length; i++) {
			ListGridRecord rec = new ListGridRecord();
			data[i] = rec;

			rec.setAttribute("id", i);
			rec.setAttribute("value", Math.random());
		}

		DataSourceIntegerField f1 = new DataSourceIntegerField("id");
		f1.setPrimaryKey(true);
		DataSourceFloatField f2 = new DataSourceFloatField("value");
		DataSource ds = new DataSource();
		ds.setFields(f1, f2);
		ds.setTestData(data);
		ds.setClientOnly(true);

		// set up listgrid
		grid.setDataSource(ds);
		grid.setAutoFetchData(true);
		grid.setCanReorderFields(false);
		grid.setFieldState("[{name:\"formulaField1\",userFormula:{text:\"B*100\",formulaVars:{B:\"value\"}},title:\"Formula 1\",width:null},{name:\"id\",width:null},{name:\"value\",width:null}]");
		grid.setCanAddFormulaFields(true);
		grid.setCanAddSummaryFields(true);
		layout.addMember(grid);

		HLayout buttonLayout = new HLayout(15);

		// button to get formula values
		IButton getValsBtn = new IButton("Get formula values as CSV");
		getValsBtn.setAutoFit(true);
		getValsBtn.addClickHandler(new ClickHandler() {
			public void onClick(ClickEvent event) {
				SC.warn(grid.getFieldState());
				ListGridField f = grid.getField(0);
				RecordList recList = grid.getDataAsRecordList();
				String vals = "";
				for (int i = 0; i < recList.getLength(); i++) {
					Record rec = recList.get(i);
					vals += grid.getFormulaFieldValue(f, rec) + ", ";
				}
				SC.say(vals);
				SC.warn(vals);
			}
		});

		buttonLayout.addMember(getValsBtn);

		layout.addMember(buttonLayout);

		layout.draw();
	}
}

**davidk** · 29 Aug 2011, 17:39

hi, did you get a chance to confirm if this is a bug? if it is, i dont expect a fix immediately as i'm sure you have higher priorities. As this is a critical feature in our system, I'd like to confirm if this feature will satisfy our requirements. Also I'd like to know how soon can this be fixed when we purchased the SmartGWT Power edition?

We already submitted a P.O. internally for approval to purchase the SmartGWT Power edition; its lumped with a bunch of other equipment P.O. so it may take up to a month before approval.

thanks!

David.

**Isomorphic** · 29 Aug 2011, 17:48

From code inspection your test case looks OK, it's queued to have someone take a look at the cause, but it's behind other reports because you don't have support - getting support is the right way to get it looked at quickly (see the available plans).

Sounds like you have a long procurement process - if it's not already on there, you should probably see about getting support plans as part of the purchase, so that we'll be able to jump on any bug reports right away.

**shift** · 22 Oct 2011, 03:07

Originally posted by Isomorphic

From code inspection your test case looks OK, it's queued to have someone take a look at the cause, but it's behind other reports because you don't have support - getting support is the right way to get it looked at quickly (see the available plans).

Sounds like you have a long procurement process - if it's not already on there, you should probably see about getting support plans as part of the purchase, so that we'll be able to jump on any bug reports right away.

Hey Isomorphic,

any update on the the status of the problem ? I'm currently having the same problem when calling getFormulaFieldValue.

+

The width (or autoWidth:true) of the FormulaField seems to be missing when the field gets added to the grid:

http://www.smartclient.com/smartgwt/...umamry_builder

Add a simple formula field like A+10 and keep the title and look at the width of the field.

Fieldstate of my formula field:

{name:"formulaField1",
userFormula:{text:"A+2",
formulaVars:{A:"age"}},
title:"New Field",
width:null},

Fieldstate example of my other (=regular) fields:

{name:"ecelectricity",
width:120,
autoFitWidth:true},

Can I specify the width (minWidth or autoFitWidth) behavior on a formulaField before it gets added ?

Thanks & Best regards,

shift

**shift** · 14 Nov 2011, 22:40

Hi there,

any fixes landed in 2.5 yet ? This is obviously a BUG in 2.5 ?!

Cheers,

shift

Announcement

Getting computed value of ListGrid formula builder

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment