On an order: Filter Contacts having the order account in job experience
Dear,
On a lookup, i would like to filter the contacts having the account in job experience (ContactCareer). this is in the case of secondary job.
Currently filter show only account's contacts
i tryed in the orderpageV2:
"UsrResponsableFacturation": {
"dataValueType": Terrasoft.DataValueType.LOOKUP,
"lookupListConfig": {
"filters": [function() {
var filters = Ext.create("Terrasoft.FilterGroup");
var accountId = this.get("Account");
filters.add("JobExperienceFilter",
Terrasoft.createColumnFilterWithParameter(
Terrasoft.ComparisonType.EQUAL,
"[Order:Account].ContactCareer.account.contact.name",
accountId
)
);
return filters;
}]
}
}
But it did not works.
I think the problem come from:
Terrasoft.createColumnFilterWithParameter(
Terrasoft.ComparisonType.EQUAL,
"[Order:Account].ContactCareer.account.contact.name",
accountId
)
I don't really understand how to access order's linked tables.
Does anybody can help me to solve this issue ?
Next i will only retrieve the contact with active job experience.
thank you
Nicolas
Like
Hi,
Please check your filter, it should be like '[ContactCareer:Contact].Account.Id'.
And also the second part on the screenshot, it should be 'this.get("Account").value'.