Hi,
I have a table that contains a hierarchy of nodes.
The foreign key over here refers to the parent node ID and references the primary key of the same table.
My display key in this table will represent the node's hierachy. (i.e. it's parent, grandparent if any)
I am looking to generate the display key of the node. So far I'm able to build it manually via qaction with recursion.
I'm wondering if this is possible in xml via enhanced naming? I tried this and it seems like the foreign key lookup to generate the display key does not happen recursively.
Hi,
I believe the approach you already found of doing it via QAction should be the ideal one as the options available on the XML of Naming and NamingFormat focus primarily on a simple and easy-to-do configuration.
Those do support fetching data from columns linked by a foreign key. However, I am unaware of any syntax that would let you define a recursive column as columns of the current table are interpreted as belonging to the current row and not to a foreign key.