Form a dynamic query using BooleanBuilder to select all records of eventHistory where last eventMark with category equlas to a specific category
I have 2 tables event_history and event_marks. event_marks table having foreign key reference with event_marks.event_history_id to event_history.id.Baiscally an event_history can have many event_marks(one to many relationship). I need to get all event_history records that have the last event_mark with category as a specific string. Currently i have a BooleanBuilder query that selects all the records using a “in” query.