Cosmos DB Cheatsheet

Query list length

SELECT * FROM c WHERE ARRAY_LENGTH(c.myList) > 0

Finn duplikater

Der A og B er noe som definerer duplikatet, og Discrimantor er noe som skiller dem fra hverandre

SELECT d.A, d.B From 
   (SELECT c.A, c.B, count(c._ts) as counts FROM c
    GROUP BY c.Discriminator, c.EndDateTime) AS d
WHERE d.counts > 1

Et mer konkret eksempel

SELECT d.email, d.counts 
FROM (
    SELECT c.entity.email as email, count(c._ts) counts
    FROM c
    WHERE c.entityType='UserInfo'
    GROUP BY c.entity.email
) as d
WHERE d.counts > 1