← Prev in month
← Prev in thread
Next in thread →
Next in month →
Examples of data query
Please check the following examples of data query
in accordance with our XML specification.
$B%/%(%j$N;EMM$r8!F$$9$k$K$"$?$C$F!"$$$/$D$+$N(B
$B%5%s%W%k$r=q$$$F$_$^$7$?!#(B
Items that produce item A01
$BIJL\#A#0#1$r@8@.$9$k:n6H$rNs5s$;$h!#(B
<operation name="#query">
<produce item="A01"/>
</operation>
Lots that belong to item A01 or A02
$BIJL\#A#1$^$?$O#A#0#2$N%m%C%H$rNs5s$;$h!#(B
<lot name="#query" item="A01"/>
<lot name="#query" item="A02"/>
Operations that assign both resource R1 and R2
$B;q8;#R#1$H#R#2$rN>J};HMQ$9$k:n6H$rNs5s$;$h!#(B
<operation name="#query">
<assign resource="R01"/>
<assign resource="R32"/>
</operation>
Items that have a stock in a range less than or
equal to 100
$B:_8KNL$,#1#0#00J2<$NIJL\$rNs5s$;$h!#(B
<item name="#query">
<stock><qty><max value="100"/></qty></stock>
</item>
Items that the stock will be less than or equal
to 100 at 9:00 in the tomorrow morning.
$B:_8KNL$,L@F|$ND+#9!'#0#0$K#1#0#00J2<$H$J$k(B
$BIJL\$rNs5s$;$h!#(B
<item name="#query">
<stock><time value="2004-06-20T00:09:00"/>
<qty><max value="100"/></qty></stock>
</item>
Items that have a spec named "brand new"
$B;EMM$H$7$F?7@=IJ$r;}$C$F$$$kIJL\$rNs5s$;$h!#(B
<item name="#query">
<spec name="brand new"/>
</item>
Items that weight is lighter than or equal to 20kg
$B;EMM$H$7$F=E$5$,#2#0#g0J2<$NIJL\$rNs5s$;$h!#(B
<item name="#query">
<spec name="weight">
<qty><max value="20"/></qty></spec>
</item>
Items that belong to group01 and the color is
yellow or red.
$B%0%k!<%W#0#1$KB0$7$F$$$kIJL\$G!"2+?'$^$?$O@V$NIJL\(B
$B$rNs5s$;$h!#(B
<item name="#query" parent="group01">
<spec name="color">
<char><enumerate value="yellow"/>
<enumerate value="red"/></char>
</spec>
</item>
Orders of the customer K01 having duedate in June 20th
$B8\5R#K#0#1$N%*!<%@$GL@F|(B(6/20)$BG<4|$N$b$N$rNs5s$;$h!#(B
<order name="#query" customer="K01">
<duetime><earliest value="2004-06-20T00:00:00"/>
<latest value="2004-06-21T00:00:00"/></duetime>
</order>
--
Yasu Nissy (Yasuyuki NISHIOKA), Dr.Eng.
MIT, 41-211
77 Massachusetts Ave
Cambridge MA 02139
Phone 617-452-2982, Fax 617-253-2249
<>
← Prev in month
← Prev in thread
Next in thread →
Next in month →