[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
[eclipselink-users] criteriaquery : fetch not working
|
Hi,
We have a big object model, which triggers lots of queries on some
occasions. I tried to rewrite some queries to use fetch joins. One of
them still gives me headaches:
CriteriaBuilder builder = entityManager.getCriteriaBuilder();
CriteriaQuery<EtdOffEtd> query =
builder.createQuery(EtdOffEtd.class);
Root<EtdOffEtd> root = query.from(EtdOffEtd.class);
Path<Long> numOffrePath =
root.get(EtdOffEtd_.epcOffre).get(EpcOffre_.numOffre);
Path<Integer> anacPath = root.get(EtdOffEtd_.anac);
Path<String> nomaPath = root.get(EtdOffEtd_.noma);
Predicate exprNumOffre = builder.equal(numOffrePath, numOffre);
Predicate exprAnac = builder.equal(anacPath, anac);
Predicate exprNoma = builder.equal(nomaPath, noma);
query.where(exprNumOffre, exprAnac, exprNoma).distinct(true);
root.fetch(EtdOffEtd_.etdInscCoursCollection, JoinType.LEFT);
root.fetch(EtdOffEtd_.etdOffEtdSesCollection, JoinType.LEFT);
root.join(EtdOffEtd_.etdInscCoursCollection,
JoinType.LEFT).fetch(EtdInscCours_.epcEle, JoinType.LEFT);
root.fetch(EtdOffEtd_.epcOffre);
root.join(EtdOffEtd_.epcOffre).fetch(EpcOffre_.epcOffreEleCollection,
JoinType.LEFT);
TypedQuery<EtdOffEtd> typedQuery =
entityManager.createQuery(query);
EtdOffEtd etdOffEtd = typedQuery.getSingleResult();
Should just run 1 sql query, from my understanding.
In fact, I'm seeing lots of them (see below, just by running last line).
Relevant summary of object model:
- EtdOffEtd has 1 EpcOffre
- EpcOffre has a list of EpcOffreEle
- EpcOffreEle has 1 EpcOffre and 1 EpcOffreEle
We are trying to get all EpcOffreEle in above query.
It seems it succeeded on something similar but I don't see any difference.
Regards,
Yannick Majoros
Précis: SELECT DISTINCT t1.NOMA, t1.ANAC, t1.ANAC_COND_ACCES,
t1.ANAC_ETAL, t1.ANAC_REF_PRG, t1.CODE_TARIF_FORCE, t1.CODE_TIER_PAYANT,
t1.COND_ACCES, t1.CONVENTION, t1.COURS, t1.DATE_ETAT, t1.DATE_FINAN,
t1.DATE_GRD_FINAL, t1.DATE_MODIF_INSCR_COURS, t1.DEBUT,
t1.DEBUT_ECHANGE, t1.DEMANDE_INSCR_COURS, t1.DIPL_ACC_PART,
t1.DIX_POURC, t1.DPT_ECHANGE, t1.ECHANGE, t1.ECOLE_DOCT, t1.ETAT_INSCR,
t1.FAC_ECHANGE, t1.FIN_ECHANGE, t1.FINANCABLE, t1.GRADE_FINAL,
t1.INSCR_COURS, t1.LEGALISATION, t1.NBR_COURS, t1.NBR_ILV_PAYANT,
t1.NBR_MODULES, t1.NOM_CONVENT, t1.NUM_FACULTAIRE, t1.NUM_OFFRE,
t1.ORDRE_POURC, t1.PAIE_DROIT, t1.PCT_FINAL, t1.PRG_NORMAL,
t1.PRINC_SEC, t1.PRINC_SEC_FORCE, t1.SECTION, t1.SIGLE_SECU, t1.STATUT,
t1.SW_COMPTA, t1.SW_FINAN, t1.SW_MAJ_ANC, t1.TOT_MODULES, t1.TYPE_DUREE,
t1.TYPE_ECHANGE, t1.UNIV_ECHANGE, t1.VISA, t0.NUM_OFFRE, t0.VALIDITE,
t0.ACADEMIQUE, t0.ACTIF, t0.ADULTE, t0.ANACCRE, t0.ANCIEN_CODE,
t0.AUTRES_FAC, t0.CATEG, t0.CATEG_UCL, t0.CERTIFICAT_UNIV, t0.CODACCES,
t0.CODETARIF, t0.COMMENTAIRE, t0.CYCLE, t0.DATE_CONSEIL,
t0.DATE_DER_EVALUATION, t0.DATE_DIFF_COURS, t0.DATE_DIFF_NOTE1,
t0.DATE_DIFF_NOTE2, t0.DATE_DIFF_NOTE3, t0.DATE_EVALUATION,
t0.DATE_MODIF, t0.DATE_NOTE1, t0.DATE_NOTE2, t0.DATE_NOTE3,
t0.DEBUT_INSCR_COURS, t0.DEBUT_INSCR_EXAM1, t0.DEBUT_INSCR_EXAM2,
t0.DEBUT_INSCR_EXAM3, t0.DEBUT_ORG, t0.DELIBE1, t0.DELIBE2, t0.DELIBE3,
t0.DEPARTDPL, t0.DEPOT_MEM1, t0.DEPOT_MEM2, t0.DEPOT_MEM3, t0.DIPLOME,
t0.DOMDECR, t0.DOMETUCH, t0.DOMETULT, t0.DPL_CONJOINT, t0.DPLCOURS,
t0.DURCAPITAL, t0.DUREE, t0.ETAT_PROPOSITION, t0.FIN_INSCR_COURS,
t0.FIN_INSCR_EXAM1, t0.FIN_INSCR_EXAM2, t0.FIN_INSCR_EXAM3, t0.FIN_ORG,
t0.FINAN_CUD, t0.FINANCEMENT, t0.FONDUNIF, t0.FORMULE_CALC_CYCLE,
t0.GESTDEC, t0.GRADE, t0.GRADE_FINAL, t0.HEURE_DIFF_NOTE1,
t0.HEURE_DIFF_NOTE2, t0.HEURE_DIFF_NOTE3, t0.HEURE_NOTE1,
t0.HEURE_NOTE2, t0.HEURE_NOTE3, t0.HPARTICULIER, t0.INAMI,
t0.INSTITUTION, t0.INTER_UNIF_BLG, t0.INTER_UNIF_CF,
t0.INTER_UNIF_ETRANGER, t0.INTER_X, t0.INTIT_ABREGE, t0.INTIT_COMP_ANGL,
t0.INTIT_COMPLET, t0.INTIT_DIPLOME, t0.INTIT_ORIENT_ANGL,
t0.INTIT_ORIENTATION, t0.INTRA_ACAD, t0.LEGALSC, t0.LEP_LHP,
t0.LETTRES_FINALES, t0.LHPIDENT, t0.LOCALISATION, t0.MEMOIRE,
t0.MOINS300, t0.NBR_EPREUVE, t0.NBRMAX, t0.NIVEAU, t0.NOMPRES,
t0.NOMSECR, t0.NOMSIGN, t0.NOUVEAU, t0.NOUVEAU_CODE, t0.NUM_CONSEIL,
t0.NUM_DOS, t0.OFFRE_ID, t0.ORIENT, t0.ORIENT_FINAN_CUD, t0.ORIENTATION,
t0.ORIENTDPL, t0.PERSTAGE, t0.PONDERATION, t0.PREREQUIS, t0.PRESENT,
t0.QUALIFICATION, t0.QUALSIGN, t0.SECSIGLE, t0.SECURITE, t0.SEQCOURS,
t0.SIGLE_ADMIN, t0.SIGLE_DOS, t0.SIGLE_GESTION, t0.SIGLE_OFFRE, t0.SNU,
t0.STAGES, t0.SW_NIVEAU, t0.SW_QUALIFICATION, t0.TOT_OBLIG,
t0.TOT_RECOM, t0.TYPDUREE, t0.TYPE_DIPLOME, t0.TYPE_OFFRE,
t0.TYPE_PROPOSITION, t0.UTIL_MODIF, t0.VOL_OBLIG, t0.VOL_OPTION,
t0.VOL_RECOM, t0.LOCALISATION_ID, t0.OFFRE_UCLOUVAIN_ID, t0.SITE_ID,
t2.NUM_SESS, t2.ANAC, t2.AUTOR_POURSUITE, t2.CLASSEMENT, t2.COMMENTAIRE,
t2.CREDITS_ACQUIS, t2.DATE_DELIBE, t2.DATE_DIFF_NOTE, t2.DATE_INSCR,
t2.EPM, t2.EXAEQUO, t2.HEURE_DIFF_NOTE, t2.INSCR_EXAM, t2.NOMA,
t2.NUM_OFFRE, t2.PERIODE, t2.POURC_INITIAL, t2.POURCENTAGE, t2.RESULTAT,
t2.SUIVI, t2.TOT_POND, t2.U_VERSION, t3.ANAC, t3.ANAC_REF_ELE,
t3.APPREC_1, t3.APPREC_2, t3.APPREC_3, t3.APPREC_4, t3.APPREC_5,
t3.CREDIT_1, t3.CREDIT_2, t3.CREDIT_3, t3.CREDIT_4, t3.CREDIT_5,
t3.ETAT_COURS, t3.ETAT_EVALUATION, t3.ETAT_EXAM_1, t3.ETAT_EXAM_2,
t3.ETAT_EXAM_3, t3.ETAT_EXAM_4, t3.ETAT_EXAM_5, t3.MENTION_1,
t3.MENTION_2, t3.MENTION_3, t3.MENTION_4, t3.MENTION_5, t3.NOMA,
t3.NOTE_1, t3.NOTE_2, t3.NOTE_3, t3.NOTE_4, t3.NOTE_5, t3.NUM_ELE,
t3.NUM_ELE_RGR, t3.NUM_ENR_NOTE_1, t3.NUM_ENR_NOTE_2, t3.NUM_ENR_NOTE_3,
t3.NUM_ENR_NOTE_4, t3.NUM_ENR_NOTE_5, t3.NUM_OFFRE, t3.NUM_ORDRE,
t3.NUM_SERIE, t3.SECTION, t3.SIGLE_SECU, t3.U_VERSION,
t3.VALIDITE_SERIE_TH, t3.REF_SERIE_TH FROM ETD_OFF_ETD t1 LEFT OUTER
JOIN ETD_OFF_ETD_SES t2 ON ((t2.ANAC = t1.ANAC) AND ((t2.NOMA = t1.NOMA)
AND (t2.NUM_OFFRE = t1.NUM_OFFRE))) LEFT OUTER JOIN ETD_INSC_COURS t3 ON
((t3.ANAC = t1.ANAC) AND ((t3.NOMA = t1.NOMA) AND (t3.NUM_OFFRE =
t1.NUM_OFFRE))), EPC_OFFRE t0 WHERE ((((t1.NUM_OFFRE = ?) AND (t1.ANAC =
?)) AND (t1.NOMA = ?)) AND ((t0.VALIDITE = t1.ANAC_REF_PRG) AND
(t0.NUM_OFFRE = t1.NUM_OFFRE)))
bind => [12646, 2010, 40140600]
Précis: SELECT LOCALISATION_ID, LOCALISATION, SERVICE_INSCRIPTION,
SIGLE_LOCALISATION FROM EPC_LOCALISATION WHERE (LOCALISATION_ID = ?)
bind => [3]
Précis: SELECT OFFRE_UCLOUVAIN_ID, ACADEMIQUE, ADULTE, ANACCRE,
ANNEE_DER_EVAL_AEQES, ANNEE_PRC_EVAL_AEQES, AUTRES_FAC, CATEG,
CATEG_UCL, CERTIFICAT_UNIV, CODACCES, CODETARIF, DATE_CONSEIL,
DATE_MODIF, DEPARTDPL, DIPLOME, DOMDECR, DOMETUCH, DOMETULT,
DPL_CONJOINT, DPLCOURS, DURCAPITAL, DUREE, ETAT_PROPOSITION, FINAN_CUD,
FINANCEMENT, FONDUNIF, GESTDEC, GRADE, GRADE_FINAL, HPARTICULIER, INAMI,
INSCRIPTIBLE, INTER_X, INTIT_ABREGE, INTIT_COMP_ANGL, INTIT_COMPLET,
INTIT_DIPLOME, INTIT_ORIENT_ANGL, INTIT_ORIENTATION, INTRA_ACAD,
LEGALSC, LEP_LHP, LHPIDENT, MOINS300, NBR_EPREUVE, NBRMAX, NOUVEAU,
NUM_CONSEIL, NUM_DOS, ORIENT, ORIENT_FINAN_CUD, ORIENTDPL, PERSTAGE,
PREREQUIS, PRESENT, QUALIFICATION, SECURITE, SEQCOURS, SIGLE_DOS, SNU,
SW_NIVEAU, SW_QUALIFICATION, TOT_OBLIG, TOT_RECOM, TYPDUREE,
TYPE_DIPLOME, TYPE_OFFRE, TYPE_PROPOSITION, UTIL_MODIF, VALIDITE,
VOL_OBLIG, VOL_OPTION, VOL_RECOM, OFFRE_SIGLE_ID FROM
EPC_OFFRE_UCLOUVAIN WHERE (OFFRE_UCLOUVAIN_ID = ?)
bind => [2528251]
Précis: SELECT OFFRE_SIGLE_ID, LETTRES_FINALES, NIVEAU, OCYCLE,
ORIENTATION, SIGLE, OFFRE_SIGLE_SUIVI_ID FROM EPC_OFFRE_SIGLE WHERE
(OFFRE_SIGLE_ID = ?)
bind => [201601]
Précis: SELECT OFFRE_SIGLE_SUIVI_ID, DESCRIPTION FROM
EPC_OFFRE_SIGLE_SUIVI WHERE (OFFRE_SIGLE_SUIVI_ID = ?)
bind => [193401]
Précis: SELECT OFFRE_SUPPL_ID, AUTRE_ETAB, COND_ACCES, INFO_DPL,
LANGUES, NOTATION, TITRE_PROF, OFFRE_UCLOUVAIN_ID FROM EPC_OFFRE_SUPPL
WHERE (OFFRE_UCLOUVAIN_ID = ?)
bind => [2528251]
Précis: SELECT SITE_ID, CODE_SITE, COORGANISATEUR, LETTRE_SITE,
NOM_SITE, ORGANISATEUR, SIGLE_SITE FROM EPC_SITE WHERE (SITE_ID = ?)
bind => [1]
Précis: SELECT ANAC, ANAC_ACCESS, CODE_ACCESS, LIB_ACCESS, MODIF_LIB,
NOMA, NUM_OFFRE, ORIGINE, PRG_ACCESS, U_VERSION FROM ETD_DPL_ACC WHERE
(((NOMA = ?) AND (ANAC = ?)) AND (NUM_OFFRE = ?))
bind => [40140600, 2010, 12646]
Précis: SELECT ANAC, B1, B2, B3, CLAFA, CODE_ACCES, COND_INSCR,
DATE_ENTERIN, FAC, LEGAL, LHP_IDENT, LOB1, LOB2, LOB3, LOCAL, MAN1,
MAN2, MAN3, MODETAL, NOMA, NUM_OFFRE, PRESENT, SANS_SUIVRE, TYPE_ENREG,
U_VERSION FROM ETD_OFF_ETD_ANC WHERE (((NUM_OFFRE = ?) AND (ANAC = ?))
AND (NOMA = ?))
bind => [12646, 2010, 40140600]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [37966, 2010]
Précis: SELECT CAMPUS_ID, LETTRE, NOM, SITE_ID FROM EPC_CAMPUS WHERE
(CAMPUS_ID = ?)
bind => [1]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [38565, 2010]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [38569, 2010]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [38571, 2010]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [38572, 2010]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [43471, 2010]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [54730, 2010]
Précis: SELECT NUM_ELE, VALIDITE, ABREGE_ANGL, ACT_PART, ACTIF,
ANC_CNUM, ANC_SIGLE, ANC_SUBD, ANNEE_EVAL, AUTOR_VRECT, CAT_NUM_VAC,
CAUSE_VAC, CHGT_CONT, CNUM, CODE_ACT_UNIV, COEF_MULT1, COEF_MULT2,
COEF_MULT3, COMPLEMENT_ANGL, CONTRAINTE1, CONTRAINTE2, CONTRAINTE3,
CONTRAINTE4, CONTRAINTE5, DATE_CONSEIL, DEBUT_ENS, DECLA_VAC,
DECLA_VAC_INI, DPT1_VOL1, DPT1_VOL2, DPT2_CALCUL, DPT2_VOL1, DPT2_VOL2,
DPT3_CALCUL, DPT3_VOL1, DPT3_VOL2, DPT_ATTRIB, DPT_CHARGE, DPT_NUM_VAC,
DUREE, DUREE_ATTRIB, DUREE_MODIF, ETAT_PROPOSITION, FIN_ENS, GEST_EQP,
GESTIONNAIRE, INSTITUTION, INTIT_ABREGE, INTIT_COMP_ANGL,
INTIT_COMPLEMENT, INTIT_COMPLET, LANGUE, LIB_ACT_UNIV, LIEN_STRUCTURE,
LOCA_EFF, MAX_ETD, NOM_CONTACT, NOM_CONVENT, NOUV_CNUM, NOUV_SIGLE,
NOUV_SUBD, NUM_CONSEIL, NUM_DOS, NUM_VAC, PERIODICITE, POIDS,
PREN_CONTACT, PROC_EXCP, QUALIF_VOL, REM_AUTRE, REM_FAC, REM_FAC_ANGL,
SIGLE_DOS, SIGLE_ELE, SUBDIVISE, SUBDIVISION, TRADUC_ANGL, TYPE_ELE,
TYPE_PROPOSITION, TYPE_RGR, TYPE_STAGE, TYPE_VAC, UNIT_DUREE,
UNITE_PREST1, UNITE_PREST2, UNITE_PREST3, UNIV_GEST, UNIV_LIEU, VERROU,
VOL_HORPQ1, VOL_HORPQ2, VOL_HORPQ3, VOL_HORSQ1, VOL_HORSQ2, VOL_HORSQ3,
VOL_TOT1, VOL_TOT2, VOL_TOT3, CAMPUS_ID, LOCALISATION_ID FROM EPC_ELE
WHERE ((NUM_ELE = ?) AND (VALIDITE = ?))
bind => [54732, 2010]