Showing column menu with option to hide columns in one column while showing filters in other columns

[Vijai]

I currently have 8 columns in the grid and each column has the filter option enabled. I want to add more columns and provide the option to hide columns to the user.

I want to retain the filter option in all columns as it is most often used by the user, but provide the 'hide column' option ONLY in the last column, as in the attached mockup. 

Is this possible? If so, how?

Is it like hide columnmenu in all columns except the last one and setting columns.filterable = true for all other columns?

Sorry for not adding any code, I am not a dev!

[Nikolay]

Hi Vijai,

This can not be set with the current Grid API, however, it can be achieved with custom logic in the columnMenuInit event handler:

• https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/events/columnmenuinit

For example:

columnMenuInit: function(e) {
          if (e.field !== "city") { //different than the last column
            var filterItem =  $(e.container).find(".k-first");
            var separator = $(e.container).find(".k-menu-separator");
            filterItem.hide();
            separator.hide();
          }
        }

Here is a Dojo demo I prepared demonstrating the above:

• https://dojo.telerik.com/AWEwiTiH

Let me know if you have any questions.

Regards,
Nikolay
Progress Telerik

[Vijai]

Thanks Nikolay. Is there a way to show the column menu only in the last column i.e. the three dots only in the last column but show the Filter icon in other columns. I mean in your dojo, the user will need to click the three dots and then select the filter. Is there a way to show the filter icon directly while only showing the three dots in the last column?

[Nikolay]

Hi Vijai,

To achieve this I recommend following the approach shown in the next article:

https://docs.telerik.com/kendo-ui/knowledge-base/grid-conditional-columnMenu

I added logic to update the icons on the columns with no column menu in the dataBound event handler:

https://dojo.telerik.com/ItEMetaZ

Let me know if you have any questions.

 

[Vijai]

Awesome! Thanks for your help Nikolay!

[Nikolay]

Hi Vijai,

You are most welcome. I am glad to hear this is what you were looking for.

Regards,

Nikolay