I use array type to store info,like this:
{
"_index": "pt_account",
"_type": "pt_account",
"_id": "na0056879556511",
"_score": 1,
"_source": {
"pt_account": [
{
"column": "data_date",
"value": "2014-07-01"
},
{
"column": "id",
"value": "3370679382"
},
{
"column": "pt",
"value": "na00568795565"
},
{
"column": "gxh_account",
"value": "mp01066999778odm"
},
{
"column": "mobile_account",
"value": "1111111111"
},
{
"column": "email_account",
"value": null
}
]
}
}
and here is the mapping:
"pt_account": {
"type": "nested",
"properties": {
"column": {
"type": "string",
"index": "not_analyzed",
"omit_norms": true,
"index_options": "docs"
},
"value": {
"type": "string",
"index": "not_analyzed",
"omit_norms": true,
"index_options": "docs"
}
}
}
i want to use range to filter id from 1 to 300,but the type of value is string,
so is there any method to solve this?
Thank you so much