[taskmateParticipant]

Sir

Kindly correct me if I am wrong.

The behavior changes on the form. ie tab key stops working on the form / web page if a modal window is created or opened. That means that if the modal window is created on the form (not opened till now), the tab stops working.

That means that if we need to create a window on the page and use the tab key on the form then only option is to create a non modal window.

Regards

Sanjay

[taskmateParticipant]

Sir

The same behaviour is noted in 4.5.2 version of jqxWindow.

a) If the window created is not modal then TAB KEY WORKS
b) If the version is revereted to 4.5.0 the tab key works
c) If on version 4.5.2 if the window is created as isModal : False opened and closed tab key works not change property to isModal :true. Tab stops working
d) On using jquery 3.x the problem persists

Regards

Sanjay Gupta

[taskmateParticipant]

Hi

I am a user with small experience but have used Combo Box quite a bit. This could be a reason of not being able to give a absolutely correct answer.

1) Populating on Open
a) This will lead to unnecessary trip to data server as same query will be fired every time the combobox opens. The open is fired when user either clicks on image or gets focus.
b) The same result can be achieved by loading the items on document ready ( Just in case you are not getting the items on ready, you could try to call it with settimeOut();
c) I feel that calling the of search is good with 3 charector lenght.
d) Recommendation : When search fires check in the list of items if the items is present. If yes donot fire the server code

Regards

Sanjay

[taskmateParticipant]

Hi Hristov

Thanks

I works beutifully.

Regards

[taskmateParticipant]

SysProfile

You create the string with said format and pass the value to the grid as string. If the data type is string column will not change format.

Sanjay

[taskmateParticipant]

Hi

Have you tried using

var cellsrenderer = function (row, columnfield, value, defaulthtml, columnproperties) {
if (value < 20) {
return ‘<span style=”margin: 4px; float: ‘ + columnproperties.cellsalign + ‘; color: #0000ff;”>’ + value + ‘</span>’;
}
else {
return ‘<span style=”margin: 4px; float: ‘ + columnproperties.cellsalign + ‘; color: #008000;”>’ + value + ‘</span>’;
}
}

Regards

[taskmateParticipant]

Hi

I am not sure but bindingcomplete would be called once and cellrender would be called [no of rows * no of columns];

But if there is problem on bindingcomplete obviously it can be called on cellrender

Regards

[taskmateParticipant]

Sir

This may not be the best as the code but what I suggest is

$(‘#jqxgrid’).on(‘bindingcomplete’, function (event) {
var rows = $(‘#jqxGrid’).jqxGrid(‘getrows’);
for (var i = 0; i < rows.length ; i++){
var bvalue = rows[i][‘b’];
if (i ==0){
if (!bvalue){bvalue = 0;}
} else {
bvalue = rows[i-1][‘d’];
}

var cvalue = rows[i][‘c’];
if (!cvalue){cvalue = 0;}
var dvalue = parseInt(bvalue) – parseInt(cvalue);
$(“#jqxgrid”).jqxGrid(‘setcellvalue’, 0, “d”, dvalue);
}
});

[taskmateParticipant]

Hi SysProfile

I tested on fiddle with value of 2016-03-22 12:00:00 and used time zone of -3.00 I got the correct display date of 22Nd March 2016

Regards

[taskmateParticipant]

Hi

The catch is in the timezone setting of the client machine. When I run with my time zone of India +5.30 I get 22nd March. If I change the time zone to -3.00 I get 21st March. You could try by evaluating with time zone of +5.30

Probable Cause

As the passed value is 22nd March 2016 it assumes to be 22nd March 2016 00:00:00 and hence converts to 21st March as you are in -3.00 time zone.

Probable recommendations
a) Pass as String
b) In Data pass value as 22 Mar 2016 12:00:00 (So all times would show 22 Mar 2016)

Regards

[taskmateParticipant]

Hi

When I run the code on jsfiddle I read 22nd March 2016.

Other Dates are
23 March 2016
28 March 2016
31 March 2016
31 March 2016

I am using firefox 45.0.2

Regards

[taskmateParticipant]

Hi

I just ran your data on the fiddle example with json data and probably got correct results

I found an example of the Grid component (http://jsfiddle.net/jqwidgets/5YtCm/) and I did work with json data in your code. The same problem occurs, always subtract 1 day. If you replace your part of html and javascript that designed by me (https://jsfiddle.net/SysProfile/65wx0zqr/) you can check the error.

Kindly let me have some more details just in case I could be of any help

Regards

[taskmateParticipant]

Hi CyberW,

In case name in the database cannot be changed use alias in SQL Query

Regards

[taskmateParticipant]

Hi

$(“#jqxGrid”).on(“pagechanged”, function (event)
{
// event arguments.
var args = event.args;
// page number.
var pagenum = args.pagenum;
// page size.
var pagesize = args.pagesize;

var nwpg = parseInt(pagenum)-1;

var topRw = parseInt(pagesize) * parseInt(nwpg) + 1;
if (parseInt(nwpg) === 0){
topRw =0;
}

var data = $(‘#jqxGrid’).jqxGrid(‘getrowdata’, topRw);

});

Calucate the rowindex of the row on new page and retrieve the data

Regards

[taskmateParticipant]

Hi

$(“#jqxGrid”).on(“pagechanged”, function (event)
{
// event arguments.
var args = event.args;
// page number.
var pagenum = args.pagenum;
// page size.
var pagesize = args.pagesize;

var nwpg = parseInt(pagenum)-1;

var topRw = parseInt(pagesize) * parseInt(nwpg) + 1;
if (parseInt(nwpg) === 1){
topRw =0;
}

var data = $(‘#jqxGrid’).jqxGrid(‘getrowdata’, topRw);

});

Calucate the rowindex of the row on new page and retrieve the data

Regards

[Author]

Posts