topic Re: Dropdown not populating in Dashboards & Visualizations

Dropdown not populating

shaoli21 — Wed, 30 Sep 2020 04:08:09 GMT

| djquery -database ad -query "select short_description from bu_projectdetails order by [order]"

this is the given query........when I am replacing this with lookup files, although result is coming in the search but not in the dropdown.

| inputlookup bu_projectdetails_lookup.csv |table short_description|sort by [order]

Re: Dropdown not populating

nickhills — Fri, 07 Feb 2020 13:51:43 GMT

Have you set

<fieldForLabel>short_description</fieldForLabel>
<fieldForValue>short_description</fieldForValue>

In the dropdown settings?

Re: Dropdown not populating

somesoni2 — Fri, 07 Feb 2020 15:09:30 GMT

Try this for you search.

| inputlookup bu_projectdetails_lookup.csv |table short_description|sort short_description

Re: Dropdown not populating

nickhills — Fri, 07 Feb 2020 15:14:55 GMT

oh yeah, missed that 🙂

Re: Dropdown not populating

shaoli21 — Mon, 10 Feb 2020 07:28:23 GMT

its showing the same thing, "could not create search"

Re: Dropdown not populating

shaoli21 — Mon, 10 Feb 2020 07:30:30 GMT

yes I had set them but still no output

Re: Dropdown not populating

vnravikumar — Mon, 10 Feb 2020 09:35:54 GMT

if possible can you post your xml?

Re: Dropdown not populating

shaoli21 — Mon, 10 Feb 2020 09:44:32 GMT

    <label>Milestones</label>
    <choice value="*">All</choice>
    <search>
      <query>| djquery -database ad -query "select short_description from bu_projectdetails order by [order]"</query>
    </search>
    <fieldForLabel>short_description</fieldForLabel>
    <fieldForValue>short_description</fieldForValue>
    <default>*</default>
    <valuePrefix>short_description="</valuePrefix>
    <valueSuffix>"</valueSuffix>
    <delimiter> OR </delimiter>
  </input>

Re: Dropdown not populating

493669 — Mon, 10 Feb 2020 10:08:52 GMT

@shaoli21, did you tried below-

<label>Milestones</label>
     <choice value="*">All</choice>
     <search>
       <query>| inputlookup bu_projectdetails_lookup.csv |table short_description|sort short_description</query>
     </search>
     <fieldForLabel>short_description</fieldForLabel>
     <fieldForValue>short_description</fieldForValue>
     <default>*</default>
     <valuePrefix>short_description="</valuePrefix>
     <valueSuffix>"</valueSuffix>
     <delimiter> OR </delimiter>
   </input>