Skip to Content
0
May 18, 2018 at 06:27 PM

how to load data json to combobox

235 Views Last edit May 18, 2018 at 06:57 PM 8 rev

Hi community, i'm triying to load some data from my json to a combobox but nothing happend

error:

jquery.sap.global-dbg.js:1035 2018-05-18 14:37:36.056399 The following problem occurred: parsererror - {
	"V_ADRCTPRT" : [ {
	    "cod_comuna":   "1000005",  "cod_pob": "02101",	"nomb_comuna": "ANTOFAGASTA",	"ciudad": "ANTOFAGASTA",   "region": 02"
	    "cod_comuna":   "1000005",  "cod_pob": "02102",	"nomb_comuna": "MEJILLONES",	"ciudad": "ANTOFAGASTA",   "region": 02"
	    "cod_comuna":   "1000005",  "cod_pob": "02103",	"nomb_comuna": "SIERRA GORDA",	"ciudad": "ANTOFAGASTA",   "region": 02"
	    "cod_comuna":   "1000005",  "cod_pob": "02104",	"nomb_comuna": "TALTAL",		"ciudad": "ANTOFAGASTA",   "region": 02"
	} ]
},200,OK 

my structure just in case

this is my data: (comunas.json)

{ "V_ADRCTPRT" : [ 
	    {"cod_comuna":   "1000005",  "cod_pob": "02101",	"nomb_comuna": "ANTOFAGASTA",	"ciudad": "ANTOFAGASTA",   "region": "02"},
	    {"cod_comuna":   "1000005",  "cod_pob": "02102",	"nomb_comuna": "MEJILLONES",	"ciudad": "ANTOFAGASTA",   "region": "02"},
	    {"cod_comuna":   "1000005",  "cod_pob": "02103",	"nomb_comuna": "SIERRA GORDA",	"ciudad": "ANTOFAGASTA",   "region": "02"},
	    {"cod_comuna":   "1000005",  "cod_pob": "02104",	"nomb_comuna": "TALTAL",		"ciudad": "ANTOFAGASTA",   "region": "02"}
 ]
}

this is my view:

<ComboBox showSecondaryValues= "true"
          items="{path: '/oModelComunas/V_ADRCTPRT'}">
<core:ListItem key="{cod_comuna}-{cod_pob}" text="{nomb_comuna}" additionalText = "{ciudad}"/>
</ComboBox>

and in my controller i don't know how to load the data

var oModelComunas = new JSONModel(jQuery.sap.getModulePath("crm.prospecto", "/model/comunas.json"));
this.getView().setModel(oModelComunas);

Attachments

structur.png (6.6 kB)