can't create hierarchicalDatasource

hsingh2680 · February 24, 2016, 2:57pm

I am using platform-6.0.8, when I tried to create hierarchicalDatasource for screen, it doesn’t let me select or enter hierarchical property,
structure of table is myHierachyTable(name varchar(55),parent varchar(55)). when I enter hierarchical property value as parent and change focus value become empty

gorbunkov · February 25, 2016, 6:00am

Hi!
The “parent” attribute must be an association, and its type must be a “myHierachyTable”.

hsingh2680 · February 26, 2016, 7:37pm

does that mean myHierachyTable(name varchar(25), parent ASSOCIATION ref myHierachyTable)) ??

in tree I will have root element which doesnt have parent so reference will be null and I was getting Exception because of that
how do I set reference the create screen doesn’t show option of selecting ref

gorbunkov · February 29, 2016, 7:53am

If the item has no parent, the parent reference is null. You have to handle these cases.
You have 2 options:

add a field for selecting a parent to your entity editor.
pass the parent value to the editor in Create action as described here