Need to build a complex query for Azure Table to count number of rows

Question

I am trying to run complex query for Azure Table where I want to count number of rows for all deviceID for specific dateiot and timeiot? Is this possible?

Answer 1

Your query would be something like:

PartitionKey eq 'aaaa' and dateiot eq 'bbbb' and deviceID eq 'cccc' and timeiot eq 'dddd'

2 things though:

1. This query will do a complete partition scan and may result in incomplete data in a single request. Your code should be able to handle continuation tokens to get all data matching the query.
2. Table query does not support count functionality so you will get the entities back. You will need to add all entities to get the total count of entities matching the query.