New to Kendo UI for jQuery? Start a free 30-day trial

Messages.fieldMenu

configuration

The text messages displayed in the field menu.

messages.fieldMenu

Object

<div id="pivotgrid"></div>
<script>
$("#pivotgrid").kendoPivotGrid({
    filterable: true,
    height: 550,
    messages: {
        fieldMenu: {
            info: "Show items with value that:",
            sortAscending: "Sort Ascending",
            sortDescending: "Sort Descending",
            filterFields: "Fields Filter",
            filter: "Filter",
            include: "Include Fields...",
            title: "Fields to include",
            clear: "Clear",
            ok: "Ok",
            cancel: "Cancel"
        }
    },
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
        rows: [{ name: "[Product].[Product]" }],
        measures: ["[Measures].[Internet Sales Amount]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            },
            read: {
                url: "https://demos.telerik.com/service/v2/olap/msmdpump.dll",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
            }
        },
        schema: {
            type: "xmla"
        }
    }
});
</script>

messages.fieldMenu.cancel

String

The text of the cancel button in the include fields dialog.

Default: "Cancel"

<div id="pivotgrid"></div>
<script>
$("#pivotgrid").kendoPivotGrid({
    filterable: true,
    height: 550,
    messages: {
        fieldMenu: {
            cancel: "Close"
        }
    },
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
        rows: [{ name: "[Product].[Product]" }],
        measures: ["[Measures].[Internet Sales Amount]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            },
            read: {
                url: "https://demos.telerik.com/service/v2/olap/msmdpump.dll",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
            }
        },
        schema: {
            type: "xmla"
        }
    }
});
</script>

messages.fieldMenu.clear

String

The text of the clear filter expressions button.

Default: "Clear"

<div id="pivotgrid"></div>
<script>
$("#pivotgrid").kendoPivotGrid({
    filterable: true,
    height: 550,
    messages: {
        fieldMenu: {
            clear: "Clear filter expressions"
        }
    },
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
        rows: [{ name: "[Product].[Product]" }],
        measures: ["[Measures].[Internet Sales Amount]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            },
            read: {
                url: "https://demos.telerik.com/service/v2/olap/msmdpump.dll",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
            }
        },
        schema: {
            type: "xmla"
        }
    }
});
</script>

messages.fieldMenu.filter

String

The text messages of the filter button.

Default: "Filter"

<div id="pivotgrid"></div>
<script>
$("#pivotgrid").kendoPivotGrid({
    filterable: true,
    height: 550,
    messages: {
        fieldMenu: {
            filter: "Done"
        }
    },
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
        rows: [{ name: "[Product].[Product]" }],
        measures: ["[Measures].[Internet Sales Amount]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            },
            read: {
                url: "https://demos.telerik.com/service/v2/olap/msmdpump.dll",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
            }
        },
        schema: {
            type: "xmla"
        }
    }
});
</script>

messages.fieldMenu.filterFields

String

The text messages of the fields filter menu item.

Default: "Fields Filter"

<div id="pivotgrid"></div>
<script>
$("#pivotgrid").kendoPivotGrid({
    filterable: true,
    height: 550,
    messages: {
        fieldMenu: {
            filterFields: "Filter current field"
        }
    },
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
        rows: [{ name: "[Product].[Product]" }],
        measures: ["[Measures].[Internet Sales Amount]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            },
            read: {
                url: "https://demos.telerik.com/service/v2/olap/msmdpump.dll",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
            }
        },
        schema: {
            type: "xmla"
        }
    }
});
</script>

messages.fieldMenu.include

String

The text messages of the include menu item.

Default: "Include Fields..."

<div id="pivotgrid"></div>
<script>
$("#pivotgrid").kendoPivotGrid({
    filterable: true,
    height: 550,
    messages: {
        fieldMenu: {
            include: "Choose fields to include"
        }
    },
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
        rows: [{ name: "[Product].[Product]" }],
        measures: ["[Measures].[Internet Sales Amount]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            },
            read: {
                url: "https://demos.telerik.com/service/v2/olap/msmdpump.dll",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
            }
        },
        schema: {
            type: "xmla"
        }
    }
});
</script>

messages.fieldMenu.info

String

The text messages displayed in fields filter.

Default: "Show items with value that:"

<div id="pivotgrid"></div>
<script>
$("#pivotgrid").kendoPivotGrid({
    filterable: true,
    height: 550,
    messages: {
        fieldMenu: {
            info: "Filter items by field name:"
        }
    },
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
        rows: [{ name: "[Product].[Product]" }],
        measures: ["[Measures].[Internet Sales Amount]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            },
            read: {
                url: "https://demos.telerik.com/service/v2/olap/msmdpump.dll",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
            }
        },
        schema: {
            type: "xmla"
        }
    }
});
</script>

messages.fieldMenu.ok

String

The text of the OK button in the include fields dialog.

Default: "Ok"

<div id="pivotgrid"></div>
<script>
$("#pivotgrid").kendoPivotGrid({
    filterable: true,
    height: 550,
    messages: {
        fieldMenu: {
            ok: "Done"
        }
    },
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
        rows: [{ name: "[Product].[Product]" }],
        measures: ["[Measures].[Internet Sales Amount]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            },
            read: {
                url: "https://demos.telerik.com/service/v2/olap/msmdpump.dll",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
            }
        },
        schema: {
            type: "xmla"
        }
    }
});
</script>

messages.fieldMenu.operators

Object

The text of the filter operators displayed in the filter menu.

<div id="pivotgrid"></div>
<script>
$("#pivotgrid").kendoPivotGrid({
    filterable: true,
    height: 550,
    messages: {
        fieldMenu: {
            operators: {
                contains: "Contains",
                doesnotcontain: "Does not contain",
                startswith: "Starts with",
                endswith: "Ends with",
                eq: "Is equal to",
                neq: "Is not equal to"
            }
        }
    },
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
        rows: [{ name: "[Product].[Product]" }],
        measures: ["[Measures].[Internet Sales Amount]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            },
            read: {
                url: "https://demos.telerik.com/service/v2/olap/msmdpump.dll",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
            }
        },
        schema: {
            type: "xmla"
        }
    }
});
</script>

messages.fieldMenu.sortAscending

String

The text message displayed for the menu item which performs ascending sort.

Default: "Sort Ascending"

<div id="pivotgrid"></div>
<script>
$("#pivotgrid").kendoPivotGrid({
    sortable: true,
    height: 550,
    messages: {
        fieldMenu: {
          sortAscending: "Sort (asc)"
        }
    },
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
        rows: [{ name: "[Product].[Product]" }],
        measures: ["[Measures].[Internet Sales Amount]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            },
            read: {
                url: "https://demos.telerik.com/service/v2/olap/msmdpump.dll",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
            }
        },
        schema: {
            type: "xmla"
        }
    }
});
</script>

messages.fieldMenu.sortDescending

String

The text message displayed for the menu item which performs descending sort.

Default: "Sort Descending"

<div id="pivotgrid"></div>
<script>
$("#pivotgrid").kendoPivotGrid({
    sortable: true,
    height: 550,
    messages: {
        fieldMenu: {
          sortDescending: "Sort (desc)"
        }
    },
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
        rows: [{ name: "[Product].[Product]" }],
        measures: ["[Measures].[Internet Sales Amount]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            },
            read: {
                url: "https://demos.telerik.com/service/v2/olap/msmdpump.dll",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
            }
        },
        schema: {
            type: "xmla"
        }
    }
});
</script>

messages.fieldMenu.title

String

The title of the include fields dialog.

Default: "Fields to include"

<div id="pivotgrid"></div>
<script>
$("#pivotgrid").kendoPivotGrid({
    filterable: true,
    height: 550,
    messages: {
        fieldMenu: {
            title: "Choose fields to include"
        }
    },
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
        rows: [{ name: "[Product].[Product]" }],
        measures: ["[Measures].[Internet Sales Amount]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            },
            read: {
                url: "https://demos.telerik.com/service/v2/olap/msmdpump.dll",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
            }
        },
        schema: {
            type: "xmla"
        }
    }
});
</script>

Related Members