If I have a column that is a JSON definition of an object, can I query on a specific item in that object? Ie, if I have a column named "Profile" that is represented by `{"FirstName": "John", "LastName": "Doe"}` is it possible to search for all profiles that have the LastName of "Doe"?
Read through that before I posted here, nothing specifically mentions querying an object/dictionary type. I've tried a variety of permutations with no success:
I realize some of these don't even make sense but that's where I'm at right now - tried everything that seemed rational with no luck. Hopefully this clarifies what I'm trying to do and why I'm having issues.
M
Mike
said
over 6 years ago
With objects in a field, you need to use dot notation to access it. In this case, The first name sub-field is `Profile.FirstName`, and last name would be `Profile.LastName`. You can then use exactMatchForValue `Doe` on that key path.
tupakapoor