Creating cascading select lists in insight

Linda Milne_Togetha Group_

Is it possible to create what is essentially a cascading select list with Insight objects? The Atlassian docs (https://confluence.atlassian.com/jirakb/how-to-configure-insight-custom-fields-as-cascading-select-list-1097172127.html) seem to indicate this is possible, but there is no solution given.

Any ideas on how to limit the selection of an object in an attribute field, based on another object attribute value?

e.g. similar to the example in the Atlassian docs, I have an object type that has a book and author attribute field, both of which are also insight object types. If I choose an author object attribute value the list of book objects I can choose for the book attribute should be limited to a subset of all book objects, for example:

author 1 -> [book A, book B]

author 2 -> [book C, book D, book E]

Any ideas?

Jorden Van Bogaert

Hi @Linda Milne_Togetha Group_ 

Let's assume the following setup:

Author (object Type)
 - Name (text attribute)

Book (object type)
 - Name (text attribute)
 - Author (object picker attribute referring to object type Author)

Other (Object Type)
 - Name (text attribute)
 - Author (object picker attribute referring to object type Author)
 - Book (object picker attribute referring to object type Book)

In the "Other" object type, you can configure the "Book" attribute with "Filter Objects". If you add below IQL in the box, your "Book" select will only show options for Books with the Author equal to the currently selected one.

"Author" IN ${Author}

I hope this is a little clear

Kind regards
Jorden