Associations and Grid

[Everton Luiz Pascke]

Hi people,
I'm trying to use Associations with Grid.
Is it possible?
I'm doing with belongsTo, but unsuccessfully.
Below codes:

Models

Ext.define('App.model.Action', {
	extend: 'Ext.data.Model',
	idProperty: 'id',
	fields: [
		{ name: 'id', type: 'int' },
       	{ name: 'descricao', type: 'string' }
	]
});

Ext.define('App.model.Metodo', {
	extend: 'Ext.data.Model',
	idProperty: 'id',
	fields: [
		{ name: 'id', type: 'int' },
       	{ name: 'descricao', type: 'string' }
	]
});

Ext.define('App.model.Funcionalidade', {
	extend: 'Ext.data.Model',
	idProperty: 'id',
	fields: [
		{ name: 'id', type: 'int' },
       	{ name: 'modo', type: 'string' }
	],
	associations: [
        { type: 'belongsTo', model: 'App.model.Action', name: 'action'},
        { type: 'belongsTo', model: 'App.model.Metodo', name: 'metodo'}
    ]
});

Store

Ext.define('App.store.Funcionalidade', {
	extend: 'Ext.data.Store',
	autoLoad: true,
	remoteSort: true,
	model: 'App.model.Funcionalidade',
	proxy: {
		type: 'ajax',
		url: 'funcionalidade.carregar',
		reader: {
			type: 'json',
			root: 'data',
			idProperty: 'id',
			totalProperty: 'total',
			successProperty: 'success'
		}
	},
	sorters: [
		{ property: 'modo', direction: 'ASC' }
	]
});

Grid Columns

columns = [
    { 
    	header: 'Action',  
    	dataIndex: 'action.descricao',  
    	flex: 1
    },
    { 
    	header: 'Método',  
    	dataIndex: 'metodo.descricao',  
    	flex: 1 
    },
    { 
    	header: 'Modo',  
    	dataIndex: 'modo',  
    	flex: 1
    }
];

Data

{
	"total":2,
	"success":true,
	"data":[
		{"id":"40:1","modo":"LO","metodo":{"id":1,"descricao":"Consultar"},"action":{"id":40,"descricao":"Banco"}},
		{"id":"40:3","modo":"LO","metodo":{"id":3,"descricao":"Editar"},"action":{"id":40,"descricao":"Banco"}}
	]
}

[Yuriksan]

Hi, I'm also trying to figure out a solution to this today, any progress on your side?

[Everton Luiz Pascke]

No progress Yuriksan.
When I need access with dot notation, I use implicit model.
I create my data store without model and configure the fields with names using the access operator.

See http://www.sencha.com/forum/showthre...ation-in-field

[mik3e]

Just another note:
After two days of sandboxing I found out that associations only really work if the proxy is defined in the model, not in the store (ExtJS 4.1.3).

It seems like the model is not passing the proxies URL to the "magic" getter method when the proxy is defined in the store. This results in an index out of bounds exception in the buildURL method.