Model idProperty

[ValterBorges]

Many times tables have natural keys instead of auto generated.

In these scenarios is it possible to set the Model idProperty to more than one field. If not how do you concatenate two fields in the model and create a composite key???

or is it better to not specify idProperty and let one be generated?

[Fanny144]

I have the same doubt that your. Also how you can change the name of the idProperty??
Always must be id??or is that because extjs 4.0 still not well developed and soon it will make??

Please, help...

[cdavide75]

Yes, I have some problem
in EXT JS 3.x I set IdProperty: 'namefield' and in Update the store (example grid with roweditor) 'namefiled' is use as like as ID... work
in EXT JS 4.0 I set IdProperty but don't work. If I pass a object with key filed = 'id' work....

[ValterBorges]

In the fields config object of the Model you can create a field say id that uses a convert function to concatenate two fields from the record.

ex:

Ext.define("My.Models.ModelA",{extend:"Ext.data.Model",
fields:[
{name: 'id', type:'string', convert: function(value,record) {
return record.get('COLPK1') + record.get('COLPK2')
}
},
{name: 'COLPK1', type:'string'},
{name: 'COLPK2', type:'string'},
{name: 'SOMEOTHERCOL', type: string'}
],
idProperty: 'id'
});

[infernoz]

Doesn't this seem kind of hacky? Shouldnt there be a way of specifying multiple fields as your unique key without having to concatenate things together to create one field?

[yclick]

Record 0: { COLPK1: 'aa', COLPK2: 'bb' }
Record 1: { COLPK1: 'a', COLPK2: 'abb' }

The store will add only one row in this situation because (colpk1[0] + colpk2[0]) == (colpk1[1] + colpk2[1]).

[dawesi]

You could create a custom validator to enforce the composite key.

[lo230c]

You can add a dash in between and make it unique. 'aa-bb' is not the same 'a-abb'