locked
Table query cannot use double value? RRS feed

  • Question

  • Hi.

    I use azure storage table, and get entities by query.

    But, the following query occurs error.

      {Property name} gt 1498466759066

    I also tried the following query.

      {Property name} gt 2147483647  → success

      {Property name} gt 2147483648  →  fail

    I want to use double value, so please help me!

    Tuesday, June 27, 2017 9:36 AM

Answers

  • You may try to test with this: {Property name} gt 2147483648d

     

    The d suffix is OData notation for a Edm.Double literal. Azure Storage tables support a subset of the OData data types as is documented here.

    https://docs.microsoft.com/en-us/rest/api/storageservices/understanding-the-table-service-data-model#property-types.

    The OData literal specification information is present in section 6 titled Primitive data types.

    http://www.odata.org/documentation/odata-version-2-0/overview/ .

    Do click on "Mark as Answer" on the post that helps you, this can be beneficial to other community members.

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    • Proposed as answer by Swikruti Bose Tuesday, June 27, 2017 3:40 PM
    • Marked as answer by aktaka Thursday, June 29, 2017 11:01 PM
    Tuesday, June 27, 2017 3:40 PM

All replies

  • You may try to test with this: {Property name} gt 2147483648d

     

    The d suffix is OData notation for a Edm.Double literal. Azure Storage tables support a subset of the OData data types as is documented here.

    https://docs.microsoft.com/en-us/rest/api/storageservices/understanding-the-table-service-data-model#property-types.

    The OData literal specification information is present in section 6 titled Primitive data types.

    http://www.odata.org/documentation/odata-version-2-0/overview/ .

    Do click on "Mark as Answer" on the post that helps you, this can be beneficial to other community members.

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    • Proposed as answer by Swikruti Bose Tuesday, June 27, 2017 3:40 PM
    • Marked as answer by aktaka Thursday, June 29, 2017 11:01 PM
    Tuesday, June 27, 2017 3:40 PM
  • I could use double value for query.

    Thank you!!!

    Thursday, June 29, 2017 11:03 PM
  • You are welcome.
    Saturday, July 1, 2017 8:55 AM