As of April 12th, you must go to Progress SupportLink to create new support cases or to access existing cases. Please, bookmark the SupportLink URL and use the new portal to contact the support team.
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
about 9 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