Author Topic: Tree grid as filter for Grid  (Read 2783 times)

gwinterhalter

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 15
    • View Profile
Tree grid as filter for Grid
« on: March 07, 2020, 04:06:00 am »
Hi Support

Needed is the capability to use a popup with a multilevel checkboxed treegrid as a filter for records in another list. The grid would have columns a,b,c,d. and the tree grid would have multiple levels like
A
   B
      C

Appreciate a sample for this. we have been stuck on this for a week.

Thanks Greg

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6210
    • View Profile
Re: Tree grid as filter for Grid
« Reply #1 on: March 09, 2020, 09:48:14 am »
Not sure how you want to use treegrid to filter records in another grid.

Please share more details of your requirement and a jsfiddle / plnkr of your attempt so far and what problem are you facing?

EPM Solutions

  • Pro Ultimate
  • Full Member
  • *
  • Posts: 182
    • View Profile
Re: Tree grid as filter for Grid
« Reply #2 on: March 11, 2020, 10:52:44 pm »
Hi Support,

Requirement:
We have three column/dataindx in grid ex. Country, State, City in grouping and other.

we need to create a mutiselect filter in which data of Country, State and City as tree structure (or grouping) with collapsible feature (similar as below URL).

When we select a Country or State or City, we need to filter/exclude the data by the City column/dataIndx of grid for selected cities.

How can we create such multi-select tree filter similar(in data) to grid given in below URL using pq Select library of paramquery?

Please provide snippet for it.

tree grid URL: https://paramquery.com/pro/demos/treegrid5
« Last Edit: March 11, 2020, 11:18:43 pm by EPM Solutions »

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6210
    • View Profile
Re: Tree grid as filter for Grid
« Reply #3 on: March 12, 2020, 12:17:43 am »
Attachment is missing in your post.
« Last Edit: March 12, 2020, 06:24:43 am by paramvir »

EPM Solutions

  • Pro Ultimate
  • Full Member
  • *
  • Posts: 182
    • View Profile
Re: Tree grid as filter for Grid
« Reply #4 on: March 12, 2020, 09:59:44 am »
Hi Support,

I have added the missing attachment.

Actualy, We need a filter like in below URL with similar feature, Is it possible to implement it with paramquery pqselect library ?

If yes Please share a snippet asap.


URL:https://jsfiddle.net/yasu47b/fakg72yk/

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6210
    • View Profile
Re: Tree grid as filter for Grid
« Reply #5 on: March 12, 2020, 10:10:40 am »
I don't see any filtering in the jsfiddle shared by you, when a node/ nodes are selected they simply appear on top. Is there any filtering context between the attachment and jsfiddle?

If you mean to group the options in the header filter dropdown ( when filter condition is 'range' ), an example is already present in demos section:

Please check filter dropdown in "Shipping Region" column in this example https://paramquery.com/pro/demos/filter_header_local
« Last Edit: March 12, 2020, 12:13:50 pm by paramvir »