In the aggregate, make it possible to add an advace query in an auxiliary column (on new attribute)
139
Views
4
Comments
New
Database

Give the possibility of adding sql, such as a sub query for a counter, or a 'STUFF FOR XML' for concatenating values


2024-07-03_17h18_57.png

This is a really good idea! I had to use Advanced SQL three times along this year just for use the STUFF. Something like that would allow uncountable possibilities.

Yup. Also like simple subqueries to make Counters

Nice idea actually

Basically it is proposed to have sub query in aggregate.

This will solve lot of issues and help cut down usage of advance sql

Also it will be very simple than advance sql query writting