Creating a drop-down within Kinetic dashboard

[mto29 (Mic)]

Hi all,

I’d appreciate any help or pointers on this please

I’m trying to create a dropdown box in App Studio that allows users to filter a query based on Product Group (we have six groups in total). Initially, I was hoping this could be achieved with a simple tickbox or a standard filter option, but it seems like more customization might be needed…possibly stepping into the world of events?!

Previously we managed this using the Advanced Column Editor in the classic BAQ version, but I can’t see that option available in Kinetic anymore.

This is all essentially a workaround because dragging the Product Group column into the group by area causes the dashboard to crash. So I’m exploring alternative ways to let users filter by Product Group.

As a last resort, I’m considering creating separate BAQs for each Product Group and managing the filter within BAQ Designer, but I’d prefer a more dynamic solution if possible.

Thanks in advance!

[dcamlin (David Camlin)]

This sounds like you want View options on your grid.

In the Advanced properties of the grid (towards the bottom) you should see “View Options”. You can create as many Views as you’d like… one for each of your product groups. You would set each of them up against the same BAQ and filter the BAQ results in the View’s BAQ options.

[mzahn (Mike Zahn)]

I have used dropdowns to filter/limite the dataset. In this example, I populated the dropdown with a BAQ:

And the value is passed as a parameter in the kinetic BAQ action tied to a search button that populates the grid.

If your data source is not a BAQ with parameters, you could pass the value from the downdown (TranView.Whateveryounameit) through a where clause in BAQ options: