[assaf.frank123Participant]

Thank you.
This colored the current row upon click.

Now I am trying to override the cell over and cell selected classes (for the row that is green now I wish that when the selection checkbox is clicked – the color will not change from the green I gave and nor should the color change upon hover). The css below caused it to be white upon hover or checbox selection..) How would I implement this?

Thanks.

#myGrid .jqx-grid-cell-selected {
background:transparent;
background-color: transparent;
}
#myGrid .jqx-grid-cell-selected-web {
background:transparent;
background-color: transparent;
}
#myGrid .jqx-grid-cell-hover {
background:transparent;
background-color: transparent;
}
#myGrid .jqx-grid-cell-hover-web {
background:transparent;
background-color: transparent;
}

[assaf.frank123Participant]

1. How about passing the data by JSON from the server? Can this improve the loading time?
2. Are you aware of any browser caching issue – perhaps getting too large?. We notice that on some desktops loading screens are very slow while on others
it goes much faster. Both desktops are strong i5 machines. We noticed that after restarting the problematic computer the situation improves for a
little but gets worse again very quickly. We are working with chrome browser.

Thanks

[assaf.frank123Participant]

Hi,

I wanted to use this solution to change the color and width of the ticks in position 0 & 10.
For some reason – even though the code is executed – and I get the “children” ticks it has no affect on my slider .

Any idea? (I have several sliders in my page).

Thanks

[assaf.frank123Participant]

Thanks.
That did the trick and works fine with many records in the grid.

[assaf.frank123Participant]

OK , this works but there are 2 issues-

1. It works only if the column is a text input column. If I use columntype: ‘numberinput’ this will not work (expect a number to be
returned in the aggregates and not a String (the span string) – any way around this? achieve what I want event with a number input column?
2. Later in the code I perform a change of the table width –
$(‘#jqxgrid’).jqxGrid({ height: tableHeight });

This is in order to use the maximum height available according to screen resolution (autoheight has limitations regarding the column headers
not being in place).

This causes the renderer function to execute once more after the grid ready function that performs the initialization of the aggreagateTotal
span – the value is erased by this. Any way to prevent this? or achieve the maximum height available without changing by API?

Thanks

[assaf.frank123Participant]

Hi Dimitar,

going back to my issue of needing to set a value in the “total” bottom line – without actually performing all the aggregates functions etc.
(so the browser will not crash with many rows).

Is there any way to access the aggregates total row’s HTML directly and setting my content there myself?
If possible – I wish to implement an on Filter function that will access the newly calculated (after the filter) sum of column A and divide it by
by the newly sum of column b – the result is to be set directly in column C.

If I can just access the totals row and fetch A & B and set C this will work even with many rows (will be done only once).

Any option for this?

Thanks,

[assaf.frank123Participant]

Is there any way to get the visible row indexes then?

I would loop over all selected rows and only if they are visible will the action be performed on it..

Can –
var rows = $(‘#jqxGrid’).jqxGrid(‘getdisplayrows’);

help me?

[assaf.frank123Participant]

This is not a good solution –
My calculation is the average cost of an item = (totalCost / totalNumItems) which is not equal
the some or average of each row..

Any other solution I can access the summary row after the table is loaded and insert my values then
(I would access the summaryData for both columns and set the required value)?

Thanks

[assaf.frank123Participant]

Hi Peter,
I think this is a faulty design.

I a user’s perspective:
I am working on your nice grid with filter options for the rows.
I got from a 1000 rows table down to the 15 rows I am interested in – I wish to “select all” and perform an action on these…

Unknowingly – the action is performed on all the records..

This sounds like a bug in design.

The selectAll is not usable for grids with filters..

Please reconsider.

Thanks.

[assaf.frank123Participant]

Hi,

After implementing both the custom aggregate function as well as an aggregate renderer function I see
when a table with a few thousand rows – the browser crashes.
both functions are called for every row.

Isn’t there a way to do the same calculation only once ?

Thanks..

aggregates: [{ ”:
function (aggregatedValue, currentValue, column, record) {
var cost = $(“#jqxmachinesgrid”).jqxGrid(‘getcolumnaggregateddata’, ‘cost’, [‘sum’]);
var leads = $(“#jqxmachinesgrid”).jqxGrid(‘getcolumnaggregateddata’, ‘numLeads’, [‘sum’]);
if (leads.sum > 0) {
return (cost.sum/leads.sum);
} else {
return ”;
}
}
}],
aggregatesrenderer: function (aggregates, column, element, summaryData) {
var renderstring = “<div style=’font-size:11px;float: left; width: 100%; height: 100%;’>”;
$.each(aggregates, function (key, value) {
renderstring += ‘<div style=”position: relative; margin: 6px; text-align: left; overflow:
hidden;”>’ + value + ‘</div>’;
});
renderstring += “</div>”;
return renderstring;
}

[assaf.frank123Participant]

OK, solved with an aggregatesrenderer function after that.

[assaf.frank123Participant]

Great, the data is shown properly.

The only thing – I wish not to display any label except the calculated value.

Meaning, I removed the “‘<b>Total</b>'” but still get a “:” next to the value.

How can I remove this?

Thanks.

[assaf.frank123Participant]

Thanks , this works.

1 thing –

The column password is visible when the grid is populated.
only once I click the cell and edit the value the password input is populated and chars are hidden.
Is there anyway the cell upon population will display the hidden password (I mean display ***** instead of the chars)?

Thanks.

[assaf.frank123Participant]

I got it working thank you.
I didn’t realize you can access the grid by –

var data = grid.jqxGrid(‘getrowdata’, row);

in the initrowdetails function.

Thank you !

[assaf.frank123Participant]

Do you mead in the initrowdetails function?

Where would I get the ID from?
grid.id is undefined..

var initrowdetails = function (index, parentElement, gridElement, record) {
var id = record.uid.toString();
var grid = $($(parentElement).children()[0]);
nestedGrids[index] = grid;

[Author]

Posts