Thanks, that is almost what I need. It narrows it down by leaps and bounds. What I really need is to get only the items for the nav menu that show on page load and any sub menu items that show on mouse hover and not anything that is in subfolders for those items.
I've tried a few variations on the where like
but those all give me errors.