Hi! I’m wondering about best practice for building my datamodel.
I have an object class “Project” and several other object classes referencing “Project”. Is this best practice, or should project be referencing these other classes?
Example of classes referencing “Project”: “unit”, “event”, “task”, “document”, “equipment” etc.
I run into problems when trying to create a “Project overview”. When using a table, I can only have columns which exist in the Project class, thus cannot show events in the table (since event is referencing project and not the other way around).
So I created my own table using an iterating container. The container iterates “Project”. Now the problem is filtering. I would like a “Search filter” where you can search and filter based on all properties of “Project” including object classes referencing “Project”. Example if input in search field is “Equipment 1” then only Projects containing “Equipment 1” should be visible. Conditional filtering for the iterative container only allows for filtering of “Project”, not classes referencing project