Dynamic Dropdowns suddenly returning "undefined"

[lwoolsey]

I have a dynamic dropdown the gets it’s values from a dataview. It had been working without error, suddenly I am getting “undefined” as the displayed result.

View:

<dmx-data-view id="year_view" dmx-bind:data="rpt_list.data.allsubmittal.groupBy(`exp_yr`)" sortdir="desc"></dmx-data-view>

Drop down control:

<div class="col-sm-2">
    <select id="selectYear" class="form-control form-control-sm" dmx-bind:options="year_view.data" optiontext="$value[0].exp_yr" optionvalue="$value[0].exp_yr">
    </select>
</div>

[lwoolsey]

[ben]

The code for my select menu looks as per:

Note the optiontext and optionvalue.

This may help

Dynamic Select Menu

[Teodor]

@lwoolsey

optiontext="$value[0].exp_yr" optionvalue="$value[0].exp_yr"

These seem wrong. They need to be exp_yr only, without the $value[0]. part. Seems you picked some wrong expressions.

[lwoolsey]

This has been functioning correctly for quite a while, in fact it still works on my primary production computer (I’m guessing there is something that remains in the cache of that machines browser that is not present when view in an incognito window or on a machine that has not accesses this particular page before.)

Here is what I selected from the data picker:

Selecting the source:

Then selecting the text field and value field (they are the same in this instance:

[lwoolsey]

Here is the results on the “cached” computer

Which is what I expect from the dataview grouped on exp_yr

I had not edited or changed the page, but I have run the updates to the site after each Wappler version updates

[Teodor]

Ah sorry, i missed you are using the group by filter there. Let me check that.

[patrick]

Please check this update: dmxAppConnect.zip (26.3 KB)

[lwoolsey]

Thank you. That resolved the issue.

[Jaymer]

so I don’t have to unzip and read code, what was the solution? was there a bug in wappler code that was fixed in that zip file? do we all need to grab that zip?

[Teodor]

You don’t need to read the code. This is the fixed js file, which you need to place in your dmxAppConnect folder.
It will be included in the next update.

[Teodor]

This has been fixed in Wappler 4.9.0

[antionline]

our dropdowns are not binding data from server connect…
could you please check? there is still a bug.

[antionline]

Double checked, With before updated dmxAppConnect.js version is working. with updated our drop downs are dead.

Below Dropdown code.
Binded to "custom database query

`<select name="file" required="" class="form-control custom-select" id="file" dmx-bind:options="SupportedDataFiles.data.GetSupportedDataFilesCustom" optiontext="'FileID-'+FileID+' '" optionvalue="FileID" readonly="true" rel="">

Select File `