neo4j/cypher-plugin — Issue #2: Problems with JSON-table-format output.
Author: naschbac
Created: 2011-10-24 21:10:50+00:00
State: open

My understanding is that this results format option is supposed to make it easier to populate a Google Visualization DataTable object with the results of Cypher queries.

At the moment the JSON-table-format output is broken in two critical ways.

1) It wraps all the JSON identifiers in double-quotes, which prevents it from loading at all using the: new google.visualization.DataTable(myJSONdata) constructor method to populate the new DataTable instance with the proper data.

2) After you manually resolve #1 by stripping all the double-quotes out it still doesn't properly construct row outputs. So if you have three columns with 4 rows of results from your query you end up with a DataTable rendered as 3 columns with 12 rows and all the row values dumped into the first column. The 2nd and 3rd columns are empty cells.