Browsing Tag
Queries
3 posts
DQL in function: filter on a list, an array or a subquery
DQL in function and in operator: filter on a list, an array or a subquery, exclude values, with operations use cases and the traps to avoid in Grail.
DQL group by: grouping with summarize and by:{}, the SQL GROUP BY equivalent
DQL group by with summarize and by:{}: translate a SQL GROUP BY, name columns, handle the null group, several keys, bin() ranges and the HAVING step.
Advanced DQL: lookup, join, parse and window functions
Advanced DQL: enrich records with lookup, correlate with join, structure logs with parse and smooth time series with the moving functions in Grail.