dropdown populated search

[hxa27]

Hi,

I am trying to populate my dropdown from my search but I am not sure about my syntax or something else is missing. My code looks like :

form>
UCM monitoring
|| dbquery UCM "select * from DimCategory where Name="" "

Select a Catergory:
<!-- Define the choices with a populating search -->

<![CDATA[index=_internal|stats count by Name]]>
<choice value="">Any

The query is run against a database. So, I am not indexing any data. any help is appreciated.

[hxa27 · Accepted solution]

UCM monitoring |dbquery UCM "select name from DimCategory where name like '%'"

Select a Catergory: * All |dbquery UCM "select name from DimCategory where name like '%'"

This code does what I want. Yeeeeeees