Creating multi-criteria searches across associations

0
I’ve encountered a bit of a challenge with my current project and would appreciate any insights or suggestions you might have. The objective is to implement a multi-criteria search across all user accounts and their associated attributes. I'm currently using a data grid to display the user accounts, and my data source comes from marketplace modules based on the account entity. The domain model is set up with a one-to-many association going to the account entity and coming from related entities like Skills, Certifications, and so on. However, my issue is that I can’t access the attributes within these associated entities (e.g., Skills or Certifications) when using the data grid, which is preventing me from populating the necessary columns. That said, I am able to make search comparison fields based on these associations, which is a bit puzzling. I also tried an alternative approach using a list view, where the data source is the account entity from the database. For the nested list views, I set the data source to the associated entities (like Skills and Certifications). While this method works well for displaying the data, I’m running into trouble with the multi-criteria search. I've tried using a Text Box Search Widget, however, I can only set the data source to the database, but the nested list views are by association, which causes issues. I also tried setting the nested list view’s data source to the database, but that resulted in displaying all objects, not just the ones associated with the specific user. My main question is: is what I’m trying to do even possible within this framework? I'd really appreciate any guidance with this issue.
asked
0 answers