[afrathParticipant]

any progress?

[afrathParticipant]

Any idea?

[afrathParticipant]

But i need the above example in excel mode type.

[afrathParticipant]

I’m not sure whether I conveyed the requirement correctly. Here is what I was expecting in ‘Excel’ mode of filtering. The first image lists all values for city and country. The second image is the result of filtering the first three cities and the country column correctly shows only the countries from the result set. However, if I further want to filter the selected countries (like in excel), the control shows all values of countries instead of just the selected ones. This is the nature of filtering in Excel and is there any way by which I can implement this in your control? We work with large datasets and this sort of filtering would hugely help. Please let me know.

[afrathParticipant]

i didnt understand your reply. actually i need the cascade excel type filtering option in the above pic.

[afrathParticipant]

but in the work around grid ie cascading customization approach in the row based filter row the sorting, and multiple selection is not achieving so it will makes problems for multiple select?

[afrathParticipant]

is it possible to do above logic in filtermode: ‘excel’, ?? if yes can you show me the demo?

[afrathParticipant]

for the above picture 3rd column country showing all the values , why the 3 rd column shows all the values?? (it’s wrong right?)

expected result
if we applied a filter ie in the above example ship name , so remaining column filters are filled based on the value of ship name right?

[afrathParticipant]

[afrathParticipant]

because jqxgrid gives the my remaining requirements

[afrathParticipant]

Hi need jqgxrid and checkbox in front for multiple selection. so anyway to possible to find row is checked or not??

[afrathParticipant]

i need to check the selection checkbox is active or not? using any selectors?

i have a table with rows

checkbox(selection for multiple), patient,invoice

example if we click patient name in the grid need to select all the patient name with same name , if click again same patient name it deselect ,e if toggle method.

for this i need to identify checkbox is active or not like this..

if ($(this).find(“input[type=’checkbox’]”).filter(‘[patientname=”‘ + patientname + ‘”]&&[sender=”‘ + sendername + ‘”]’).prop(“checked”))
{
(this).find(“input[type=’checkbox’]”).filter(‘[patientname=”‘ + patientname + ‘”]’).prop(‘checked’, false);
}
else
{
}
i need the above functionality in jqxgrid
}

[afrathParticipant]

if cell sorting applied for the grid then the checkbox selection and deselection is not working based on the logic
$(‘#jqxgrid’).jqxGrid(‘selectrow’, i);

[afrathParticipant]

Hi

I create a grid with filter ,

1. rendered all the data in grid . and i clicked a cell in the grid based on the cell value i looped though all rows and checked that cell value is equal to the all the rows value if matches i checked all the rows with the matching value.
$(“#jqxgrid”).on(‘cellclick’, function (event) {
var editrow;
var isChecked = false;
var column = event.args.column;
var rowindex = event.args.rowindex;
var columname = event.args.datafield;
editrow = rowindex;

if (columname == “Sender”) {
var dataRecord = $(“#jqxgrid”).jqxGrid(‘getrowdata’, editrow);

var rows = $(‘#jqxgrid’).jqxGrid(‘getrows’);
if ($(‘#jqxgrid’).jqxGrid(‘getselectedrowindexes’).length > 0) {
$(‘#jqxgrid’).jqxGrid(‘clearselection’);
isChecked = true;
}
for (var i = 0; i < rows.length; i++) {
if (rows[i].Sender === “AAA” && !isChecked) {
$(‘#jqxgrid’).jqxGrid(‘selectrow’, i);
}
}

}
});
The above code is working based on my requirment toggle and detoggle.

2. ISSUE IS
if we applied the filter and we click the cell
the above code is not working. not working means the row is not selecting and deselecting.

[Author]

Posts