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 0

Like

1 comments

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'.

Show all comments