ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: EPM Solutions on July 10, 2017, 04:01:16 pm

Title: Is it possible to make the grouping in tree view structure
Post by: EPM Solutions on July 10, 2017, 04:01:16 pm

Hi Team,

I would like to make the grouping similar to attached screen shot is that possible to achieve in paramquery?

Title: Re: Is it possible to make the grouping in tree view structure
Post by: paramvir on July 10, 2017, 04:16:29 pm

Yes, row grouping is supported upto any number of levels in Paramquery.

Example: https://paramquery.com/pro/demos/group_rows

Either drag the column titles to group header or pre-define grouped columns as dataIndx property in groupModel.

Title: Re: Is it possible to make the grouping in tree view structure
Post by: EPM Solutions on July 10, 2017, 04:24:27 pm

Hi,

Yes I am aware that we can apply grouping on multiple columns but my question is can we make the grouping structure like tree view withing one column refer my excel report screen shot again.

Best Regards,
Pankaj Srivastava

Title: Re: Is it possible to make the grouping in tree view structure
Post by: paramvir on July 10, 2017, 04:51:12 pm

grouping titles can be made to appear in single column by

1. hiding the grouped columns ( add hidden: true to grouped columns )

https://paramquery.com/pro/api#option-column-hidden

and

2. add summaryInTitleRow: '' to groupModel.

https://paramquery.com/pro/api#option-GM-summaryInTitleRow

Title: Re: Is it possible to make the grouping in tree view structure
Post by: EPM Solutions on July 10, 2017, 05:51:45 pm

This is not seems to be the right approach we can not hide the columns. after hiding our columns data are not appearing. Is there any other method to merge three column header in one column header ?

Title: Re: Is it possible to make the grouping in tree view structure
Post by: paramvir on July 10, 2017, 06:48:43 pm

groupby columns have repetitive data anyway, so if a value is displayed x number of times it's displayed only once in the group title when groupby column is hidden.

Please check this example: https://paramquery.com/pro/demos/group_rows_hidden

Title: Re: Is it possible to make the grouping in tree view structure
Post by: EPM Solutions on July 10, 2017, 09:41:39 pm

Hi Thanks for your support much appreciated !!

How can I enable the filter option if columns are hidden ??

Filter options are also hidden after hiding the columns can we display the filter option if columns are hidden?

Title: Re: Is it possible to make the grouping in tree view structure
Post by: paramvir on July 10, 2017, 11:31:45 pm

Filter options for hidden columns can be displayed in toolbar.

Title: Re: Is it possible to make the grouping in tree view structure
Post by: EPM Solutions on July 12, 2017, 02:43:54 am

Hi toolbar filter are completely different(conditional) than columns filter.. I want to integrate the same as columns dropdown filter after hiding the columns, filters are disappeared how can I get it back??

if my columns are hidden can we position hidden column filter dropdown in different columns or somewhere else in header ?

Title: Re: Is it possible to make the grouping in tree view structure
Post by: EPM Solutions on July 12, 2017, 04:30:01 pm

Hi Thanks for your help much appreciated !!

I have achieved the filter functionality from toolbar.


Best Regards,
Pankaj Srivastava