locked
NodeJS Table Storage where clause prefix with numeric string value RRS feed

  • Question

  • I am looking to make a TableQuery that returns results where a string property starts with a number. I have attempted to use the same prefix method described on the MSDN but I cannot get any results returned when the characters are numeric.

    Here is an example of what I'm trying to do:
        titleQuery = new azure.TableQuery()
        .and 'title ge ?', '1'
        .and 'title lt ?', '2'

    Sample title values are "1-something", "something", and "123-something"

    Looking at the comments in source, I can see that the query API has been updated, but don't see any examples of doing queries based on prefix.

    Any thoughts on how or if this is possible?


    David Wesst | MVP http://davidwesst.com | @davidwesst


    Wednesday, November 5, 2014 12:51 AM

Answers

All replies

  • Hi David,

    I'm trying to collect more information from some senior engineers regarding this issue and it might take some time. Your patience is greatly appreciated.

    Regards,

    Manu Rekhar

    Wednesday, November 5, 2014 7:41 AM
  • Great! Thank you for the quick response. I'll look forward to hearing from you.

    ~ DW


    David Wesst | User Experience Consultant | MVP http://davidwesst.com | @davidwesst

    Wednesday, November 5, 2014 7:14 PM
  • Any update on this?

    David Wesst | http://davidwesst.com | @davidwesst

    Tuesday, November 11, 2014 5:25 AM
  • Received a reply on the GitHub issues site, where I asked the same question.

    It appears the issue was a simple oversight by me where I used two '.and' operators instead of a '.where' and an '.and'.

    https://github.com/Azure/azure-storage-node/issues/30#issuecomment-61926225

    Thanks!


    David Wesst | http://davidwesst.com | @davidwesst

    • Marked as answer by David WesstMVP Tuesday, November 11, 2014 7:31 AM
    Tuesday, November 11, 2014 7:31 AM