Hello everyone,
I’m seeking your assistance regarding a relational filtering functionality that I’d like to implement in my application.
Current structure:
- An “Aircraft” table containing approximately 40 fields detailing aircraft characteristics
- An “Operators” table including a “Fleet” column of type Enumlist ref → Aircraft to constitute their fleets
Objective: In the “Aircraft” view, after filtering and selecting multiple aircraft, I want to add an action that identifies all operators that operate at least one of the selected aircraft.
Concrete example: If I select aircraft #1, #6, and #12, the action should display a filtered view of operators #15, #35, #75, #1225, etc. who have at least one of these three aircraft in their fleet.
Important technical constraints:
- Avoid adding additional tables (join tables)
- Don’t use additional real columns in existing tables
- Allow simultaneous use by multiple users
- Optimize synchronization performance given the large volume of data
I’ve already tested the linktofilteredview approach without success.
If you have any suggestions for implementing this functionality while respecting these constraints, I’m very interested in your feedback and experience.
I remain available for any additional clarification needed.
Thank you in advance for your help.