<span style="font-family:courier new,monospace"><span style="font-family:arial,helvetica,sans-serif">You wouldn't be able to query just the AutoManufacturer record though.</span><br style="font-family:arial,helvetica,sans-serif">
<br style="font-family:arial,helvetica,sans-serif"><span style="font-family:arial,helvetica,sans-serif">You'd need to perform a join across tables, e.g.:-</span><br style="font-family:arial,helvetica,sans-serif"><br>when</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace"> $p: Part( partVendor == "PV999999" )</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace"> $m: Model( partsList contains $p )<br>
$b: Brand( brandModels contains $m )</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace"> $a : AutoManufacturer( brandsCollection contains $b )</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">then</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace"> System.out.println( $p + ", " + $m + ", " + $b + ", " + $a );</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">end</span><br style="font-family:courier new,monospace"><br><div class="gmail_quote">On 2 May 2012 19:04, James K <span dir="ltr"><<a href="mailto:james_kosa@verizon.net" target="_blank">james_kosa@verizon.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Luane - Yes, it would be a normalized database, there would be only one entry<br>
for a manufacturer with all of the child records related by Foreign Keys or<br>
relational tables.<br>
<br>
Excuse my ignorance I am relatively new to Drools, can you please expand on<br>
the following:<br>
<br>
"...(...$p.getPartsName()...) "<br>
<br>
This is where I am having a hard time on how to navigate into the nested<br>
collections. Or are you saying to insert the PART, MODEL, BRAND, etc as<br>
individual facts? How would I relate it back Automanufacturer fact?<br>
<br>
<br>
--<br>
View this message in context: <a href="http://drools.46999.n3.nabble.com/Accessing-properties-of-an-object-within-a-Nested-Collection-of-a-Nested-Collection-tp3955591p3956880.html" target="_blank">http://drools.46999.n3.nabble.com/Accessing-properties-of-an-object-within-a-Nested-Collection-of-a-Nested-Collection-tp3955591p3956880.html</a><br>
<div class="HOEnZb"><div class="h5">Sent from the Drools: User forum mailing list archive at Nabble.com.<br>
_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</div></div></blockquote></div><br>