Dear Monks,
I am having difficulty in building a looping construct to take an initial element and perform a database lookup of its sub-elements which can contain sub-elements which results in the need to then perform additional lookups of one or more elements which again may contain more sub-elements which again may require an additional lookups of sub-elements until the sub-elements can no longer be sub-divided. Then all the while collecting the lowest common denominator of the elements called DEVICES and storing in a single array to be returned as a result.
Here is a look the best I can represent of what the data could look like. I am using psuedo-data to represent what I am trying to accomplish.
There are three types of data. Group, User, Device.
So the top level is a Group which can contain any of the data types described above. 

GROUP1 contains GROUP2, DEVICE1, DEVICE2, DEVICE3

GROUP2 contains GROUP3, GROUP4, DEVICE4, DEVICE5, USER1

GROUP3 contains GROUP5, USER2, DEVICE6, DEVICE7

GROUP4 contains DEVICE8, DEVICE9, USER2

USER1 contains DEVICE10, DEVICE11, DEVICE12

GROUP5 contains DEVICE13, DEVICE14

USER2 conatins DEVICE15, DEVICE16, DEVICE17

[download]

And my results would be DEVICE1 ... DEVICE17

So the initial query is to GROUP1 which contains a sub-group and 3 devices. So I store the 3 devices and then I need to process GROUP2 which contains 2 sub-groups, 2 devices and a user. Then I store those 2 devices in the original array and then process GROUP3, GROUP4 and USER1 to extract their devices which I again store in the device array and so on until I can't break down any sub-elements further. The problem I am having is understand the logic construct that needs to be used to extract devices from the initial group and then sub-group and/or users embedded as members of the subsequent elements extracted. The sub-elements could contain many layers of sub-groups after sub-groups and this is where I am having trouble understanding how I would build the logic. I can code most of it but I am really having trouble grasping the deeper logic to continue to process sub-tree after sub-tree without writing the results to files and then reading them after I have exhuasted the sub-trees to the LCD.

If I just had an example to see I think the light would go on! But I keep hitting a deadend trying to build the logic in my mind.
Any and all suggestions would be greatly appreciated.
Thanks in advance for your help,
Danny

In reply to Unknown levels of sub-element extraction by onegative

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.