TypesafeSubqueryExample.java

TypesafeQuery<VirtualCircuit> tq = newTypesafeQuery(VirtualCircuit.class);
        QVirtualCircuit cand = QVirtualCircuit.candidate("virtualCircuit");

        // find al uncompleted NetworkInformationFunction's for the virtual circuit
        TypesafeSubquery<NetworkInformationFunction> subquery = tq.subquery(NetworkInformationFunction.class, "uncompletedNIF");
        QNetworkInformationFunction uncompletedNIF = QNetworkInformationFunction.candidate("uncompletedNIF");
        subquery.filter(uncompletedNIF.completed.eq(false));

        tq.filter(cand.automaticShapingEnabled.eq(true)
                .and(cand.eq(((QNetworkInformationFunction)subquery.candidate()).virtualCircuit))
            .and(subquery.selectUnique(uncompletedNIF.count()).eq(0)));
        tq.orderBy(cand.automaticShapingPerformed.asc());
        tq.range(0,1);