Mysql .count query not showing BUG?

[JBM]

The below mysql query works is as it should when showing in the query builder.

However when trying to set the value of a textinput using the data binder I get this:

The value ‘total_users’ as defined in the query located in the api does not always show in the data binder and the list above is often displayed.

When ‘total_users’ does show up after restarting wappler several times, I wont select by as clicking
it does not work.
I have manually created the bound data in the code view with
’sc_count_records.data.qry_count_users.total_users’
but that doesn’t work either.

As a side note I find the data binder regularly displays incorrect or incomplete data. It often displays the word ‘file’ and not the correct data.

[George]

This has already been reported and will be solved in the next update:

Database Alias does not appear in AC UI

Wappler Version : 7.3.6 Operating System : W11 Server Model: NodeJS Database Type: MariaDB Hosting Type: Own Server Expected behavior I have this query: [image] I would expect the Alias to be shown in the AC UI. Actual behavior No Alias by the name of active_licensees [image] Workaround Handcode: dmx-text="dashboard_data.data.activeLicensees[0].active_licensees||0" Edit: For context, the data originates from a database view that consolidates records from multiple tables.

[JBM]

Thanks George, However, I did find that replacing all (*) with id in the select worked:

[Teodor]

Fixed in Wappler 7.3.7