I am trying to manage a data dictionary and generate XSD (XML schema definition) as part of managing API definitions in our project.
However, I keep getting blocked by this error.
Here is an example base (I stripped down all columns that are not relevant to the XSD generation):
The formula for column XMLElementDef of table Attribute should be: IF(IsPrimitive, "<xs:element name=\"" & Name & "\" type=\"xs:" & DataType & "\"/>", DataTypeXMLElementDef)
but the else part of the IF - DataTypeXMLElementDef - cuases the circular reference error.
Recursive structures are necessary to many of my bases because many of the data I am managing is naturally hierarchical in nature (XML, JSON, folder/directory paths, org structures, etc).
I understand that endless recursion can kill the platform but I would suggest that the limitation should be done at runtime and detect a maximum # of levels of depth before giving out an error. Otherwise, this tool becomes severely limited for some applications.
Does anyone know of any workaround in the meantime?
The column Manager is a link to the same table (Employee).
The column ManagerPath is a lookup to the Manager link’s Path column.
The Path and ManagerPath columns are empty because I cannot enter the correct formula for Path because of the “circular reference” error.
The formula for the Path column should be: IF(Manager != "", ManagerPath & "->", "") & Name
Given the above formula, the values of Path and ManagerPath would have been:
I think this should be a valid scenario and that the recursion should be allowed (up to a pre-defined limit of levels to prevent endless recursion/loop).
Can anybody help?