$B$*@$OC$K$J$C$F$*$j$^$9!#(B<br>$B>.C+$G$9!#(B<br><br>$B;R%F!<%V%k0J2<$N9`L\$KBP$7$F>r7o@_Dj$d(Border by$B$r;H$$$?$$>l9g$K$D$$$F$N(B<br>$B<ALd$,$"$j$^$9!#(B<br><br>$B;R%F!<%V%k$N9`L\$r;H$C$F(Border by$B$r;HMQ$9$k$3$H$O2DG=$G$7$g$&$+!)(B<br><br>$B%P!<%8%g%s$O!"$^$@(B0.4.6$B$r;H$C$F$7$^$C$F$$$^$9!#(B<br>$B!J0JA0<ALd$5$;$F$$$?$@$$$?$H$-$K:G?7$N(BSNAPSHOT$B$rMQ0U$7$F$$$?$@$$$F$$$?$N$G$9$,!"(B<br>$B$^$@0\9T$7$F$*$j$^$;$s!#?=$7Lu$"$j$^$;$s!#!K(B
<br><br>$B8=:_$d$m$&$H$7$F$$$k$3$H$H$7$F!"(B<br>DBFlute$B$N(BConditionBean,ConditionQuery$B$r;H$C$F(B<br>$B;R%F!<%V%k$N9`L\$r>r7o$H$7$?8!:w=hM}$r9T$J$$$?$$$H9M$($F$*$j$^$9!#(B<br><br>$B$=$3$G%=!<%9%3!<%I$r2<5-$N$h$&$K=q$$$F$_$^$7$?!#(B<br>$B0J2<$N>r7o!"%=!<%H$r@_Dj$7!"8!:w7k2L$r<hF@$7$h$&$H$7$F$$$^$9!#(B<br>$B!&B9%F!<%V%k#1$N(BVALUE$B$H$$$&Ns$,!V(Baiueo$B!W(B<br>$B!&;R%F!<%V%k$N(BAAA_DATETIME$BNs$,(B2000/1/1 09:00:00$B!A(B2000/2/2 09:30:00
<br>$B!&B9%F!<%V%k#2$N(BVERSION_NO$B>:=g!";R%F!<%V%k$N(BDISPLARY_ORDER$B$N>:=g$G%=!<%H(B<br><br>// ## Arrange ##<br> FromToOption opt = new FromToOption();<br> HogeGrandChild1CB grandChildCB1 = new HogeGrandChild1CB ();<br> grandChildCB1.query
().setValue_Equal("aiueo");<br> HogeGrandChild2CB grandChildCB2 = new HogeGrandChild2CB ();<br> grandChildCB2.query().addOrderBy_VersionNo_Asc();<br><br> HogeChildCB childCB = new HogeChildCB ();
<br> <br> childCB.query().setAaaDatetime_FromTo(<br> Timestamp.valueOf("2000-01-01 09:00:00"), Timestamp.valueOf("2000-02-02 09:30:00"), opt);<br> childCB.query().addOrderBy_DisplayOrder_Asc();
<br> childCB.query().setUid_InScopeSubQuery_HogeGrandChild1List(grandChild1CB.query());<br> childCB.query().setUid_InScopeSubQuery_HogeGrandChild2List(grandChild2CB.query());<br> <br> HogeCB hogeCB = new HogeCB();
<br> hogeCB.query().setUid_InScopeSubQuery_HogeChildList(childCB.query());<br> <br> // ## Act ##<br> List<Hoge> resultList = hogeBhv.delegateSelectList(hogeCB);<br><br>$B<B9T$7$F$_$?$H$3$m0J2<$N$h$&$J(BSQL$B$,=PNO$5$l$^$7$?!#(B
<br>select $B!J>JN,!K(B<br>from hoge <br>where hoge.uid in (<br> select ($B>JN,(B) <br> from hoge_child <br> where hoge_child.apply_datetime >= '2000-01-01 09.00.00' <br> and hoge_child.apply_datetime <= '2000-02-02
09.30.00' <br> and hoge_child.uid in (<br> select ($B>JN,(B)<br> from hoge_grand_child1<br> where hoge_grand_child1.value = 'aiueo') <br> and hogeChild.uid in (<br> select ($B>JN,(B) <br> from hoge_grand_child2 )
<br> )<br><br>$B;XDj$7$?(Border by$B6g$,=PNO$5$l$F$$$J$$$h$&$G$7$?!#(B<br><br>$B$=$b$=$b(BConditionBean$B$N@_Dj$N;EJ}$O@5$7$$$N$+!"$H$$$&E@$H(B<br>$B;R%F!<%V%k0J2<$N9`L\$r;H$C$?(Border by$B$O2DG=$J$N$+!"$H$$$&E@$K$D$$$F(B<br>$B$*65$($$$?$@$1$?$i$H;W$$$^$9!#(B<br><br>$B$h$m$7$/$*4j$$CW$7$^$9!#(B<br><br>=========================================<br>
$B>.C+!!7=(B<br><a href="mailto:keikotani926@gmail.com">keikotani926@gmail.com</a><br>=========================================<br>