Hello:
Two quick questions. Do the DataFieldID and DataFieldParentID have to be numeric (like an integer data type)? It doesn't seem to work if I have those fields as strings. I'm trying to generate an org chart, using a string-based employee ID, but it comes up blank.
Second, to make it work, I converted the ID to an integer for the two fields. It then works fine, but I noticed that I have to set the "root" item to have a "0" for the parent field. Is this expected? As an example, I want to generate an Org with me at the top. In the dataset, the row that represents me has a parent employee ID, but that employee ID is not present in the data since I don't want my supervisor displayed. In order to get the chart to render, I have to look through the records and ensure that my record as "0" for the parent.
Perhaps this second issue is related to the first. If a string is in fact supported, does the top level item need to have the parent field set to a particular value? Perhaps an empty string?
Thanks,
Chris
Two quick questions. Do the DataFieldID and DataFieldParentID have to be numeric (like an integer data type)? It doesn't seem to work if I have those fields as strings. I'm trying to generate an org chart, using a string-based employee ID, but it comes up blank.
Second, to make it work, I converted the ID to an integer for the two fields. It then works fine, but I noticed that I have to set the "root" item to have a "0" for the parent field. Is this expected? As an example, I want to generate an Org with me at the top. In the dataset, the row that represents me has a parent employee ID, but that employee ID is not present in the data since I don't want my supervisor displayed. In order to get the chart to render, I have to look through the records and ensure that my record as "0" for the parent.
Perhaps this second issue is related to the first. If a string is in fact supported, does the top level item need to have the parent field set to a particular value? Perhaps an empty string?
Thanks,
Chris