Relationship value visibility depends on another selection of a relationship value?

[Marcel]

Hi all,

I have 3 Entities:

1. CContract (Many-to-One relation to CProductLine and CContractType)
2. CProductLine (One-to-Many relation to CContractType)
3. CContractType

I am in the Layout of the CContract Entity and when I am selecting a CProductLine (e.g. Insurances) under CContractType every ContractType that is related to the selected ProductLine should be selectable in the dropdown list. Is that possible? So based on the selected ProductLine the values under ContractType are filtered/visible.



I read something about a select-handlers and created the following.

/.../client/custom/src/handlers/select-related/contract-type-by-product-line.js

define('custom:handlers/select-related/contract-type-by-product-line', ['handler'], function (Dep) {

    return Dep.extend({

        filterData: function () {
            const productLineId = this.model.get('productLineId');

            if (!productLineId) {
                return null;
            }

            return [
                {
                    type: 'equals',
                    field: 'productLineId',
                    value: productLineId
                }
            ];
        }

    });
});​ 

But that does not seem to work.

Thanks!

[Marcel]

Hi,

does anyone has an idea or direction for me?

Thanks!

[shalmaxb]

I guess custom filter will do, look for that

[calvinmatteo]

Yes, it is possible to filter the dropdown list of CContractType based on the selected CProductLine. This can typically be achieved using a combination of JavaScript (for client-side filtering) and possibly server-side logic (if your data is being loaded dynamically sprunki).

[Marcel]

And a custom filter would also do it? How am I creating it?

Thanks!