Pivot Table : Filter Window menu item/ Label Filter header/ Field Setting Window header

[Shilpa]

Hi

 

As shown in attachments:

1. Filter window:  As we have column in pivot table row fields (Restaurant name), we need with space only in the menu items of Filter Window (Needed : restaurant Name ,Currently showing is without space : restaurantname)

2. In Label Filter/Value Filter headers also we need same thing.

3. In Summarize by settings window header also we need same thing.

 

Currently its showing the name as in database column name

[Shilpa]

Hello team,

 

Please suggest on this.I need this very urgently.

 

Thanks

[Viktor Tachev]

Hi Shilpa,

If you would like to change the text that is displayed next to the filter icon you can use the Caption property of the field.

Additionally, if you would like to change the text only visually you could use JavaScript and modify it. You can handle the OnMenuShown client-side event and implement the logic in it.


Regards,
Viktor Tachev
Telerik

[Shilpa]

Hi Viktor,

Can you please provide the example of OnMenuShow event.

[Shilpa]

And also will this be applicable for all three type of window pop ups

[Shilpa]

Hi team,

 

please reply

 

Thanks

[Viktor Tachev]

Hello Shilpa,

Actually the OnMenuShown would not be suitable because postback is performed when the filter icon is clicked. You can use the PivotGridCreated event in order to change the text in the popup.

<ClientSettings>
    <ClientEvents OnPivotGridCreated="pivotCreated" />
</ClientSettings>

function pivotCreated(sender, args) {
    var spanElement;
    var windowTitle;

    if (sender.get_filterDialog()) {
        spanElement = $telerik.$(".rmRootLink.rmDisabled .rmText");
        spanElement.html(spanElement.html().replace(/([A-Z])/g, ' $1'));
    }
}

Regards,
Viktor Tachev
Telerik

[Shilpa]

thanks for reply Viktor

The code you provided is adding space. 

Actually we want to replace the column names with name as shown in pivot table(i used caption feild to replace the name in table), please find attached image

 

Please reply at earliest.

[Viktor Tachev]

Hi Shilpa,

If you would like to change the FieldName text in the filter dialog you can use similar logic like before. However, instead of adding spaces to the text you should analyze the value and put the necessary replacement text.


Regards,
Viktor Tachev
Telerik

[Praveen]

Hi Viktor,

The above sample code provided by you helped me a lot.

Is there any way to access header for Summarize by Settings/Value Filter as per my findings no css class is present for that.

 

Thanks in advance

[Praveen]

Hi team,

 

Please update we need this urgently.We tried below code on function pivotCreating:

if (sender.get_fieldSettingsWindow()) {
                var pivotGrid = $find("<%=RadPivotGrid1.ClientID%>");
                pivotGrid.get_fieldSettingsWindow().set_title("abc");
            }

But its not working also we tried 

  $find("<%=RadPivotGrid1.ClientID%>").get_fieldSettingsWindow().set_title("abc"); on function pageLoad()

But its not working.

 ​

 

[Viktor Tachev]

Hello,

In order to change the text in the header of the setting window you can use the following selector.

$telerik.$(".rwTitlebarControls em").html("your custom text")

Regards,
Viktor Tachev
Telerik