none
Limit to the number of values I can specify in a query RRS feed

  • Question

  • Hi,

    I want to select a certain number of rows from a table in my Azure Table Storage by specifying the PartitionKey and RowKey. Say, I have a list of 500 PartitionKey and RowKey pairs that I need to read from my table. Can I specify these 500 values in my query?

    I have a feeling that I'll have to come up with a composite key as my partition key so that I don't have to specify so many PartitionKey/RowKey values but I want to first make sure that there's a limit to the number of values I can specify in a query.


    Thanks, Sam

    Friday, March 13, 2015 8:45 PM

Answers

  • Hi,

    Not more than 15 discrete comparisons are permitted within a $filter string.

    Regards,

    Manu Rekhar

    • Marked as answer by imsam67 Monday, March 16, 2015 5:36 PM
    Monday, March 16, 2015 5:12 PM
    Moderator

All replies

  • Hi,

    Thank you for reaching out to us.I am currently researching to gather more information with regards to your request. I shall revert back to you with an update at the earliest.Sincerely appreciate your patience.

    Regards,
    Prasant
    Saturday, March 14, 2015 8:00 AM
    Moderator
  • Hi,

    Not more than 15 discrete comparisons are permitted within a $filter string.

    Regards,

    Manu Rekhar

    • Marked as answer by imsam67 Monday, March 16, 2015 5:36 PM
    Monday, March 16, 2015 5:12 PM
    Moderator
  • Thank you!

    Thanks, Sam

    Monday, March 16, 2015 5:36 PM