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