ListGrid displaying updated Record.

[Amanda]

I open a listGrid with searchCriteria. now if update a record of same datasource then this record is getting displayed in the listGrid also. As this listGrid is created by passing criteria and this as per the criteria updated record should not be displayed.

But it is displaying ..Here is the log ]


17:58:20.301:XRP3:WARN:Log:findByKeys: passed record does not have a value for key field 'dbid'
17:58:20.321:XRP3:INFO:ResultSet:isc_ResultSet_99 (created by: isc_ListGrid_86):updated row returned by server doesn't match any cached row, adding as new row. Primary key values: {dbid: 35425}, complete row:


If i create a new record of same datasource then this record is not getting displayed in the listGrid which is fine.

18:17:33.327:XRP8:INFO:ResultSet:isc_ResultSet_218 (created by: isc_ListGrid_86):0 of 1 rows match filter criteria
18:17:33.350:XRP8:DEBUG:ResultSet:isc_ResultSet_218 (created by: isc_ListGrid_86):full length set to: 1




I am using RestDatasource and ListGrid is DataBound.

Please provide help in this issue.

[Isomorphic]

How strange, you knew enough to turn on the right log category but trimmed off all the useful information before posting :) Post the complete log.

[Dannylee]

hi.. posting logs on behalf of Amanda

13:51:27.152:MUP9:DEBUG:RPCManager:Grabbed prompt from first request that defined one: Saving form...
13:51:27.154:MUP9:INFO:RPCManager:sendQueue[32]: 1 RPCRequest(s); transport: xmlHttpRequest; target: coreservices/OrganizationService/organizations/2993
13:51:27.156:MUP9:DEBUG:RPCManager:XMLHttpRequest POST to coreservices/OrganizationService/organizations/2993 contentType: application/json with body -->{
"OrganizationDTO":{
"dbid":2993,
"code":"XOXOXOXOXO",
"name":"XOXOXOXOXOg",
"currencyCode":"USD"
}
}<--
13:51:27.169:MUP9:WARN:FormPane:isc_FormPane_648:couldn't find member to remove: [HLayout ID:isc_HLayout_843]
13:51:27.751:XRP4:INFO:RPCManager:transaction 32 arrived after 596ms
13:51:27.755:XRP4:DEBUG:RPCManager:Result string for transaction 32: "{"OrganizationDTO":{"endRow":0,"startRow":0,"status":200,"totalRows":2213,"data":{"dbid":2993,"code":"XOXOXOXOXO","name":"XOXOXOXOXOg","currencyCode":"USD"}}}"
13:51:27.760:XRP4:INFO:RPCManager:rpcResponse(unstructured) results -->"{"OrganizationDTO":{"endRow":0,"startRow":0,"status":200,"totalRows":2213,"data":{"dbid":2993,"code":"XOXOXOXOXO","name":"XOXOXOXOXOg","currencyCode":"USD"}}}"<--
13:51:27.765:XRP4:DEBUG:ResultSet:isc_ResultSet_932 (created by: isc_ListGrid_888):dataSource data changed firing
13:51:27.769:XRP4:INFO:ResultSet:isc_ResultSet_932 (created by: isc_ListGrid_888):updating cache in place after operationType: update, allMatchingRowsCached true
13:51:27.773:XRP4:INFO:ResultSet:isc_ResultSet_932 (created by: isc_ListGrid_888):Updating cache: operationType 'update' submitted by 'isc_DynamicForm_660',1 rows update data:
[
{dbid: 2993,
code: "XOXOXOXOXO",
name: "XOXOXOXOXOg",
currencyCode: "USD"
}
]
13:51:27.778:XRP4:WARN:Log:findByKeys: passed record does not have a value for key field 'dbid'
13:51:27.785:XRP4:INFO:ResultSet:isc_ResultSet_932 (created by: isc_ListGrid_888):updated row returned by server doesn't match any cached row, adding as new row. Primary key values: {dbid: 2993}, complete row: {dbid: 2993,
code: "XOXOXOXOXO",
name: "XOXOXOXOXOg",
currencyCode: "USD"
}
13:51:27.794:XRP4:DEBUG:ResultSet:isc_ResultSet_932 (created by: isc_ListGrid_888):updated cache: 1 row(s) added, 0 row(s) updated, 0 row(s) removed.
13:51:27.803:XRP4:DEBUG:ResultSet:isc_ResultSet_932 (created by: isc_ListGrid_888):full length set to: 1
13:51:27.812:XRP4:DEBUG:ResultSet:isc_ResultSet_933 (created by: isc_ListGrid_612):dataSource data changed firing
13:51:27.822:XRP4:INFO:ResultSet:isc_ResultSet_933 (created by: isc_ListGrid_612):updating cache in place after operationType: update, allMatchingRowsCached true
13:51:27.832:XRP4:INFO:ResultSet:isc_ResultSet_933 (created by: isc_ListGrid_612):Updating cache: operationType 'update' submitted by 'isc_DynamicForm_660',1 rows update data:
[
{dbid: 2993,
code: "XOXOXOXOXO",
name: "XOXOXOXOXOg",
currencyCode: "USD"
}
]
13:51:27.844:XRP4:WARN:Log:findByKeys: passed record does not have a value for key field 'dbid'
13:51:27.858:XRP4:INFO:ResultSet:isc_ResultSet_933 (created by: isc_ListGrid_612):updated row returned by server doesn't match any cached row, adding as new row. Primary key values: {dbid: 2993}, complete row: {dbid: 2993,
code: "XOXOXOXOXO",
name: "XOXOXOXOXOg",
currencyCode: "USD"
}
13:51:27.873:XRP4:DEBUG:ResultSet:isc_ResultSet_933 (created by: isc_ListGrid_612):updated cache: 1 row(s) added, 0 row(s) updated, 0 row(s) removed.
13:51:27.889:XRP4:DEBUG:ResultSet:isc_ResultSet_933 (created by: isc_ListGrid_612):full length set to: 2
13:51:27.957:XRP4[E]:DEBUG:ResultSet:isc_ResultSet_932 (created by: isc_ListGrid_888):getRange(0, 0): returning empty list
13:51:28.256:XRP4[E]:DEBUG:ResultSet:isc_ResultSet_932 (created by: isc_ListGrid_888):getRange(0, 0): returning empty list
13:51:28.412:RDQ7:DEBUG:ResultSet:isc_ResultSet_933 (created by: isc_ListGrid_612):getRange(0, 1) satisfied from cache

[Isomorphic]

Either the record you were updating did not have a value for the primaryKey, or the return record changed the value. This is invalid. If you're changing the primaryKey, do a remove then add.

There are no filter criteria applied to the grid so far as this log shows.

[Dannylee]

Here are full logs once again showing criteria attached to the grid

I have rechecked the response and we are getting primary key and its not getting updated as well.

Thanks,
Danny.

[Isomorphic]

You've got lots of problem to correct that SmartClient is warning you about.

Here's one serious one that is causing this particular problem:

14:01:20.542:TMR7[E]:INFO:ResultSet:isc_ListGrid_708:Creating new isc.ResultSet for operation 'organizationDS_fetch' with filterValues: {
    _constructor:"String", 
    operator:"and", 
    criteria:[
        {
            fieldName:"dbid", 
            operator:"and", 
            value:749
        }, 
        {
            fieldName:"foreignKey", 
            operator:"and", 
            value:"true"
        }, 
        {
            fieldName:"parentRecordName", 
            operator:"and", 
            value:"OrganizationDTO"
        }, 
        {
            fieldName:"subTabTitle", 
            operator:"and", 
            value:"Divisions"
        }
    ]
}

This is a senseless criteria object and SmartClient's client-side filtering won't work with it. It should say _constructor:"AdvancedCriteria", and the "and" operator makes no sense in the objects in the "criteria" array. This means there's no way for SmartClient to know whether a new row should be in the grid or not, so it allows it.

[Dannylee]

Hi,

I know about that issue but I am talking about below listgrid. The other listgrid was just to show the associated form data. We changed the operator to "equals" in that grid too and constructor to AdvancedCriteria but my problem is with below grid.

14:01:12.070:INFO:ResultSet:isc_ListGrid_633:Creating new isc.ResultSet for operation 'organizationDS_fetch' with filterValues: {
_constructor:"AdvancedCriteria",
operator:"and",
criteria:[
{
fieldName:"code",
operator:"equals",
value:"TSO"
}
]
}

[Isomorphic]

Client-side filtering ignores fields that are not declared in the DataSource (see the docs for applyFilter et al). That's most likely the issue.

By the way, if you guys expect further support like this it's time to purchase support.

[Nilre]

Why isn't the price listed on the commercial support page? Don't be shy! :-)

[Isomorphic]

Because you cannot yet purchase it on line. It will be possible to do so soon, as well as purchase support bundled with a license.