So, we now know that Domino 7.0.2 includes the ability to output JSON for a view in the same way it's been creating XML for years. But how good is it? Personally I've always found the DXL for ?ReadViewEntries fairly useless due to its odd structure. Well, I'm happy to report that, while the JSON output is a "similar" structure, we can actually use the data as is.
Note that this JSON output isn't supported by Domino 7 and is likely to change format before it ships with Domino 8. Worth bearing in mind if you're thinking of coding with it.
This morning I quickly knocked together a proof of concept page that showed how, using a combination of the data from ?ReadViewEntries and the design from ?ReadDesign it's possible to script a view-like table on a page. The table columns are sized in proportion to the backend view, columns have the correct title and even the alternate row colour is inherited.
You can see the results here.
There are some odd things about the Domino JSON output. For example the array that contains all rows is called viewentry rather than viewentries. Although it's likely to change it's good to know this is going to be a feature and, most importantly, we'll actually be able to use it!