@SuperBuilder
@NoArgsConstructor
public class UserQuery extends PageQuery {
// ...
@Subquery(select = "avg(score)", from = UserEntity.class)
private UserQuery scoreLtAvg;
@Subquery(select = "score", from = UserEntity.class)
private UserQuery scoreLtAny;
@Subquery(select = "score", from = UserEntity.class)
private UserQuery scoreLtAll;
@Subquery(select = "avg(score)", from = UserEntity.class)
private UserQuery scoreGtAvg;
}
@Getter
@Setter
@SuperBuilder
@NoArgsConstructor
@AllArgsConstructor
public class MinimumCostSupplierQuery extends PageQuery {
private Integer p_size;
private String p_typeEnd;
private String r_name;
@SubqueryV2(MinSupplyCostView.class)
private SupplyCostQuery psSupplycost;
@View(value = PartEntity.class, context = true)
@View(PartsuppEntity.class)
@View(SupplierEntity.class)
@View(NationEntity.class)
@View(RegionEntity.class)
private static class MinSupplyCostView {
@NoLabel
private Integer minPs_supplycost;
}
}