Computer scienceBackendSpring BootSpring Data

Custom queries with @Query

Custom filtering

Report a typo

Here is the Order class:

@Entity
public class Order {
    @Id
    @GeneratedValue
    private long id;
    private String status;
    private int price;
    private String name;

    // constructor, getters, setters
}

Let's say we have a custom @Query annotation that retrieves all the orders with a particular name in which a total price less than a specified value or status is "SUCCESS":

@Query(value = "____", nativeQuery = true)
List<Order> findOrdersByNameWithSuccessOrBelowPrice(int price, String name);

Which of the following query string will correctly produce the order list?

Select one option from the list

SELECT * FROM orders WHERE status = :status AND (total_price < :price OR name = :name)

SELECT * FROM orders WHERE (status = 'SUCCESS' OR total_price < :price) AND name = :name

SELECT * FROM orders WHERE status = 'SUCCESS' AND total_price < :price AND name = :name

SELECT * FROM orders WHERE total_price < :price AND name = :name

SELECT * FROM orders WHERE status = 'SUCCESS' OR total_price < :price OR name = :name

___

Create a free account to access the full topic