Json.Net SelectToken Query not working

Question

I have a JSON object like this

"office": {
    "parkingRatio": 12.0,
    "hasGenerators": true,
    "generators": [
      {
        "_id": "ff2dc672-6e15-4aa2-afb0-18f4f69596ad",
        "office_id": "b62ce2c1-5fa2-4eee-9ce8-e04a2c3e6513",
        "make": "Broom Broom",
        "covered": true,
        "output": 1234.0
      }
    ]
}

I have a query like this:

$.office.generators[?(@._id =='ff2dc672-6e15-4aa2-afb0-18f4f69596ad')]
$.office.generators[?(@.office_id == 'b62ce2c1-5fa2-4eee-9ce8-e04a2c3e6513')]

If I run this on a few online tools like HERE:

it works fine and gives me the whole array item, but if I run it in json.net v7 it returns nothing.

So i tried the following thinking it might be string

$.office.generators[?(@.covered == true)]

And it works in online tool and json.net. So i tried the following thinking it might be the hyphens

$.office.generators[?(@.make == 'Broom Broom')]

And again it works fine in both. What is wrong with my first query?

Thanks

Pintac · Accepted Answer · 2015-09-03 14:48:26Z

3

Found the problem. The json _id field gets converted into a JValue of type Guid but the expression JValue gets converted into String so when "BooleanQueryExpression" does this comparison

if (v != null && v.Equals(Value))

then its not equal.

I submitted a issue on github

answered Sep 3, 2015 at 14:48

Pintac

1,5853 gold badges22 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Json.Net SelectToken Query not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related