List view

[krishnapriya]

Hello,

I created a custom field type in the same way as phone, but contains 3 column values.


It is working perfect with detail and edit views, But I need to display all the values of the field in list view also.





Normally it is not displayed but when I click view and comes back to the list view it is displayed. And on refresh it goes again




data: function () {
var listItemData;
if (this.mode == 'edit') {
listItemData = Espo.Utils.cloneDeep(this.model.get(this.dataField Name));
if (this.model.isNew() || !this.model.get(this.name)) {

if (!listItemData || !listItemData.length) {
listItemData = [{
description: this.model.get(this.description) || '',
unit: this.defaultType || '',
unitPrice: this.model.get(this.unitPrice) || ''
}];
}
}
} else {
listItemData = this.model.get(this.dataFieldName);
}

return _.extend({
listItemData: listItemData
}, Dep.prototype.data.call(this));
},



Can anyone help me with this?

I am really stuck.

Thanks in advance.

[tanya]

Hello
define the value also in loadAdditionalFieldsForList

http://forum.espocrm.com/forum/developer-help/21530-upddate-a-listview-including-a-linkmulti-field

[krishnapriya]

Thank you so much Tanya, That worked.

[krishnapriya]

Hello,

When I removed the above custom field from its entity, it gives me an error -

Server side error 200: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DESC LIMIT 0, 100' at line 9

in only List view. When I tried adding this custom field again, error goes.

What is actually causing this error in List view?

Detail/edit view has no error on removing this custom field type.

Please help.

Thanks in advance.

[tanya]

Remove it from the list layout and reset search (filter or order could contain this field)

[krishnapriya]

Thank you so much Tanya, Reset search worked.