Hi,
*Running version: orientdb-community-1.7-SNAPSHOT*
I know that SELECT of direct multiple targets are not supported but was
wondering if you have any hints on how to do the following type of query.
select expand($c)
let $a = (select in.value as DLABEL from samplelabels where out.value IN
(select in.value from samplerecs where out.value = "IN USE")),
$b = (select in.value as RCODE from samplerx where out.value IN
(select in.value from samplerecs where out.value = "IN USE")),
$c = union($a, $b)
I currently get:
----+-----+----------------------------------------+--------
# |@RID |DLABEL |RCODE
----+-----+----------------------------------------+--------
0 |#-2:1|ALBUTEROL 0.083% INH SOL PREMIXED--INH 2|null
1 |#-2:2|IBUPROFEN 100MG_5ML SUSP ($.30_120ML)--P|null
2 |#-2:3|AURALGAN*EQ* OTIC SOLN |null
3 |#-2:4|AUGMENTIN ES 600MG_5ML--PO 600MG_5ML SUS|null
4 |#-2:5|ACETAMINOPHEN--RECT 120MG SUPP |null
5 |#-2:1|null |H6351279
6 |#-2:2|null |H6351281
7 |#-2:3|null |H6351276
8 |#-2:4|null |H6351275
9 |#-2:5|null |H6351278
10 |#-2:0|null |null
----+-----+----------------------------------------+--------
But, am trying to find some way to get this footprint somehow:
----+-----+----------------------------------------+--------
# |@RID |DLABEL |RCODE
----+-----+----------------------------------------+--------
0 |#-2:1|ALBUTEROL 0.083% INH SOL PREMIXED--INH 2|H6351279
1 |#-2:2|IBUPROFEN 100MG_5ML SUSP ($.30_120ML)--P|H6351281
2 |#-2:3|AURALGAN*EQ* OTIC SOLN |H6351276
3 |#-2:4|AUGMENTIN ES 600MG_5ML--PO 600MG_5ML SUS|H6351275
4 |#-2:5|ACETAMINOPHEN--RECT 120MG SUPP |H6351278
----+-----+----------------------------------------+--------
p.s. I also know about the extra NULL record bug returned from union() .
Thanks for your help,
Tia
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
