How to get a grid row value that was cancelled or recalculate custom controls?

[RichCPT]

I need to know a value that was cancelled, or undone, in a Grid row.
Getting the value that A5 restored is obtained in the "afterRowCancelEdits" event by inserting the following Javascript:

var originalVal = {grid.Object}.getValue('G', 'MY_FIELD_ID' ,e.rowNumber);

But how can I get what the value was before A5 did the undo / cancel in this event? Or, is there another client-side event that can be used to get the two values: 1) value before Undo, and 2) value after Undo?

[Davidk]

Re: How to get a grid row value that was cancelled or recalculate custom controls?

The event canRowCancelEvents will give you what you're looking for.

[RichCPT]

Re: How to get a grid row value that was cancelled or recalculate custom controls?

"canRowCancelEdits" is only fired when an individual row is being undone. I only let the user have the "Cancel" button to undo the whole grid, so "canRowCancelEdits" won't work for me here.

If it did work in this case then what would I use to get the original value that is going to get restored? I kind of need both values at the same time to efficiently redraw some Custom Controls.

[Davidk]

Re: How to get a grid row value that was cancelled or recalculate custom controls?

So you need to know the value, before Cancel, of every field, of every displayed row, that was changed and is about to be changed back to the original value?

[RichCPT]

Re: How to get a grid row value that was cancelled or recalculate custom controls?

David,

Yes, but I only need to know the before and after cancel/undo values of one database field per row. I'm probably doing something uncommon ; I only found one other person with similar question back in 2010 on this newsgroup. At the time the solution was to track the before/after values with their own code instead of finding something already in Alpha.

So, that's what I will do here -- add another hidden field to the grid that I can use to track the value most recently placed into the field. When the "afterRowCancelEdits" JS fires I can use the tracking field to catch what it was prior to Alpha reverting the actual database field to its original value. The additional hidden field will be a Custom type control so I can add custom attributes to it that won't get reset when alpha tries to restore it to its original values.

For anyone interested, the reason I wanted to know the before and after values during the Cancel or Undo event is because I am using up to fourteen Custom Controls in a row of a grid that mimic one group of radio-style buttons. When Alpha restores the underlying database field value I need to redraw the two radio buttons that are affected by the change in value. I could redraw all of the radio controls in the row, but it should only be necessary to redraw the two buttons involved in the change: 1) the button that goes with the "before undo" value, and 2) the button that goes with the "restored" value. I didn't have a "container" field for these radio buttons as they actually appear in their own columns in the grid. The extra hidden control I'm adding will be like a pseudo container control that I can place a couple of properties into that apply to all the radio controls in the group. This is probably better design anyway, having an extra control that acts like a parent control for the custom radio buttons.

[Davidk]

Re: How to get a grid row value that was cancelled or recalculate custom controls?

This might be another option. In the Client-side Event, afterGridCancelEdits

var rowCnt = {grid.object}._rowsInGrid;

for (i=1; i<rowCnt+1; i++)
  {
  var origVal = {grid.Object}.getValue('G','ORDNAME',i)
  alert(origVal);
  }

And, in the canGridCancelEdits event

var rowCnt = {grid.object}._rowsInGrid;

for (i=1; i<rowCnt+1; i++)
  {
  var newVal = {grid.Object}.getValue('G','ORDNAME',i)
  alert(newVal);
  }

I'm guessing you don't really care if something has changed in those fields or not. You're going to process the values in those fields in order to modify your radio buttons anyway. Maybe the radio buttons will change... maybe not... doesn't really matter and long as they end up right.

[RichCPT]

Re: How to get a grid row value that was cancelled or recalculate custom controls?

Yes David I might have to use code like that, but use a global window variable for storing the values at the time the "canGridCancelEdits" event fires. And then compare those values to what I get in the afterGridCancelEdits.

My idea of using a Hidden Custom Control has hit a roadblock because A5 ignores my code to render the custom control if the field has been marked as "Hide Column"
It just spits out its own code. I suppose it doesn't trust me to render the control with the appropriate html to keep it hidden.