Querying distinct values in Ballerina Query Expressions

Is it possible to query DISTINCT values using Ballerina Query Expressions?

string[]|error connectorProducts = from record {string product;} {product} in products
        select product;

connectorProducts should only have DISTINCT values at the end.

Thanks.

>Solution :

This can be achieved by incorporating a group by clause.

from record {string product;} {product} in products
      group by product
      select product;

Also see

• https://ballerina.io/learn/by-example/aggregation
• https://ballerina.io/learn/work-with-data-using-queries-in-ballerina/#group-the-deaths-by-the-continent
• How to create a set in Ballerina?

Note that there’s an open spec issue to look into the possibility of adding an array:unique function as a straightforward alternative for when we just want to filter out unique members from an array.