Conditional query after join on is supported. >=,<=,in

[lurenjia11083]

SELECT
	seats.id,
	seats.seatname,
	COUNT( user_seats_order.id ) count 
FROM
	seats
	LEFT JOIN user_seats_order ON user_seats_order.seatid = seats.id 
	AND user_seats_order.dueendtime >= '2024-04-23T04:05:11' 
	AND user_seats_order.duestartime <= '2024-04-23T23:05:11' 
	AND user_seats_order.duestatu IN ( 0, 1, 2, 3 ) 

[jeffgbutler]

This is not supported currently. You will need to put the conditions in a WHERE clause.

[hermer]

public class GreaterThanOrEqualTo extends JoinCondition {
    public GreaterThanOrEqualTo(BasicColumn rightColumn) {
        super(rightColumn);
    }

    @Override
    public String operator() {
        return ">=";
    }
}

 public static JoinCondition buildJoinCondition(Operate operate, BindableColumn value) {
        if (Operate.GTE.equals(operate)) {
            return new GreaterThanOrEqualTo(value);
        }  
        // ...
    }