SmartClient Forums

related updates between data sources related by inheritance

JonFields — Sat, 18 May 2013 14:52:31 GMT

Hi,

I am developing a custom data source that extends BasicDataSource, and supports several data sources that are related by inheritance. For purposes of this discussion, assume that I have two data sources: Base and Derived, where Derived inherits from Base. In my application I have several data bound components displayed at one time, for example a TreeGrid displaying Base records, and a ListGrid displaying Derived records.

If I add/update/remove a Base record from the TreeGrid, what I would like is that the corresponding Derived record in the ListGrid is also added/updated/removed, and vice-versa. This happens automatically if the components are bound to the same data source, but does not seem to happen if they are different data sources related by inheritsFrom. I am able to accomplish this manually, either by using DSResponse.addRelatedUpdate() on the server (or DataSource.updateCaches()).

My question is: should this happen automatically? If so, then I am doing something wrong and will need to try to determine why it is not working for me. If not, then is my manual approach described above the best way to accomplish the desired result?

Thanks!

====
Version: v8.3p_2012-12-31/Pro Deployment (built 2012-12-31)
Browser: Firefox 17.0.5

issue with smartgwt tabs in IE 9 onwards

vnathank — Sat, 18 May 2013 07:24:23 GMT

Hi,
Iam using smartgwt pro 3.1
IE version 9.

I have the problem like when i had the more tabs end of the tabset we will display moveForward and moveBackward and moveDown buttons.
If i reduce the browser size and click on the moveDown button i will get the some alignment problems in my application. To avoid that issues i want to display all opened tabs in left view like "required_Tab.JPG"

please find the attachements.

below is my code.

VLayout tabLayout = new VLayout();
tabLayout.setHeight("100%");
tabLayout.setWidth100();
tabLayout.setOverflow(Overflow.AUTO);

TabSet testTabSet = new TabSet();
testTabSet.setTabBarPosition(Side.TOP);
testTabSet.setTabBarAlign(Side.LEFT);
testTabSet.setWidth100();
testTabSet.setHeight100();
testTabSet.setOverflow(Overflow.VISIBLE); testTabSet.setPaneContainerOverflow(Overflow.VISIB LE);

//Here i add the tabs

Its working perfectly in IE8,chrome and firefox.
Problem with Ie9 onwards.

Please help me to acieve this.
Thanks in Advance.

Attached Images

	required_Tab.JPG (12.8 KB)
	toAvoid_Tab.JPG (12.3 KB)

Menu items from selected datasource records

SaurabhChouhan — Fri, 17 May 2013 20:20:17 GMT

With SmartClient_v82p_2012-06-27 + Google Chrome + Firefox 3.5

I have a menu with a data source. Same data source is associated with a TreeGrid component which is responsible for adding data into this DataSource. There are few items that I want to show on Tree Grid but don't want to have them as an item in Menu. In other words I only want selected record from data source to be displayed as menu item. How should I do this? Please help. Thanks.

SelectItem event

bc — Fri, 17 May 2013 19:43:38 GMT

Hi,
Can someone tell me what event is fired when the picklist associated with a SelectItem contracts. When I click on another element when the picklist is expanded it seems like that click event is "absorbed" by the picklist which then contracts and I need to click a second time on the other element.
Thanks.

Validation with ListGridEditorCustomizer

nachopo81 — Fri, 17 May 2013 17:54:00 GMT

Hi,

I use SmartGWT and I'm working with grids

Is it possible to do validation in a cell when using ListGridEditorCustomizer in a listgrid?

I am working with the following code but does not appear in the cell validation icon.

countryGrid.setEditorCustomizer(new ListGridEditorCustomizer() {
public FormItem getEditor(ListGridEditorContext context) {
ListGridField field = context.getEditField();
if (field.getName().equals("l1")) {
NameValueRecord record = (NameValueRecord) context.getEditedRecord();
int id = record.getID();
switch (id) {
case 1:
IntegerItem metaAhorro = new IntegerItem();
metaAhorro.setCanEdit(true);
IntegerRangeValidator integerRangeValidator = new IntegerRangeValidator();
integerRangeValidator.setClientOnly(Boolean.TRUE);
integerRangeValidator.setMin(1);
metaAhorro.setValidators(integerRangeValidator);
metaAhorro.setValidateOnExit(Boolean.TRUE);
return metaAhorro;
default:
return context.getDefaultProperties();
}
}
}
});

Best regards

BatchUploader unsuccessful uploading 4000 records

valerien — Fri, 17 May 2013 16:50:16 GMT

I'm trying to use BatchUploader to accept a CSV file and upload that data into a PostgreSQL 9.2.2 database.

I started with the Power 2013-03-06 nightly build and the moved to v8.3p_2013-05-12/PowerEdition Deployment (built 2013-05-12). I didn't get it to work with either build.

I'm testing with Firefox 20.0.1 talking to Tomcat 7.0.33.

If I upload a csv file with around 1000 records/rows. Everything seems to work fine. When I upload a csv file with around 4000 records/rows, the 'Upload' batchUploader function will read the file and propulate the listGrid. The 'Commit' function will take a while, will give me several 'script not responsive' prompts, and eventually come back with the 'Records added' popup, but the records were never added.

When it is unsuccessful I see these messages on the Developer Console after pressing the 'Commit' button:

Code:

11:19:49.048:INFO:RPCManager:rpcResponse(upload)[update]: result: object[status=0]

11:28:28.910:MUP4:INFO:RPCManager:sendQueue[14]: 4063 RPCRequest(s); transport: xmlHttpRequest; target: http://172.30.1.158:8080/krv/streetsmart1/sc/IDACall?isc_rpc=1&isc_v=v8.3p_2013-05-12&isc_xhr=1

11:30:39.907:MOU7:DEBUG:RPCManager:XMLHttpRequest POST to http://172.30.1.158:8080/krv/streetsmart1/sc/IDACall?isc_rpc=1&isc_v=v8.3p_2013-05-12&isc_xhr=1 contentType: application/x-www-form-urlencoded; charset=UTF-8 with body -->isc_tnum=14&_transaction=140120**********000001******************************0000200-**.*********.**************amrSiteUploadaddbuiltinApplicationamrSiteUpload_add0120**********000001******************************0000200-**.*********.**************...

...(3535729 bytes truncated).  Enable RPCManagerResponse log at same threshold to see full message.

11:30:40.847:XRP0:INFO:RPCManager:transaction 14 arrived after 131936ms

11:30:40.850:XRP0:DEBUG:RPCManager:Result string for transaction 14: ""

11:30:41.094:XRP0:INFO:RPCManager:rpcResponse(unstructured) results -->""<--

11:30:41.095:XRP0:INFO:RPCManager:rpcResponse(unstructured) results -->""<--

...

11:30:41.777:XRP0:INFO:RPCManager:rpcResponse(unstructured) results -->""<--

11:30:41.778:XRP0:INFO:RPCManager:rpcResponse(unstructured) results -->""<--

Note that I replaced personal information in the output with '*'. I also truncated the repetative parts of the output.

The data source is fairly simple. It included fields from two different postgreSQL tables. A Server side method performs the insert into each table and if the entry already exists, it updates the data instead. There are log messages at the begining for the methods. When doing 1000 entries I see the log messages in the log. With 4000 entries, I don't see the log messages in the log. I don't believe my server side methods are being called.

The RPC log shows the DSRequests and has them marked as successful.

Note that when the upload is unsuccessful, I don't see any exceptions or error messages.

Thanks,
Kevin

Attached Images

BatchUploaderRPC.jpg (94.7 KB)

Issue with "emptyCellValue" showing in group and grid summary lines

vagkavan — Fri, 17 May 2013 16:38:40 GMT

Hello,

I noticed that if I set a value to a ListGrid to be displayed in cells whose values are null, using setEmptyCellValue method, this value will be displayed also in both group and listGrid summary lines of fields that are not set to show values in summary lines.

You can reproduce the problem in the following showcase example:
http://www.smartclient.com/smartgwt/...grid_summaries
by addind the following line of code:

Code:

listGrid.setEmptyCellValue("-");

If you compile this example using smartclient 2.5p LGPL 2013-05-02 [v8.1p_2013-05-02/LGPL Development Only (built 2013-05-02)], you will see that the empty cell value is be displayed in group summary line [attached file gridSummary_8.1p.jpg].
If you compile it with 3.1p LGPL 2013-05-02 [v8.3p_2013-05-02/LGPL Development Only (built 2013-05-02)] it will be shown in both group and grid summary lines [attached file gridSummary_8.3p.jpg].
E.g. although "quantityField" listGridField has showGroupSummary and showGridSummary set to false, empty cell value is shown in summary lines.

A temporary workaround would be to set emptyCellValue directly to each ListGridField instead of setting it to ListGrid.

I have tested it with the following GWT, SmartGWT and browser versions on Windows 7 and Ubuntu 12.10:

GWT 2.5.0.
SmartClient Version: 2.5p LGPL 2013-05-02 [v8.1p_2013-05-02/LGPL Development Only (built 2013-05-02)] and
3.1p LGPL 2013-05-02 [v8.3p_2013-05-02/LGPL Development Only (built 2013-05-02)].
Firefox 21.0, Chrome 23.0.1271.95, Internet Explorer 9.0.8112.16421.

Thanks

Attached Images

	gridSummary_8.3p.jpg (74.7 KB)
	gridSummary_8.1p.jpg (40.6 KB)

getBackgroundColor () after setBackgroundColor (null) does not work

shortpasta — Fri, 17 May 2013 15:30:53 GMT

Using:
GWT 2.5.0
SmartGWT 3.1p-2012-11-23
SmartClient Version: v8.3p_2012-11-23/LGPL Development Only (built 2012-11-23)
FF 19, IE 9, Chrome 26

Problem:
Call layout.setBackgroundColor ("red"); // turns background color to red as expected
Call layout.getBackgroundColor (); // returns "red" as expected

Call layout.setBackgroundColor (null); // turns background color to white as expected
Call layout.getBackgroundColor (); // returns "red", but should return null

In this sample, click Red then click Null, and I see:

Code:

00:02:24.207 [INFO] setBackgroundColor (). color: red, layoutBackgroundColorBefore: null, layoutBackgroundColorAfter: red

00:02:27.072 [INFO] setBackgroundColor (). color: null, layoutBackgroundColorBefore: red, 

layoutBackgroundColorAfter: red

Sample code:

Code:

public class SetBackgroundColor implements EntryPoint {



  // my attributes

  private final VLayout layout = new VLayout ();



  /**

   * The EntryPoint interface

   * http://forums.smartclient.com/showthread.php?p=94385

   */

  public void onModuleLoad() {



    // add a button that makes the background red

    final IButton buttonRed = new IButton ();

    buttonRed.setTitle ("Red");

    buttonRed.addClickHandler (new ClickHandler () {

      public void onClick (final ClickEvent clickEvent) {

        setBackgroundColor ("red");

      }

    });



    // add a button that shows a dialog with a canvas with no opaticy set

    final IButton buttonNull = new IButton ();

    buttonNull.setTitle ("Null");

    buttonNull.addClickHandler (new ClickHandler () {

      public void onClick (final ClickEvent clickEvent) {

        setBackgroundColor (null);

      }

    });



    // add

    layout.addMember (buttonRed);

    layout.addMember (buttonNull);

    layout.draw ();

  }



  /**

   * Uniformly sets the background color and logs debug data

   * @param color

   */

  private void setBackgroundColor (final String color) {



    final String layoutBackgroundColorBefore = layout.getBackgroundColor ();

    layout.setBackgroundColor (color);

    final String layoutBackgroundColorAfter = layout.getBackgroundColor ();

    GWT.log (

      "setBackgroundColor (). color: " + color + ", " +

      "layoutBackgroundColorBefore: " + layoutBackgroundColorBefore + ", " +

      "layoutBackgroundColorAfter: " + layoutBackgroundColorAfter);

  }

}

IntegerRangeValidator - ErrorMessage - Question

ex70375 — Fri, 17 May 2013 14:28:42 GMT

hi,

how can I set the MIN and MAX error message in IntegerRangeValidator. I only found integerRangeValidator.setErrorMessage(""), but I need different messages with MIN or MAX.

best regards,
mirko

SelectItem Empty Value and Picklist Grouping

bda@n-side.com — Fri, 17 May 2013 13:34:23 GMT

Hi,

I have a SelectItem that accepts empty value. Hence setAllowEmptyValue is set to true. The SelectItem uses a custom picklist to show values using grouping. Obviously the empty value added by SGWT to the list of values does not have any value for the grouped field which results in this empty value to be displayed within a group named "- none -". Is is possible to have this empty value showed without a group (keeping the other values grouped) or at least to alter the empty-group name to an empty String ?

Some fields of the empty value received a non empty-value (see Name field in the figure that has the value "0_0" ?).

Thanks, Ben

Issue with multiple summary functions

vagkavan — Fri, 17 May 2013 12:41:27 GMT

Hello,

I noticed that there is a problem if both setSummaryFunction and addSummaryFunction methods are called to set multiple summary functions in GridSummary for a ListGridField.

You can see the problem in the following showcase example:
http://www.smartclient.com/smartgwt/...d_ml_summaries
In GridMultiLineSummariesSample.Java you have set a "First Order" SummaryFunction for the "shipDateField" using setSummaryFunction method and a "Last Order" SummaryFunction using addSummaryFunction, but as you can see only "Last Order" SummaryFunction is included in grid summary of your example.

A workaround until you fix it would be to set both summary functions using the addSummaryFunction method.

I have tested it with the following GWT, SmartGWT and browser versions on Windows 7 and Ubuntu 12.10:

GWT 2.5.0.
SmartClient Version: 3.1p LGPL 2013-05-02 [v8.3p_2013-05-02/LGPL Development Only (built 2013-05-02)].
Firefox 21.0, Chrome 23.0.1271.95, Internet Explorer 9.0.8112.16421.

Thanks

SC9 and Selenium Web Driver

acarur01 — Fri, 17 May 2013 12:30:18 GMT

Some colleagues found an odd behaviour with webdriver where the findElements method is unable to locate the warning message dialog button. It normally has the locator �scLocator=//Dialog[ID=\"isc_globalWarn\"]/okButton/�

When we use the findElement() method however, it locates it just fine - is this intended behaviour?

PickTreeItem does not show its PickerIcon when set as Listgrid.FilterEditorType

michalg — Fri, 17 May 2013 11:41:12 GMT

1. SmartClient Version: v8.3p_2013-05-17/LGPL Development Only (built 2013-05-17)

2. Firefox 3.6.17

3.

4.

5.

6. sample code:

Code:

package pl.com.tech4.client;



import com.google.gwt.core.client.EntryPoint;

import com.google.gwt.user.client.DOM;

import com.smartgwt.client.data.DataSource;

import com.smartgwt.client.data.DataSourceField;

import com.smartgwt.client.util.SC;

import com.smartgwt.client.widgets.form.DynamicForm;

import com.smartgwt.client.widgets.form.fields.PickTreeItem;

import com.smartgwt.client.widgets.form.fields.PickerIcon;

import com.smartgwt.client.widgets.form.fields.events.FormItemClickHandler;

import com.smartgwt.client.widgets.form.fields.events.FormItemIconClickEvent;

import com.smartgwt.client.widgets.grid.ListGrid;

import com.smartgwt.client.widgets.grid.ListGridField;

import com.smartgwt.client.widgets.layout.VLayout;



public class MainEntryPoint implements EntryPoint {

   

    public void onModuleLoad() {



        DOM.getElementById("loadingPicture").removeFromParent();

        layout();

        SC.showConsole();

    }

   

    private void layout() {



        DataSource ds = new DataSource();

        DataSourceField fieldId = new DataSourceField();

        fieldId.setName("id");

        fieldId.setPrimaryKey(true);

        DataSourceField fieldParentId = new DataSourceField();

        fieldParentId.setName("parentId");

        fieldParentId.setForeignKey("id");

        ds.setFields(fieldId, fieldParentId);

       

        PickTreeItem parentIdItem = new PickTreeItem("parentId");

        PickerIcon clearPickerIcon = new PickerIcon(PickerIcon.CLEAR);

        clearPickerIcon.addFormItemClickHandler(new FormItemClickHandler() {



            public void onFormItemClick(FormItemIconClickEvent event) {

                event.getItem().clearValue();

            }

        });

        parentIdItem.setIcons(clearPickerIcon);

        parentIdItem.setEmptyDisplayValue("A bug?");

       

        ListGrid lg = new ListGrid();

        lg.setShowFilterEditor(true);

        lg.setWidth(200);

        ListGridField lgf = new ListGridField("parentId");

        lgf.setFilterEditorType(parentIdItem);

        lg.setFields(lgf);

       

        lg.setDataSource(ds);

       

        DynamicForm df = new DynamicForm();

        df.setFields(parentIdItem);

        df.setDataSource(ds);

       

        VLayout layout = new VLayout();

        layout.addMember(lg);

        layout.addMember(df);



        layout.draw();

    }

   

}

clearPickerIcon is shown, when this PickTreeItem is a part of DynamicForm (although some horizontal alignment problems can be seen).
The same PickTreeItem shows no picker when drawn as a Listgrid filter editor.
Please see the screen shoot attached.
MichalG

Attached Images

pickTree.png (6.2 KB)

how to set initialData on treeGrid

esmith — Fri, 17 May 2013 11:13:11 GMT

Hello,

Using
** Smart GWT Forum
I am using the following
SmartClient Version: v8.3p_2013-04-19/PowerEdition Deployment (built 2013-04-19)

GWT 2.5.1

I have read the documentation and am starting a new thread with the specific related to TreeGrid.

I see that the initial data takes an array of TreeNodes. I would like to get the data from mysql. I tried using a ResultSet, but it did not seem to get all the data (by design per documentation of Result Set). What is the correct way to get all the data on a request? So I can set the initial data in my tree grid?

Evan

Multiple DataSources don't lead to correct updateURLs ?

bug — Fri, 17 May 2013 10:03:40 GMT

Hello,

I've built a listGrid, on which I have added a tabbedSet with dynamicForms, listgrids etc.
All of these sub"Forms" are created and loaded via a DataSource each.

The problem is, I updated from GWT 2.5.0 to GWT 2.5.1 and to SmartGWT 4.0 and since then, when I try to download the modified values to the server, via an updateURL, I encounter a totally weird behavior:

only one DataSource is updated each time, while in SaveButton/ onClick event I include code for both forms. i.e.

Code:

passwdForm.setSaveOperationType(DSOperationType.UPDATE);

                                                passwdForm.saveData();

                                                

                                                userDetailsForm.setSaveOperationType(DSOperationType.UPDATE);

                                                userDetailsForm.saveData();

Also, each DataSource has its own definitions for OperationBindings for FETCH and UPDATE, with the appropriate fetchURLs & updateURLs.

After several efforts, I managed to get it working, and it seemed it had stuck somehow, but since I stopped / started server and deployed source code, the problem appeared again: Only one DataSource Update is executed.

Has anybody come across such a behavior?