1. Hibernate search API with 2 tables stackoverflow.comI am trying to make a query with Hibernate criteria API. It looks simple but I can't get it to work. I have 2 tables. Person and Roles. Person has a set ... |
2. How to search two tables? forum.hibernate.org |
3. combining multi-table search, Criteria and LIMIT x forum.hibernate.orgHello! I want to accomplish this rather painful query by my standards (I'd rather see this query a bit simplified): Code: SELECT * FROM POI as p WHERE p.city like 'Hel%' and p.name like 'Sok%' AND p.id IN (SELECT po1.id, po2.id FROM POIOptions as po1, POIOptions as po2 WHERE (po1.opt_key LIKE 'email%' AND po1.opt_value LIKE 'jme@%') AND (po2.opt_key LIKE 'url%' AND ... |
4. Implementing Multi Search Criteria with multiple table forum.hibernate.orgHi I am working on a module, part of which is implementing search functionality. To walk you guys thru, I have 4 text boxes and 3 drop down lists in the screen. The user can enter either 1 or more search criteria (criteria here is the data the user enters into the text boxes or the drop down list). I have ... |
5. Multi searching from multiple tables with different keys forum.hibernate.orgHow to search based on different criteria from the given below tables and their relation ships? is there any way to use Criteria API for searching in multiple tables/classes? E.g. Table AAA id (Pk) group_type_id (fk-CCC) name des Table BBB id (primary key) p_id com_id (fk-DDD) gp_id (fk-DDD) st_date end_date Table CCC id (PK) name des Table DDD com_id (PK) com_name ... |