Create this Query in Wappler

Wappler General How To
#81

The original query, with the subquery? Or did you you:

use the response of first query as param in second

? This didn’t seem to be possible as the values function was not working, but Patrick suggested an alternative which mean it was possible - and provided a solution. I think it was this that didn’t work in IIS.

So just the groupby function was fixed (not values)?

#82

Just the groupBy(“id”).keys() function, which was already working for PHP was fixed for .NET.
Values still doesn’t work for either platforms - last I checked.

1 Like
#83

Thanks

#84

Custom SQL Queries are not supported in Wappler 2.1.0

#85
#86
#87