Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Am using tree view by using hierarchy function.Everything is coming up well.
But when I want to put it in list box everything turns out to be gray.Is there any specific reason for this?
Hi,
this script generates a list of all parent nodes paths:
i.e. each subpath of path 'A/A0/A00/A00001' is calculated and stored in a new field 'Path_Select' associated to the given field 'Path'.
Left(PATH,Index(PATH&'/','/',IterNo())-1)
extracts those subpaths beginning from the first character to the IterNo-th occurence of the delimiter '/'.
While IterNo()<=SubStringCount(PATH,'/')+1
iterates over each input row as often as the delimiter '/' is included in the path (+1).
hope this helps
regards
Marco