Populating Search

[hxa27]

Hi,

I am trying to populate a search in dropdown option. I tried a couple things but I do not know why it is not working. my XML code looks like that:

<fieldset autoRun="true" submitButton="true">
     <input type="dropdown" token="name" searchWhenChanged="true">
        <label>Select a Catergory:</label>
         <!-- Define the choices with a populating search -->
         <populatingSearch fieldForValue="name" fieldForLabel="name">
            |dbquery My_Database_Name  "select distinct Name from Table1_Name e INNER JOIN Database_name..Table2_name r on My_ReportID1=My_ReportID2 where Name='My_condition '"
         </populatingSearch>
     </input>
     </fieldset>

I used the same populating search in a different query and it was work just fine. I don't know why this is not working..

Thanks in advance

[martin_mueller · Accepted solution]

Make sure you're not mixing name with Name when looking for the field/column.