Hi All,
I created an entity backed record on the main table which works as expected. However, as part of requirement we require to do search on the data in the child table which has one-to-many relationship (for each entry in main table, there can be multiple entries in child table). I tried using expression-backed record. But I'm only able to display the entries of child table, but cannot search on those fields. Is there anyway we can do the search on child table from record default search?
Note: We are currently on 21.2 and explored the new feature of adding relationship for records. However,it does support only Many-to-One and one-to-one relationship which is of no use for our use case
Discussion posts and replies are publicly visible
Regarding the relationship types for records, documentation says that for Many-to-Many and One-to-Many we should use the old approach. This would typically be a view in DB.