AC2 Bug #9 - Large .where() on a Data Store not Working in dmx-bind:options of Select

Wappler Version : 5.8.2 Beta - dmxAppConnect.js 2023-06-20 1117
Operating System : Windows
Server Model: PHP
Database Type: MySQL
Hosting Type: WAMP

Expected behavior

What do you think should happen?

The Following Select statement should show some options in the beta channel as it does in the stable channel:

<select id="i_attendee_price" class="custom-select input_select" name="entry_price" dmx-bind:options="prices_to_show.data.where(&quot;price_for&quot;, &quot;a&quot;, &quot;==&quot;).where(&quot;show_price&quot;, 1, &quot;==&quot;).where(&quot;attendee_number&quot;, this_attendee_number.value, &quot;==&quot;).sort('sort_number')" dmx-bind:value="attendees.data.where(&quot;$id&quot;, this_attendee_number.value, &quot;==&quot;)[0].price" optiontext="title + ' - ' + currency_symbol.value + price_amount" optionvalue="id" dmx-on:updated="

                    show_booking_details==1?price_changed.load({question: 0, attendee_number: this_attendee_number.value, price: i_attendee_price.value, activity: get_activity.data.activity.id, booking: booking.value, contact: attendees.data.where(`$id`, this_attendee_number.value, '==')[0].contact, booking_item: attendees.data.where(`$id`, $id, '==')[0].booking_item, quantity: i_ticket_quantity.value}):false;

                    attendees.update({$id: this_attendee_number.value}, {price: i_attendee_price.value.toNumber(), responses_okay: 0, quantity:i_ticket_quantity.value});

                    responses.update({attendee_number_question: this_attendee_number.value+'_entry_price'},{has_responded: i_attendee_price.value>0?1:0, response: i_attendee_price.value.toNumber(), response_type_response: 'entry_price_'+i_attendee_price.value});

                    flow_set_instalments_price.run({price:i_attendee_price.value, attendee_number: this_attendee_number.value });

                    show_payment_details.setValue(0)
                    " dmx-class:input_required="(entry_price_has_responded.value==0) && (show_response_errors==1)" dmx-show="prices_to_show.data.where(&quot;price_for&quot;, &quot;a&quot;, &quot;==&quot;).where(&quot;show_price&quot;, 1, &quot;==&quot;).where(&quot;attendee_number&quot;, this_attendee_number.value, &quot;==&quot;).count() > 0">
                      <!-- prices_to_show.update({id: i_attendee_price.value},{number_available: prices_to_show.data.where(`id`, i_attendee_price.value, &quot;==&quot;)[0].number_available - 1}) -->
                      <option value="0" selected=""></option>
                    </select>

Where prices_to_show is a datastore:

Actual behavior

What actually happens?

No options are shown on the select input.

@patrick, you can see a live, working 3.9.7 version of this page at:

Enter any email address and it is the Accommodation question…

Not fixed in dmxAppConnect.js (2023-06-23 0942)…

Here an update: dmxAppConnect.zip (28.2 KB)

Fixed! :rocket:

fixed in the extensions beta channel as inline update