Dan Benitah

New query COUNT functionality for Azure Digital Twins

A quick one in case people did not notice it is now possible to use COUNT in queries to the Digital Twins v2.

Very basic, but makes a big difference in practice.

SELECT COUNT() FROM DIGITALTWINS

returned ...

{
  "COUNT": 547
}

Should help with a lot of basic scenarios for showing totals on dashboards, notifications badges, or simply paging...

Anyway, more on queries at https://docs.microsoft.com/en-us/azure/digital-twins/how-to-query-graph#count-items


Dan Benitah

Written by Dan Benitah, London, UK.