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?
Thanks in advance!