Customising the Grid

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
PointsWell
Posts: 1457
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Customising the Grid

Post by PointsWell »

Is this https://demos.telerik.com/kendo-ui/grid/index something that can be achieved via JS magic or is it something that AIM needs to be updated to do?

The example that might not be obvious is that the column headers are draggable and reorderable that allows the end user to create group categories like this:
Screen Shot 2020-02-27 at 15.30.36.png
Screen Shot 2020-02-27 at 15.30.36.png (66.15 KiB) Viewed 14130 times
If it is a JS fiddle magic does anyone have an example they can share?

Thank you in advance.
ACDC
Posts: 1138
Joined: Sat Jun 30, 2007 5:03 pm
Location: California, USA

Re: Customising the Grid

Post by ACDC »

1000 + - This makes huge sense, being able to group data in the grid on the front end is big, users can make data more meaningful without having rely on the developer to hard code grouping.
johntalbott
Posts: 619
Joined: Wed Jun 17, 2015 11:16 pm
Location: Omaha, Nebraska
Contact:

Re: Customising the Grid

Post by johntalbott »

Query Init Script
config.groupable: = true,
VocalDay Solutions - Agility - Predictability - Quality

We specialize in enabling business through the innovative use of technology.

AwareIM app with beautiful UI/UX - https://screencast-o-matic.com/watch/crfUrrVeB3t
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

Re: Customising the Grid

Post by swiftinitpvtltd »

Great tip! Works just fine. Need small edits.

config.groupable: = true

to

config.groupable = true; --- this works
ACDC
Posts: 1138
Joined: Sat Jun 30, 2007 5:03 pm
Location: California, USA

Re: Customising the Grid

Post by ACDC »

wow, as simple as that :shock: ,
what a hidden gem. I wonder how many others are out there.

I am sure Frozen Columns can be done the same way
https://demos.telerik.com/kendo-ui/grid/frozen-columns

thank you for this one
PointsWell
Posts: 1457
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Customising the Grid

Post by PointsWell »

johntalbott wrote:Query Init Script
config.groupable: = true,
Simples! Thanks John.

Is there a way to set the initial categories to make the grid load with a default grouping?
PointsWell
Posts: 1457
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Customising the Grid

Post by PointsWell »

ACDC wrote:wow, as simple as that :shock: ,
what a hidden gem. I wonder how many others are out there.

I am sure Frozen Columns can be done the same way
https://demos.telerik.com/kendo-ui/grid/frozen-columns

thank you for this one
After some testing it seems that it does it frozen columns by default.
chris29
Posts: 173
Joined: Sat Feb 06, 2010 1:45 am
Location: Australia

Re: Customising the Grid

Post by chris29 »

WOW!!

Fantastic thanks johntalbott

Only issue appears to be with numbers and dates, they are displayed as
grouping.png
grouping.png (13.52 KiB) Viewed 14047 times
Any ideas on how to fix this ?

Ideally this should just be a checkbox on the properties of the Query definition [Support, next update??]
Version 8.5 - Windows using MySql 8 and SQL Server - 64bit
johntalbott
Posts: 619
Joined: Wed Jun 17, 2015 11:16 pm
Location: Omaha, Nebraska
Contact:

Re: Customising the Grid

Post by johntalbott »

PointsWell wrote:
johntalbott wrote:Query Init Script
config.groupable: = true,
Simples! Thanks John.

Is there a way to set the initial categories to make the grid load with a default grouping?
A single grouping column can be set up in the config tool. For more flexibility similar to the Kendo demo it can be done with js .
VocalDay Solutions - Agility - Predictability - Quality

We specialize in enabling business through the innovative use of technology.

AwareIM app with beautiful UI/UX - https://screencast-o-matic.com/watch/crfUrrVeB3t
Post Reply