How to filter data with DataSourceLoadOptions on the server

Hi ilya,

Thanks for the suggestion.

In my actual project i used to call the procedure there i am passing  CCount as parameter and based on that i am getting data not like here.
Your approach i followed and i just did that when model return data based on CCount then in the resultset CCount item is null which i am updating before sending content back to the called datagrid. in that case i am getting below grid data as well.

Thank you for all your support.

Here i have one small issue like suppose i click on first checkbox in Summary datagrid and get the data based on it in below grid.
Now i select second check box. Then uncheck the second chekbox in that case cell click event is firing but when i uncheck first checkbox then cell click is not firing. My requirement here is if user has deselected all the checkbox either click of all or one by one then detail grid should load. but it is not happening.

Kindly suggest.

Veera

Hello Veera,
The cellClick() event handler is invoked correctly when you uncheck the last selected row. However, in this case, the "filter.length > 0" condition is false, and the CPT_byPayorDetails grid source is not refreshed. I suggest you extend the condition so that the default filter value (['CCount', '=']) is forwarded to the dataSource.filter option when no rows are selected. Then, invoke dataSource.load() to refresh the source.

I've captured a screencast demonstrating how to fix this behavior at runtime in the browser developer tools (F12).

Hi ilya,

Yes you was right. i have gone through the attached mp4 and according to this video i am validating filter length >=0 in this case it is working fine.

Kindly let me know if you have any concern or suggestion on it.

Thanks,

Veera

Hi,
I'm happy to hear that you have resolved the issue. However, the "filter.length >= 0" condition is always true since the array length cannot be negative. Thus, this condition doesn't make sense.

My idea is to invoke separate logic when the filter is empty.

JavaScript
function cellClick(e) {  
    var getSelectedData = e.selectedRowsData;  
    var filter = [];  
    for (var i = 0; i < getSelectedData.length; i++) {  
        var ccountValue = getSelectedData[i].CCount;  
        if (i > 0) {  
            filter.push("or");  
        }  
        filter.push(['CCount', '=', ccountValue]);  
    }  
    if (filter.length == 0) {  
        filter.push(['CCount', '=']);  
    }  
    var dataSource = $("#CPT_byPayorDetails").dxDataGrid("instance").getDataSource();  
    dataSource.filter(filter);  
    dataSource.load();  
}  

This way, neither of data items will satisfy the filter, and the grid won't display any rows.

Hi Ilya,

Here is one issue i found in above code like if suppose i have more than 200 CCount selected row by user then it is throwing client side error like 404 not found. When i checked in Network tab of Developer tools in browser then get to know that when application url is passing CCount value as Query string then it reaches the limit of it and due to it is throwing error.

Kindly provide the solution for it.

Thanks,

Vikash