How to trigger "Refresh" programmatically?

[Tim]

Dear All,

Is that a possible way that I can pull the exact function of the "Refresh" as shown in the attachment?

Thank you and Regards.

[Attila Antal]

Hi Tim,

The refresh button of the PivotGrid is actually calling the rebind() method. You could do that too either on the client-side by using the rebind() method (see RadPivotGrid Client-Side Methods) or you could call the Rebind() method on the server-side (see RadPivotGrid Server-Side Methods).

[Tim]

Anyone can give a hand? I'm asking the question because I was following this telerik demonstration to build a drill down pivotgrid. However it stops working when I switch the fields until I need to press the "Refresh" manually. I've tried using Rebind(), but that doesn't do the trick.

[Tim]

I don't think it'll be that difficult but I've not clue where to start, any suggestions to this work around?

[Viktor Tachev]

Hi Tim,

The issue you describe seems rather strange. You could try couple of things that could help point us in the right direction.

Would you check the browser console and ensure that there are no JavaScript errors on the page? Would you also try disabling Ajax on the page and let me know if the behavior changes?


Regards,
Viktor Tachev
Telerik

 

 

[Tim]

Hi Viktor, 

Thanks for the reply, it's not actually an error, but more of incompatibility between the drill down functionality and my project. Sorry for overly simplifying the question.

As we know the key principal of the drill down functionality is to allow the users to read what filters the cell is under when user clicks: for instance from the demo, wheres give the filter and their corresponding values.

Extracted codes from demo:
string[] groups = e.CommandArgument.ToString().Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
                StringBuilder wheres = new StringBuilder();

                if (groups.Count() > 0)
                {
                    string[] elements = groups[0].Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
                    foreach (var element in elements)
                    {
                        var pairs = element.Split(new char[] { '~' }, StringSplitOptions.RemoveEmptyEntries);
                        wheres.Append(string.Format("{0} = '{1}' AND ", pairs[0], pairs[1]));
                    }

The problem occurs when I change my filters, the e.CommandArgument will continue to read the old filter value, and this can only be corrected by clicking the "Refresh" button manually. That's why giving the question as described.

Thanks.

[Viktor Tachev]

Hi Tim,

I am afraid that without debugging the code it would be hard to determine what is causing the old filter values to be applied.

Would you build a runnable project where the issue is replicated and send it to us in a support ticket? This would allow us to thoroughly investigate the issue and look for its cause.


Regards,
Viktor Tachev
Telerik

 

 

[Tim]

Hi Viktor, I'll gladly do. Thanks!

[Prof. Francisco Araújo]

Any solution?...

[Attila Antal]

Hi Francisco,

We have not heard from Tim about his request and therefore we do not know what can be the cause. In order to investigate an issue, we need more details that will help us replicate the problem. 

Please share a runnable sample we could use, or post the current configuration of the PivotGrid, describe the problem, and share any error logs, screenshots that could be helpful.

Once we have enough information to replicate the scenario, we will be able to identify the issue and give you further instructions.