Hi All,
I have requirement
1)company table (core_company) Default view.
2)contract table (ast_contract)
In ast_contract table there is field Vendor which is reference to core_company table.
My requirement is we should created new related list- contract in core_company table in default view . In that contract we should want to display contracts based on that company and contracts state is = Active/Expired one's only.
I'm expecting the contract related list at the highlighted place in the below snip. please let us know how to achieve this.
Thank you
@Sirri , as i can see there are 4 choice for state Draft, active, expired, cancelled so in the below i have removed expired and cancelled to show Draft and active ones only similarly if your requirement is different you can add encoded query or you can add current.addQuery .
(function refineQuery(current, parent) {
// Add your code here, such as current.addQuery(field, value);
current.addQuery('vendor.name',parent.name);
current.addQuery('state', "!=",'expired');
current.addQuery('state',"!=", "cancelled");
})(current, parent);
Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Swathi Sarang
Hi @Sirri ,
You can create a Relationship between Company table and Contract Table ,
System Definition ->Relationship
create something like below,
On company table Configure-> Related List add the new created Relationship it would look something like this ,
Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Swathi Sarang
