Foreign key (many-to-one) filters

English Forum Technical
1

Hi,

I’m looking for a way to restrict a foreign key filed to a subset of the target table. For example, in a Customer field, I want to allow only Partners that have a isCustomer attribute set to true:

<many-to-one name=“customer” ref=“my.package.db.Partner” …only customer partners… title=“Customer”/>

I can’t find this in the docs, but I’m sure I’m missing something…

Could someone point me to the relevant resource?

Thanks
Franck

2

Hi
You’ve to use the domain clause on the UI
Regards

3

Hi,

You can have a look here https://docs.axelor.com/adk/5.0/dev-guide/actions/action-view.html#vie-action and a sample can be found in menu.XML of axelor-cm






self.isContact = true AND self.mainPartner.isCustomer = true

U need to specify a jpql clause in a domain node

4

So if I’m not misunderstanding, this will add a filter in the view, but will not enforce the constraint at the db level.
That might be enough for my use case, but it’s just to be sure.

5

yes, you’re right.