Use IronPython to get checked items in a CheckboxHierarchyFilter

[Matthew Henrich]

I am attempting to write an IronPython script that will look at all nodes of a CheckboxHierarchyFilter and return only the values that are currently checked.

This question was similarly asked here:https://community.spotfire.com/questions/iterate-through-items-checkboxhierarchy-filterand that is how I got the base level (*.Heirarchy.Level[0]), but I cannot get the 2nd - 4th levels to be read correctly. When I try to follow the instructions on that page/question, I keep getting a "Looking for Array(DistinctDataValue), but got bool." error.

Can someone enlighten me on how to do thisIsChecked(List) doesn't seem to be the right answer.

[Gaia Paolini]

could you show a sample of your hierarchy

[Matthew Henrich]

The hierarchy was created in the Spotfire Tool - what example are you looking for

[Gaia Paolini]

I meant what the data looks like, I was guessing the issue might be related to what your actual hierarchy is

[Matthew Henrich]

There are three heirarchies that this code needs to work for

 

Business -> Organization -> Sub-Business

Business -> Region -> Country

Business -> Custom Region -> Country

 

 

[Matthew Henrich]

Gaia - can you give an example of how  IsChecked(List<DistinctDataValue>) is supposed to work

[Matthew Henrich]

 * This is not meant to be an answer.

 

 

[Andrew Berridge]

Hi Matt,

I'm taking a look at this now. It is possible to do what you want, but that referenced script isn't the right way to do it.

I'll update with another answer later on.

Andrew Berridge (TIBCO Data Science)

[Andrew Berridge]

Also posted here:

 

https://community.spotfire.com/wiki/hierarchical-checkbox-filters-which-values-are-checked

[Matthew Henrich]

Any update on this?

[Matthew Henrich]

6 months and no update - nice work

[Andrew Berridge]

Hi Matthew -

I did write and post an article on this topic at the time, but it looks like my comment pointing you to that script was missed somehow. Let me share the link to the script with you:

https://community.spotfire.com/s/article/Hierarchical-Checkbox-filters-which-values-are-checked

Do let us know if it solves your issue!

We appreciate your feedback,

Andrew

[Matthew Henrich]

It doesn't solve my issue, and your comment after the initial posting of that link says the same. How do I utilize the Check(List<DistinctDataValue>) function to actually work with a list?

[Andrew Berridge]

Hi Matthew,

OK - here is how you can tell if an item is checked:

import Systemfrom System import Arrayfrom Spotfire.Dxp.Data import DistinctDataValueimport Spotfire.Dxp.Application.Filters as filtersfrom System.Collections.Generic import List myPanel = Document.ActivePageReference.FilterPanelmyFilter = myPanel.TableGroups[0].GetFilter("New hierarchy")chFilter = myFilter.FilterReference.As[filters.CheckBoxHierarchyFilter]() l = List[DistinctDataValue]() l.Add(DistinctDataValue("California"))l.Add(DistinctDataValue("conventional"))print(chFilter.IsChecked(l))

The values "California" and "conventional" are the values in levels 1 and 2 in the hierarchy I'm using.

The original example I posted is more generic - in that it recursively navigates the entire hierarchy.

Hopefully you can translate that to your needs. Let us know how you get on!

Andrew

[Andrew Berridge]

Last reply updated 26-Aug - using IsChecked method rather than Check method.