Connexion Identifiant Mot de passe Créez votre compte Déposez votre dossier de candidature à la formation ASV Cliquez ici   www.apform.fr T : 0 805 390 022 - Nous contacter Siège : 10 place Léon Blum - 75011 Paris Siège administratif : 350, Avenue de la Lauzière - Parc du Golf - Bat 20 - 13290 AIX-EN-PROVENCE Toute correspondance doit être adressée au siège administratif

00000	21877174 : _EVA_FILTER_COND.1=.IdField=['_EVA_FORMSTAMP] AND .IdRelObj IN ([%CompteUtil]) AND .IdObj IN ([%Eleves],[%Dev]) AND .DateDel IS NULL
00001	21877174 : _EVA_FILTER_TYPE.1=_EVA_FILTER_SQLNODE
00002	21877174 : _EVA_FORMSTAMP.1=242
00003	21877174 : _EVA_LABEL.1=Utilisateurs test espace VAE V2
00004	21877174 : _EVA_SRC_FILTER.1.1=21858203
00005	21877174 : _EVA_VAR_EXPR.1.1=CONTRAT_ELEVE
00006	21877174 : _EVA_VAR_EXPR.1.2=<-_EVA_USERGROUP
00007	21877174 : _EVA_VAR_FMT.1.1=1
00008	21877174 : _EVA_VAR_FMT.1.2=1
00009	21877174 : _EVA_VAR_FMT.1.3=1
00010	21877174 : _EVA_VAR_LISTOBJ.1.2=2388
00011	21877174 : _EVA_VAR_LISTOBJ.1.3=98
00012	21877174 : _EVA_VAR_NAME.1.1=Eleves
00013	21877174 : _EVA_VAR_NAME.1.2=Dev
00014	21877174 : _EVA_VAR_NAME.1.3=CompteUtil
00015	21877174 : _EVA_VAR_SRC.1.1=_EVA_SRC_FILTER
00016	21877174 : _EVA_VAR_SRC.1.2=_EVA_LISTOBJ
00017	21877174 : _EVA_VAR_SRC.1.3=_EVA_LISTOBJ

00000	21858203 : _EVA_FILTER_TYPE.1=_EVA_FILTER_LISTOBJ
00001	21858203 : _EVA_FORMSTAMP.1=242
00002	21858203 : _EVA_LABEL.1=Contrats tests VAE
00003	21858203 : _EVA_LISTOBJ.1=21862653
00004	21858203 : _EVA_NOTES.1=Pour test des enquêtes

*** Filter : 1 nodes
srctable=*
[Contrats tests VAE]
 0:  ObjList (21862653)
 1:  0#0 

 100 : 0.000 s (Espace VAE V2)
-- DB/User/Form/Obj/Ctrl=gipsa/2442/435//21877183
SELECT DISTINCT TLink0.IdObj AS IdObj
FROM TLink AS TLink0 
WHERE TLink0.IdObj IN (21862653) AND TLink0.DateDel IS NULL 


 *** Result : 1 rows
0:	21862653                

 101 : 0.000 s (Espace VAE V2)
-- DB/User/Form/Obj/Ctrl=gipsa/2442/435//21877183
-- sql_id_values : [CONTRAT_ELEVE]
SELECT IdValue, TxtValue FROM TVal AS TVal0 WHERE TVal0.TxtValue ='CONTRAT_ELEVE'
 *** Result : 2 rows
0:	65543                   CONTRAT_ELEVE           
1:	3720488                 Contrat_eleve           

00000	21862653 : CONTRAT_ELEVE.1=4468120

*** Filter : 2 nodes
srctable=*
[<-_EVA_USERGROUP]
 0:  <RelReverse>
 1:  0#0 [_EVA_USERGROUP]
 2:  0#0 

 103 : 0.000 s (Espace VAE V2)
-- DB/User/Form/Obj/Ctrl=gipsa/2442/435//21877183
-- sql_get_listcol : read field data
SELECT DISTINCT TLink0.IdRelObj AS IdObj,(TLink0.IdObj) AS Val,TLink0.IdObj AS IdValObj,TLink0.Num AS Num,TLink0.Line AS Line
FROM TLink AS TLink0 
WHERE TLink0.IdRelObj IN (2388) 
AND TLink0.DateDel IS NULL 
 AND TLink0.IdField IN(6033) AND TLink0.DateDel IS NULL 

ORDER BY IdObj,IdValObj,Num,Line

 *** Result : 390 rows

00000	2388.10 : .1.1=10
00001	2388.242 : .1.1=242
00002	2388.1013 : .108=1013
00003	2388.2445 : .1.1=2445
00004	2388.4974 : .1.1=4974
00005	2388.4975 : .1.1=4975
00006	2388.29051 : .1=29051
00007	2388.29057 : .1.1=29057
00008	2388.29083 : .1.1=29083
00009	2388.29084 : .1.1=29084
00010	2388.29439 : .1.1=29439
00011	2388.29512 : .1.1=29512
00012	2388.29540 : .2.1=29540
00013	2388.30227 : .1.1=30227
00014	2388.30491 : .1.1=30491
00015	2388.32286 : .1.1=32286
00016	2388.34325 : .1.1=34325
00017	2388.39406 : .1.1=39406
00018	2388.43540 : .1.1=43540
00019	2388.46630 : .1.1=46630
00020	2388.50683 : .1.2=50683
00021	2388.54131 : .1.1=54131
00022	2388.57395 : .1.3=57395
00023	2388.57415 : .1.2=57415
00024	2388.57448 : .1.1=57448
00025	2388.57533 : .1.1=57533
00026	2388.57614 : .2.1=57614
00027	2388.57643 : .1.1=57643
00028	2388.57644 : .1.1=57644
00029	2388.93099 : .1.2=93099
00030	2388.93101 : .1.1=93101
00031	2388.93125 : .1.1=93125
00032	2388.93139 : .1.4=93139
00033	2388.93206 : .1.1=93206
00034	2388.93229 : .1.1=93229
00035	2388.93237 : .1.1=93237
00036	2388.93369 : .1.2=93369
00037	2388.93477 : .1.2=93477
00038	2388.94131 : .1.1=94131
00039	2388.94264 : .2.1=94264
00040	2388.94586 : .2.1=94586
00041	2388.98690 : .2.1=98690
00042	2388.98708 : .1.1=98708
00043	2388.98709 : .1.1=98709
00044	2388.98713 : .1.1=98713
00045	2388.99917 : .3.1=99917
00046	2388.100383 : .1.1=100383
00047	2388.103223 : .1.1=103223
00048	2388.105341 : .1.1=105341
00049	2388.105622 : .1.1=105622
00050	2388.105641 : .1.1=105641
00051	2388.106435 : .1.1=106435
...
00341	2388.20466883 : .1.1=20466883
00342	2388.20525704 : .1.1=20525704
00343	2388.20675862 : .16=20675862
00344	2388.20678308 : .30=20678308
00345	2388.20822033 : .1.1=20822033
00346	2388.20879848 : .1.1=20879848
00347	2388.20969796 : .1.1=20969796
00348	2388.20990994 : .1.1=20990994
00349	2388.21023704 : .1.1=21023704
00350	2388.21103854 : .1.1=21103854
00351	2388.21125958 : .1.1=21125958
00352	2388.21142537 : .1.1=21142537
00353	2388.21158269 : .1.1=21158269
00354	2388.21158300 : .2.1=21158300
00355	2388.21238845 : .1.1=21238845
00356	2388.21284592 : .1.1=21284592
00357	2388.21287610 : .23=21287610
00358	2388.21320685 : .1.1=21320685
00359	2388.21324983 : .1.1=21324983
00360	2388.21325023 : .1.1=21325023
00361	2388.21334454 : .1.1=21334454
00362	2388.21536119 : .1.1=21536119
00363	2388.21594664 : .1.1=21594664
00364	2388.21650370 : .1.1=21650370
00365	2388.21651119 : .1.1=21651119
00366	2388.21664208 : .1.1=21664208
00367	2388.21676597 : .24=21676597
00368	2388.21679842 : .1.1=21679842
00369	2388.21688555 : .1.1=21688555
00370	2388.21689987 : .1.1=21689987
00371	2388.21700903 : .1.1=21700903
00372	2388.21755605 : .1.1=21755605
00373	2388.21755656 : .1.1=21755656
00374	2388.21755675 : .1.1=21755675
00375	2388.21762475 : .1.1=21762475
00376	2388.21763901 : .1.1=21763901
00377	2388.21818099 : .1.1=21818099
00378	2388.21825134 : .1.1=21825134
00379	2388.21833437 : .1.1=21833437
00380	2388.21848031 : .1.1=21848031
00381	2388.21849540 : .1.1=21849540
00382	2388.21849564 : .1.1=21849564
00383	2388.21849570 : .1.1=21849570
00384	2388.21851996 : .1.1=21851996
00385	2388.21852000 : .1.1=21852000
00386	2388.21856813 : .1.1=21856813
00387	2388.21860094 : .1.1=21860094
00388	2388.21862635 : .1.1=21862635
00389	2388.21870504 : .1.1=21870504

*** Filter : 1 nodes
srctable=*
[Utilisateurs test espace VAE V2]
 0: .IdField=1 AND .IdRelObj IN (98) AND .IdObj IN (4468120,10,242,1013,2445,4974,4975,29051,29057,29083,29084,29439,29512,29540,30227,30491,32286,34325,39406,43540,46630,50683,54131,57395,57415,57448,57533,57614,57643,57644,93099,93101,93125,93139,93206,93229,93237,93369,93477,94131,94264,94586,98690,98708,98709,98713,99917,100383,103223,105341,105622,105641,106435,108954,110461,110530,110533,110536,110788,111899,112068,112584,112656,112743,120206,120207,122642,123797,133093,136495,136496,136761,136763,137046,137171,137177,139903,141168,141852,141853,142980,145599,145654,145655,149374,149439,150194,158403,158858,164405,165650,208119,210331,211062,220606,220956,240519,283392,308015,322208,330140,330142,330290,333518,351063,368940,369495,370641,371744,371930,375334,380463,380656,380680,380709,386560,387628,387657,388076,390303,392260,392385,393271,400668,407602,407819,411568,411947,427221,429086,429087,429088,429090,436171,447525,449288,450702,454591,454602,456539,456567,458422,465165,470850,477702,490661,493742,493951,494732,494845,495058,495654,495956,495962,495963,506908,506909,520166,520583,583787,595691,597544,613194,615444,628882,671436,674787,824078,940365,941405,960282,977110,1009229,1027880,1108842,1145521,1167720,1361983,1447075,1485363,1721195,1747673,1747681,1747683,1747690,1857644,1881719,1992345,1992351,2024546,2065200,2118642,2325477,2336728,2368266,2379312,2445114,2446237,2452177,2493314,2493317,2523791,2526777,2584236,2584270,2584275,2610604,2615179,2615417,2616378,2632089,2657391,2697877,2740745,2846704,2864247,2881887,2906257,3126928,3130627,3136466,3138519,3184466,3188598,3241608,3253408,3253484,3253609,3271532,3274410,3330331,3330332,3330352,3330354,3357762,3435469,3442034,3445790,3467854,3488433,3518706,3518711,3574549,3753578,3761019,3792968,3950113,3962539,4057878,4082814,4084832,4089577,4090116,4091507,4107337,4112017,4112286,4112514,4129103,4140066,4178010,4178049,4224744,4230866,4235735,4252000,4252003,4253162,4253163,4256037,4256174,4256348,4264054,4278397,4344177,4362680,4371354,4405677,4405797,4406449,4439779,4439801,4441222,4442322,4442614,4443735,4444263,4446026,4446042,4447623,4447730,4451704,4453705,4454640,4454985,4457504,4467599,4471820,4471839,4489426,4489506,4513295,4555181,4565102,4606304,4606976,4632277,4638282,4638465,4676158,4676170,4681507,4693141,4713085,4731913,4768476,4768668,4780961,4795271,4795306,4795324,4795328,4796345,4805620,4808025,4825661,4826777,4840538,4840546,4840564,4841367,4845960,4864411,4868028,4894277,4909383,20270145,20279539,20292692,20306417,20376134,20411809,20466883,20525704,20675862,20678308,20822033,20879848,20969796,20990994,21023704,21103854,21125958,21142537,21158269,21158300,21238845,21284592,21287610,21320685,21324983,21325023,21334454,21536119,21594664,21650370,21651119,21664208,21676597,21679842,21688555,21689987,21700903,21755605,21755656,21755675,21762475,21763901,21818099,21825134,21833437,21848031,21849540,21849564,21849570,21851996,21852000,21856813,21860094,21862635,21870504) AND .DateDel IS NULL
 1:  0#0 

 104 : 0.000 s (Espace VAE V2)
-- DB/User/Form/Obj/Ctrl=gipsa/2442/435//21877183
SELECT DISTINCT TLink0.IdObj AS IdObj
FROM TLink AS TLink0 
WHERE TLink0.IdField=1 AND TLink0.IdRelObj IN (98) AND TLink0.IdObj IN (4468120,10,242,1013,2445,4974,4975,29051,29057,29083,29084,29439,29512,29540,30227,30491,32286,34325,39406,43540,46630,50683,54131,57395,57415,57448,57533,57614,57643,57644,93099,93101,93125,93139,93206,93229,93237,93369,93477,94131,94264,94586,98690,98708,98709,98713,99917,100383,103223,105341,105622,105641,106435,108954,110461,110530,110533,110536,110788,111899,112068,112584,112656,112743,120206,120207,122642,123797,133093,136495,136496,136761,136763,137046,137171,137177,139903,141168,141852,141853,142980,145599,145654,145655,149374,149439,150194,158403,158858,164405,165650,208119,210331,211062,220606,220956,240519,283392,308015,322208,330140,330142,330290,333518,351063,368940,369495,370641,371744,371930,375334,380463,380656,380680,380709,386560,387628,387657,388076,390303,392260,392385,393271,400668,407602,407819,411568,411947,427221,429086,429087,429088,429090,436171,447525,449288,450702,454591,454602,456539,456567,458422,465165,470850,477702,490661,493742,493951,494732,494845,495058,495654,495956,495962,495963,506908,506909,520166,520583,583787,595691,597544,613194,615444,628882,671436,674787,824078,940365,941405,960282,977110,1009229,1027880,1108842,1145521,1167720,1361983,1447075,1485363,1721195,1747673,1747681,1747683,1747690,1857644,1881719,1992345,1992351,2024546,2065200,2118642,2325477,2336728,2368266,2379312,2445114,2446237,2452177,2493314,2493317,2523791,2526777,2584236,2584270,2584275,2610604,2615179,2615417,2616378,2632089,2657391,2697877,2740745,2846704,2864247,2881887,2906257,3126928,3130627,3136466,3138519,3184466,3188598,3241608,3253408,3253484,3253609,3271532,3274410,3330331,3330332,3330352,3330354,3357762,3435469,3442034,3445790,3467854,3488433,3518706,3518711,3574549,3753578,3761019,3792968,3950113,3962539,4057878,4082814,4084832,4089577,4090116,4091507,4107337,4112017,4112286,4112514,4129103,4140066,4178010,4178049,4224744,4230866,4235735,4252000,4252003,4253162,4253163,4256037,4256174,4256348,4264054,4278397,4344177,4362680,4371354,4405677,4405797,4406449,4439779,4439801,4441222,4442322,4442614,4443735,4444263,4446026,4446042,4447623,4447730,4451704,4453705,4454640,4454985,4457504,4467599,4471820,4471839,4489426,4489506,4513295,4555181,4565102,4606304,4606976,4632277,4638282,4638465,4676158,4676170,4681507,4693141,4713085,4731913,4768476,4768668,4780961,4795271,4795306,4795324,4795328,4796345,4805620,4808025,4825661,4826777,4840538,4840546,4840564,4841367,4845960,4864411,4868028,4894277,4909383,20270145,20279539,20292692,20306417,20376134,20411809,20466883,20525704,20675862,20678308,20822033,20879848,20969796,20990994,21023704,21103854,21125958,21142537,21158269,21158300,21238845,21284592,21287610,21320685,21324983,21325023,21334454,21536119,21594664,21650370,21651119,21664208,21676597,21679842,21688555,21689987,21700903,21755605,21755656,21755675,21762475,21763901,21818099,21825134,21833437,21848031,21849540,21849564,21849570,21851996,21852000,21856813,21860094,21862635,21870504) AND TLink0.DateDel IS NULL

 *** Result : 16 rows
0:	1013                    
1:	110788                  
2:	3488433                 
3:	3574549                 
4:	3753578                 
5:	4129103                 
6:	4178010                 
7:	4178049                 
8:	4224744                 
9:	4230866                 
10:	4264054                 
11:	4468120                 
12:	20675862                
13:	20678308                
14:	21287610                
15:	21676597                

 105 : 0.001 s (Espace VAE V2)
-- DB/User/Form/Obj/Ctrl=gipsa/2442/435//21877183
SELECT IF(2442 IN (1013,110788,3488433,3574549,3753578,4129103,4178010,4178049,4224744,4230866,4264054,4468120,20675862,20678308,21287610,21676597),1,0)
 *** Result : 1 rows
0:	0                       

 116 : 0.000 s (Espace VAE V2)
-- DB/User/Form/Obj/Ctrl=gipsa/2442/435//21877183
SELECT IF(2442 IN (1013,110788,3488433,3574549,3753578,4129103,4178010,4178049,4224744,4230866,4264054,4468120,20675862,20678308,21287610,21676597),1,0)
 *** Result : 1 rows
0:	0