Custom interactive filter drop down list.

[Bryan Tay3]

hi there, 

noticed that there is a OOTB dynamic content "Skill Category" (sys_id 220cc440b3672300290ea943c6a8dc46) that utilise "HomepagePublisherHandler" to render a drop down box via table api.

I'm trying to look for any reference doc on how to use this class to render a drop down box.

my ultimate goal is to create a custom interactive filter that has 2 drop down which behave something similar to "cascading drop down".

Unfortunately I could not use Cascading drop down be cause it only support "AND" condition.

happy to hear if there are other better implementation example other than "HomepagePublisherHandler" / Cascading Interactive filter.

[Adam Stout]

Take a look at the CreatorCon lab from K19 on Custom Interactive Filters.  There are also a few Performance Analytics Office Hours I suggest reviewing:

Creating Custom Interactive Filters: https://community.servicenow.com/community?id=community_blog&sys_id=aaedd2b7db5480d45129a851ca961988

Testing Custom Interactive Filters: https://community.servicenow.com/community?id=community_blog&sys_id=9130c1bcdb7518d0414eeeb5ca961955

[Bryan Tay3]

hi Adam, 

thanks for your quick response.

Basically I gone through the working example from the creatorcon18 for custom visualisation and custom interactive filter which i can leverage on.

I'm trying to look for working example on:

1. Create 2 drop down, options from drop down comes from a list of cmdb_ci_service.owned_by (about 17k rows).

2. Once owned_by selected, drop down 2 will be filtered based on selected drop down 1. I believed this can be achieve by having some ajax call script.

3. Once second drop down is selected, i will then published the constructed filters using 

DashboardMessageHandler.

I could not find any good working example for rendering my first drop down which 

1. Pull down only distinct option from a table column (17k+)...

2. Not pulling down everything in one go but rather first 100 records etc. then when user scroll down it will pull more subsequently.

any idea?

Thanks in advance.

[Bryan Tay3]

The closet working example i found were the OOTB "Skill Category" dynamic content.

Apparently it uses "HomepagePublisherHandler" which I could not find any reference doc anywhere...

[Adam Stout]

The K19 lab is much better (I wrote them both).  In the newer version, we have custom visualizations that listen to breakdown and filter changes and responds to them.  You can see a working example which you'll have to piece together to get what you are looking for.