Post reply

generate XML document from hierarchical table data

  • April 13, 2011 at 10:37 am

    #1311175

    The code you provided did not work.

    Is debtMapping = codeMappingTable and codes = dept?

  • April 13, 2011 at 10:39 am

    #1311179

    Yes thats correct..apologies my bad...

  • April 13, 2011 at 11:04 am

    #1311189

    As I understand it (and already wrote in the top posting on this page btw) you need a way to determine if an entry is a group or person.

    Currently you have a hierarchy, like admins are all employees and so on. What you don't have is the information about the groups, except the name of the group a user is part of.

    I would add a bit-column "IsGroup" to the dept table and add entries for all groups.

    Because following your current logic, EMPLOYEE1 is subordinate to MANAGER, not the group of employees (codeGroup EMPLOYEE) subordinate to MANAGER.

    This way you can add an IF-clause to your function [GetPartsSubTree], that checks the IsGroup - column and puts the subordinate groups and / or persons below itself

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply