Bug in PALO_ELEMENT_LIST_CHILDREN

    Bug in PALO_ELEMENT_LIST_CHILDREN

    Using Jedox 4 SR1

    PALO_ELEMENT_LIST_CHILDREN returns - Element Name, Element Level, Element Type

    Also size of the array is unpredictable if Bird has 25 children then Count() of array could be <25.

    Workaround I used was PALO_ELEMENT_LIST_DESCENDANTS which works fine, but if I have complex hierarchies then I need PALO_ELEMENT_LIST_CHILDREN to work :)

    If my first element is "Dodo"

    It will return array[0] = "Dodo",array[1]=1,array[2]=numeric

    $province_array = application()->PALO_ELEMENT_LIST_CHILDREN("localhost/xxxxx","Province","Total China");

    $i=1;

    foreach($province_array as $element)

    {

    $myrange = 'F'.$i;

    activesheet()->range($myrange)->value = $province_array[$element];

    $i++;

    }



    Best regards,

    Noel.