Hi Community,
I'm working in Creatio Freedom UI and I need to apply a filter to a lookup field in one of my sections.
The lookup field is based on another custom section, and the two sections are linked by a one-to-many relationship. I would like the lookup to show only the related records based on this relationship.
Could someone please guide me on how to apply this kind of filter to the lookup’s data source in Freedom UI?
Thanks in advance!
Like
Hello!
If one section references another via a one-to-many relationship (i.e., one entity contains the foreign-key column pointing to another), you can use this same approach. Business rules allow you to filter the lookup so it only displays the dependent records associated with the current parent record.
To filter a lookup field in a Creatio Freedom UI page based on a one-to-many relationship between two custom sections, you can configure this using a business rule, details here https://academy.creatio.com/docs/8.x/no-code-customization/customizatio…