[alesParticipant]

Hi Peter,
I mean, that the behaviour of the grid is inconsistent in regard of dates, because if the date is initially set in the localdata as Number (see “Mary” in the localdata definition http://jsfiddle.net/6VWdZ/4/), it is displayed properly. But when the date is set as Number in the updaterow method, it is not displayed properly (see “Peter” in the example).

Ales

[alesParticipant]

Did you see the example http://jsfiddle.net/6VWdZ/4/?

[alesParticipant]

Sending date as Java Script Date Object works, when I prepare the data manually. In a real world I use Play Framework as a server and I am able to convert the Java Date object to JSON only as number or ISO date string. Converting to “new Date(1310669017000)” without quotation marks is not possible (at least I do not know how to do it in Play Framework’s JSON library).

Why is it not possible to send date as string in ISO format? Or could you process the dates as numbers? It seems that you already are able to recognize numbers as dates and that there is only a problem in the “updaterow” method – see http://jsfiddle.net/6VWdZ/4/ – Mary has her date ok but Peter not (it is set via “updaterow”). Would you repair the “updaterow” method, please?

Ales

[alesParticipant]

I have got it. The problem was that the json data were not formatted property. The format of the date was wrong: “15.10.2014 00:00:00.000”. When the source data were “2014-10-15T00:00:00.000Z”, the behavior is correct.

But there is another problem: after saving data to the database, the saved row is returned back to the client (there can be some db triggers, that can modify saved data for example). The returned row is then pushed to grid via “updaterow” method (see below). Everything is fine except the datetime fields. They are not formatted properly and show ‘2014-10-15T00:00:00.000Z’ value.

           $.ajax({
                dataType: 'json',
                type: 'POST',
                url: url,
                cache: false,
                data: data,
                success: function(data, textStatus, jqXHR){
                  $("#main_jqxGrid").jqxGrid('updaterow', currentScope.objectsToSave[i], data);
                  $('#main_jqxGrid').jqxGrid('refreshdata');
                }
            });

Where is the problem, please?

Ales

[alesParticipant]

I have prepared jsfiddle example here: http://jsfiddle.net/bTur4/. Please, look at it.

[alesParticipant]

Thank you for your response. I will try to find some solution for some of the missing methods, but the cell selection is crucial for us.

[alesParticipant]

Do you plan to add such feature in the future?

NOTE: it would be fine this forum to have a possibility to receive responses by e-mail. I did not catch your response in time.

[alesParticipant]

Hi, is this possible, please?
Ales

[alesParticipant]

You are right and it works now. Thank you! I was really a puzzle for me, because I thought that the Esc key was consumed by the window.

[alesParticipant]

Or maybe it would be sufficient if the cell editor stays visible during the window open/close period. But how to achieve that?

[alesParticipant]

I did the following and it works fine:

$("#selectWindow").keydown (function (event) {
   if (event.which == 13)  // Enter
     alert('hi');
});

You do not need to respond to this question. Thanks.

[alesParticipant]

Great! It works! Many thanks.

[Author]

Posts