Open VictorioBerra opened 4 months ago
Hi - sorry I haven't been able to reply and look into your various issues and fixes yet. I'm working on other aspects of DataTables that I want to figure out before context switching to this. I will do so before the next release of Editor though.
@AllanJard no problem, I have created PRs for almost every issue I created now 🎉 hopefully this helps.
Modify the sample to the following code
This works on SQLite not SqlServer/MSSQL.
With SqlServer, you will get "Column '[sites].[name]' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."
Finally, "fixing" this is:
Not sure if that is the appropriate fix though...