We also do a lot with JSON but a JSON string can go far beyond attributes,
values, and subvalues. Would be interested in Doug's take on how to extract
something out of a JSON string without parsing it from scratch on every
extraction, and how he would represent 4 or more dimensions in a MV item?
On 11/12/10 23:29, Kevin King wrote:
We also do a lot with JSON but a JSON string can go far beyond attributes,
values, and subvalues. Would be interested in Doug's take on how to extract
something out of a JSON string without parsing it from scratch on every
extraction, and how he would
To see what you can use in any particular implementation, try RAISE()
and LOWER() to see how far they go (at least those who support these
functions). I've used them before but they are indeed a pain to
manipulate. Array reference statementsdon't recognize themand
English/JQL/Retrieve/etc.
In our JSON implementation (moving information between U2 and PHP) we've
artificially limited the data coming into U2 so that it doesn't go deeper
than (effectively) multivalues. We allow the data going out of U2, however,
to be nested significantly deeper. For this product the limit isn't a
