Problem with list refresh, anyone experience this?

[Tbrondolo]

I have an ajax callback which updates a sql database record

If the callback is successful I then do the following....


{dialog.object}._listRefreshRecordsByKey('Entered',recid);

The refresh sort of works, instead of the field data I get the field names for the record that was refreshed, I get field data for all the others as they were not refreshed.

If I go from panel 1 to panel 2 and back I then get the data. It's as if it does not complete the rendering and replace the field names with the data.

I have tried adding a refresh commands to redraw the screen but it does not work.

attached is the screen with the error.

Any ideas would be appreciated.

Tom

update_error.png

[Davidk]

Re: Problem with list refresh, anyone experience this?

Tom,

Could you walk through a process for re-creating what you have, or post a test case so that we can re-create what you're getting?

[Tbrondolo]

Re: Problem with list refresh, anyone experience this?

Hi David,

This is a complicated UX so recreating a test set is time consuming and I am also looking at a redesign as a workaround. But functionally, what is happening is there is a list control, the user clicks on the control and navigates to a new panel where they can edit two fields of data for that list item. They click an update button and an AJAX callback to update the mYSql table is made. If the callback is successful a javascript function is called to refresh the list control record with the updated data. I know the callback is working, but when the list refreshes I get field placeholders instead of data. See the image in the first post.

Below is the javascript that is used to refresh the list.

It gets the primary key value and passes it to the list refresh function. I later added the last two lines in an attempt to force a refresh, but I get the same result with or without the last two lines. If I navigate away from the panel and return to the panel I get the data. It's as if it fails to complete the rendering process.

//This will refersh the list after update
function updatesaved() {

{dialog.object}.panelSetActive('PANELCARD_3','true');
var recid = {dialog.Object}.getValue('recid');

{dialog.object}._listRefreshRecordsByKey('Entered',recid);
 

var listObj = {dialog.object}.getControl('Entered');
listObj.refresh();
}

Thanks,
tom

[Davidk]

Re: Problem with list refresh, anyone experience this?

I createe a UX component that contains a List Control. When you click on an Item, a Panel slides into view containing a couple of fields from the List control.

I edit a field and click Submit. My Edit panel slides out of view and my List is visible with the changes.

This component is data bound, uses Action Javascript for filling in the UX controls with data from a table and uses the Server-side event afterDialogValidate.

(The afterDialogValidate also sets e.javascript to set the active panel back to my List Panel. Edit: This isn't required... afterDialogValidate has an option to take care of this.)

Do you have to do your own Ajax Callback to update your two fields?

[Tbrondolo]

Re: Problem with list refresh, anyone experience this?

Hi Dave,

I'm using the Ajax callback for the update as the CRUD operation was add a new record instead of updating the existing record. When you say you used the fields from the list control did you directly reference those fields or did you create new fields that matched those in the control. In my UX when the user clicks on the row the panel sides to an edit panel which has defined fields that are populated through javascrpt. When the user clicks the Update button the callback is made and the data from those fields are used to update the record. My approach should not matter since i don't refresh the list control until the update is completed. I don't think this is a simple failure of the control but rather a compounding of everything else I have going on with this. My list is data bound to a Data Series and maybe that is part of the problem. I'm going to look at that a little more closely.

Thanks for looking at this.

Tom

[Tbrondolo]

Re: Problem with list refresh, anyone experience this?

Correction, it's not bound to a data series but rather to a SQL query statement.

[Tbrondolo]

Re: Problem with list refresh, anyone experience this?

Ok, I found a workaround. After the update I amended the javascript so that it completely re-filters the list.

Instead of using the row refresh I am using the following which is used to generate the list at the start.

{dialog.object}._filterList('Entered','actiondate=:a_date','',params);

This seems to work fine and allows me to MOVE ON !

Thanks

tom

[Davidk]

Re: Problem with list refresh, anyone experience this?

I tried to match what you described. On Panel1 I have my List. On Panel2 I have two textbox controls.

This List control is populated with a SQL statement.
The textbox controls are data bound to the same table as the List control.
Textbox data population is Action Javascript
Textbox update is Server-side afterDialogValidate

As long as you got it working.

[Davidk]

Re: Problem with list refresh, anyone experience this?

Here's a really simply UX illustrating the process discussed in this thread, bound to the Northwind.mdb with a connection named "northwinds". I think this is a pretty good example because it primarily uses the tools with little coding. It's pretty much just like one of the examples in the video list except that here we're moving between panels.