• Hi! Chris Morris

    Thanx for reply

    region IdParentIdText

    a11wwer

    b11yrt

    c11ryrt

    a11a1eryrty

    b11b1nbnvnfth

    c11c1vc

    b111b11vbc

    a111a11cb

    c111c11bc

    result should be

    a11wwer

    b11yrt

    c11ryrt

    then all rest values sort order by parent id

    The major issues is this that the parent id is generated by Java Random method as string and it can be any thing

    but the first parent id is assign the manual

    i hope you got the issues ,

    waiting for ur reply

    Regards,

    Sanjay