Database Alias does not appear in AC UI

[ben]

Wappler Version : 7.3.6
Operating System : W11
Server Model: NodeJS
Database Type: MariaDB
Hosting Type: Own Server

Expected behavior

I have this query:

I would expect the Alias to be shown in the AC UI.

Actual behavior

No Alias by the name of active_licensees

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.

[guptast]

Hi Ben,

Try after selecting the query fields individually instead of selecting all (select * from ...).

[Hyperbytes]

I think "count" needs to act on a field, not a full data set.

Try removing the alias and aggregate statements from the initial query and adding it as a second entity. Something like this:

Alternatively use the length formatter in App Connect applied to the returned record set to count the total records in the record set.

[George]

Are you sure the server connect file with the query is saved first so new output data is generated, because i see the full table as output probably before you added count?

[ben]

Once again, thank you all for your replies. A wise man once said, never too old to learn.

@George, yes, I tried nearly everything except the correct solution.

[Teodor]

Fixed in Wappler 7.3.7