Select distinct values / deduplicate

[jdgamble555 (Jonathan Gamble)]

It looks like groupBy sort of does this, but it is not available in graphQL and only DQL. This basically means you need to do a @custom dql query. The problem is that you can’t use @auth on a custom query, so that only leaves putting a custom DQL within a custom mutation @lambda.

https://dgraph.io/docs/query-language/groupby/#

SELECT DISTINCT in Dgraph

Deja vu, I find myself back here again. @dmai, has any of these ideas been explored? UPDATE(for myself next time searching for this): too much to remember sometimes… Here is the syntax query for the above data: { distinctCountries(func: has(Country)) @groupby(Country) { # no need to select any fields, Country will be selected in the group by results # if you want to count the duplicates, use: count(uid) } } This syntax would return the following results: { "data": { "di…

Hopefully this is a new feature request they plan on adding.

J