FITFLOP
Home

jpql (5 post)


posts by category not found!

Use JPQL or SQL to SELECT items _not_ in the database from a supplied set in the query parameters

Selecting Items Not in the Database with JPQL and SQL When working with databases a common requirement is to filter and retrieve data based on specific criteria

2 min read 16-10-2024 29
Use JPQL or SQL to SELECT items _not_ in the database from a supplied set in the query parameters
Use JPQL or SQL to SELECT items _not_ in the database from a supplied set in the query parameters

JPA Query with NOT LIKE doesn't work to filter ips

Troubleshooting JPA Queries with NOT LIKE for IP Address Filtering Filtering data based on IP addresses can be a common requirement in applications particularly

2 min read 06-10-2024 33
JPA Query with NOT LIKE doesn't work to filter ips
JPA Query with NOT LIKE doesn't work to filter ips

hierarchical filter spring data jpa jpql

Mastering Hierarchical Filtering in Spring Data JPA with JPQL Filtering data based on hierarchical relationships is a common requirement in many applications Th

2 min read 05-10-2024 24
hierarchical filter spring data jpa jpql
hierarchical filter spring data jpa jpql

Spring Boot 3.x.x, Left Join with condition stopped working correctly

Spring Boot 3 x x Left Join with Condition Suddenly Not Working Spring Boot 3 x x brings a host of new features and improvements but sometimes these updates can

2 min read 02-10-2024 26
Spring Boot 3.x.x, Left Join with condition stopped working correctly
Spring Boot 3.x.x, Left Join with condition stopped working correctly

JPA OneToMany JoinColumn returning unrelated children

Understanding JPA One To Many Join Column Returning Unrelated Children When working with JPAs One To Many relationship developers often encounter the frustratin

3 min read 29-09-2024 28
JPA OneToMany JoinColumn returning unrelated children
JPA OneToMany JoinColumn returning unrelated children