Filtering a Lookup
It is possible to filter a lookup whether it is in a grid or in a filter. To do so you have to intercept the action of the opening of the lookup, then you have to filter its grid.
Here an example:
Create a new action js. This will be the action that will filter the lookup.
Go to the filter panel and then on Event Components and add a new event:
Field of the database: field where the lookup is hooked.
Event: Before grid opening.
Action: our action (previously created)
If you want to validate filtering what the user write in the lookup, you have to hook the same action to the action Before validation
Now your lookup will be filtered as described in the JS action in the first point.
Last updated