Intersoft Community - WebGrid Enterprise - Error While retaining Expanded group row state when the number of records exceed VirtualPageSize

Error While retaining Expanded group row state when the number of records exceed VirtualPageSize

Hans — Mon, 09 Jul 2012 21:41:18 GMT

Hi,

I’m glad to hear that you have solved your issue.
Should you have further question, please do not hesitate to contact us.
I would be happy to help you again.

Thank you.

Regards,
Hans.

Error While retaining Expanded group row state when the number of records exceed VirtualPageSize

sigmasolution — Mon, 09 Jul 2012 13:19:40 GMT

Hi hans ,

Thank you for your replay .

Now it works very well.

Thank you .

Regards ,

Sigma team

Error While retaining Expanded group row state when the number of records exceed VirtualPageSize

Hans — Mon, 09 Jul 2012 03:58:33 GMT

Hi,

Thank you for your reply.
I’m glad to hear that you’ve found a workaround for this issue although it’s still partially done.

Could you kindly explain in details what you’ve done in your code and what the result is with using your workaround?
Or if you don’t mind, could you provide me the sample that replicate your issue? So that, I can investigate this issue further more on my end.

Thank you.

Regards,
Hans

Error While retaining Expanded group row state when the number of records exceed VirtualPageSize

sigmasolution — Fri, 06 Jul 2012 11:51:16 GMT

Hi hans ,

I made a small modification in the fonction and it works partiely

var WebGrid1 = ISGetObject(controlId);

if (actionName == "Refresh" || actionName == "ColumnSort") {

if (expandedGroupNodes != null) {

var splitResult = expandedGroupNodes.split(";");

intervalObj = setInterval(

function() {

if (!WebGrid1.IsInProgress) {

if (i < splitResult.length - 1) {

var gridAndPosition = splitResult[i].split(":");

WebGrid1.RootTable.GetRowByGroup(0, gridAndPosition[1]).ExpandGroupRow();

i++;

}

if (i >= splitResult.length - 1) {

clearInterval(intervalObj);

intervalObj = null;

i = 0;}}}, 5);}

}

I retiriev Expanded Grouped rows if rowindex < the VirtualPageSize(in my case 32) else the group is collapsed.

thank you

Best regards

Sigma team

Error While retaining Expanded group row state when the number of records exceed VirtualPageSize

sigmasolution — Fri, 06 Jul 2012 11:27:48 GMT

Hi hans,

Thanks for your suggestion, I have no java script error but i don't retrieve my Expanded Grouped rows also.

thank you

Regards

Sigma

Error While retaining Expanded group row state when the number of records exceed VirtualPageSize

Hans — Fri, 06 Jul 2012 06:39:53 GMT

Hi,

Thank you for your information code and I apologize for any inconveniences this problem may have caused you.

I’ve made a sample that perhaps similar with your current scenario (based on information code). I bind the WebGrid to Northwind.mdb database and Orders table.
I try to expand a couple of grouped rows, then I refresh the WebGrid. And I get a java script error as well.

To fix this issue, you should modify your code in OnAfterResponseProcess function.
Here I enclosed the code:

var i = 0;var intervalObj;
function WebGrid1_OnAfterResponseProcess(controlId, actionName, lastRequestObject, xmlResponseObject) {
    var WebGrid1 = ISGetObject(controlId);
    if (actionName == "Refresh" || actionName == "ColumnSort") {
        if (expandedGroupNodes != null) {
            var splitResult = expandedGroupNodes.split(";");
            intervalObj = setInterval(function () {
                if (!WebGrid1.IsInProgress) {
                    if (i < splitResult.length - 1) {
                        WebGrid1.RootTable.GetRowByGroup(0, splitResult[i]).ExpandGroupRow();
                        i++;
                    }
                    if (i >= splitResult.length - 1) {
                        clearInterval(intervalObj);
                        intervalObj = null;
                        i = 0;
                    }
                }
            }, 5);
        }
    }
    return true;
}

Please have a review in my sample and let me hear your response.

Thank you.

Regards,
Hans.

Error While retaining Expanded group row state when the number of records exceed VirtualPageSize

sigmasolution — Thu, 05 Jul 2012 14:22:44 GMT

Hi All,

when I have the number of records more then VirtualPageSize(in my case 32) in a grid i have a java script error when i tray to retrive Expanded Grouped rows when row index is upper then VirtualPageSize(in my case 32) .

i used this function to retaining the Expanded Grouped rows.

function WebGrid1_OnAfterResponseProcess(controlId, actionName, lastRequestObject, xmlResponseObject) {var WebGrid1 = ISGetObject(controlId);

if (actionName == "Refresh" || actionName == "ColumnSort") {

if (expandedGroupNodes != null) {

var splitResult = expandedGroupNodes.split(";");

for (var i = 0; i < splitResult.length; i++)

WebGrid1.RootTable.GetRowByGroup(0, splitResult[i]).ExpandGroupRow();}}

return true;

}

see attached file .

Is there any solution to this issue?

Best regards

thanks