James Newton-King

My feedback

  1. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Azure Cosmos DB » MongoDB API  ·  Flag idea as inappropriate…  ·  Admin →
    James Newton-King commented  · 

    Just for more info about why this would be useful, right now the DocumentDB client allows you to enter a dynamic SQL string and then gives you an IQueryable. However there is no way to add a dynamic query once you have the IQueryable.

    Example from the MongoDB documentation of how Inject works:

    Inject is a pseudo-method that is used to inject a lower level MongoDB query into a LINQ query.

    The following query looks for X values that are larger than 0 and are 64-bit integers.

    var query =
    from c in collection.AsQueryable<C>()
    where c.X > 0 && Query.Type("X", BsonType.Int64).Inject()
    select c;

    // or
    var query =
    collection.AsQueryable<C>()
    .Where(c => c.X > 0 && Query.Type("X", BsonType.Int64).Inject());

    This is translated to the following MongoDB query:

    { X : { $gt : 0, $type : 18 } }

    James Newton-King shared this idea  · 
  2. 790 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    31 comments  ·  Azure Cosmos DB » SQL API  ·  Flag idea as inappropriate…  ·  Admin →
    James Newton-King supported this idea  · 
    James Newton-King commented  · 

    Case insensitive comparison with LIKE should also be possible.

  3. 880 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Azure Cosmos DB » SQL API  ·  Flag idea as inappropriate…  ·  Admin →

    There are multiple responses to this suggestion.

    Support for SQL-like syntax for UPDATE, DELETE and INSERT INTO are not on our road map at this time.

    However, the underlying functionality for an UPDATE, SET is essentially a PATCH. This functionality we are actively working on. See this User Voice item here to track for future updates. https://feedback.azure.com/forums/263030-azure-cosmos-db/suggestions/6693091-be-able-to-do-partial-updates-on-document

    Thank you for your suggestion.

    James Newton-King shared this idea  · 
  4. 45 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    8 comments  ·  Cloud Services (Web and Worker Role)  ·  Flag idea as inappropriate…  ·  Admin →
    James Newton-King commented  · 

    I don't see what DR has to do with this and you haven't described what backup would do so how can I say?

    I'll give you a scenario:

    I have a happily running production deployment. After testing first in staging I move a new deployment into production and delete the old one.
    A week later an urgent bug is found in the new deployment. I want a simple and quick way to roll back to the old version. A simple way to do this would be if Azure kept a history of past deployments and the packages. Then I could simply go back into the online management portal and roll back to an old version as simply as I can currently switch production/staging instances.

    James Newton-King shared this idea  · 

Feedback and Knowledge Base