SQL generated by Radsystem does not work

Questions
1

I created a sql with Radsystem; preview works if applied to the Record Count does not work.

Immagine140
Immagine1401239×422 65.7 KB

Immagine141
Immagine142
Immagine142817×431 59.3 KB

2

@Maxr167 if your project is a classic project, please share this file {project root}\app\Models\ComponentsData.php or its content.

3

@Maxr167 if the error you are getting is this

Query Builder Error
Query Builder Error1433×999 73.3 KB

then change your query COUNT() AS count_of_cliente_id to COUNT() AS num.

Whenever you use the Edit With Query Designer on a Record Count component, you need to modify the FieldAlias to num.

4

hello Willvin , even with this setting it doesn’t work …

PHPRad Vue

Immagine161
Immagine161876×258 38.8 KB

5

What error are you getting?

Please use the query parameters bindings for your dynamic query to avoid sql injections

Thanks.

6

Send me a private message containing your Anydesk ID.

7

Hi Willvin, your information is correct (as always) … problem solved … thanks for your support