Using Space in Key name/ field name


#1

I know that we shouldn’t use spaces(we should use _ ) in key/field names. But in one of our document we have a space as shown below. So how to query using the value Company Name. Or should the Database architect has to change the value from Company Name to Company_Name. do we have any work around. Appreciate the help.

{
“lookupModelList”: [
{
“attributeValueMap”: {
“Company Name”: “ABC”,
“Report Type”: “XYZ”,
“Issue Date”: “Fri Jul 25 09:46:02 2014”,
“id”: “2”
}
]
}


#3

You can use back ticks around the field name in your queries.


#4

Thanks …it worked, appreciate the help