How can i get a Array in doc back as Array


#1

I have a doc which has Json Arrays to store a list of streets as well as Models. If i try to the folowing Query

SELECT street from default where meta().id = "tract::3e43989c-39a6-417c-88ea-ffc464441cc4";

i get this

[{“street”: [
“Dunn St”,
“Gullwing Dr”,
“Port St”,
“Saltaire Dr”,
“Stern St”,
“Stream St”
]}]

is there a way to just get the data returned like this via the query directly

 [
  "Dunn St",
  "Gullwing Dr",
  "Port St",
  "Saltaire Dr",
  "Stern St",
  "Stream St"
]

This is how it is stored in my json doc

 {
  "tractid": "2055",
  "type": "tractInfo",
   "street": [
    "Dunn St",
    "Gullwing Dr",
    "Port St",
    "Saltaire Dr",
    "Stern St",
    "Stream St"
  ]}

#2

USE RAW if projection is single element.

SELECT RAW street 
FROM default 
WHERE  meta().id = "tract::3e43989c-39a6-417c-88ea-ffc464441cc4";

SELECT RAW street 
FROM default 
USE KEYS "tract::3e43989c-39a6-417c-88ea-ffc464441cc4";