Radicore Forum - RDF feed
https://forum.radicore.org/index.php
Re: Tree structure with more than one table
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7738&th=3507#msg_7738
If you want you could use your LEAF table as just a stepping stone and have another table acting as a CHILD-LEAF, with multiple rows if necessary, and then in a third application table you could have a foreign key into CHILD-LEAF instead of LEAF.
You still have not provided me with a pictorial example of what structure you are trying to achieve, so I cannot provide a definitive solution. ]]>AJM2022-06-03T08:49:38-00:00Re: Tree structure with more than one table
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7736&th=3507#msg_7736
But I think that if this should work, you have to identify the table first and then the node of this table, to attach this node in the tree structure. But in your flexible tree structure isn't a 'table' column. Question: would this work? and would that be feasible? Or am I wrong and do not understand right how to solve such a problem?]]>htManager2022-06-03T08:17:16-00:00Re: Tree structure with more than one table
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7734&th=3507#msg_7734
Have you thought about adding another TREE-TYPE as this can give you another set of nodes. It is possible for a LEAF entity to be attached to nodes from multiple TREE-TYPEs.]]>AJM2022-06-02T09:02:49-00:00Re: Tree structure with more than one table
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7733&th=3507#msg_7733
htManager2022-06-01T09:40:02-00:00Re: Tree structure with more than one table
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7732&th=3507#msg_7732
A Flexible Tree Structure identifies 3 tables - TREE-TYPE, TREE-LEVEL and TREE-NODE. Why is this not enough for your needs?]]>AJM2022-06-01T09:01:14-00:00Tree structure with more than one table
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7731&th=3507#msg_7731
I ask because I would like to map a structure with organizations, clubs, seasons, teams and team members. However, the data of the respective tables are stored in different tables. The tables can be linked to each other using the primary keys.
Is there a way to achieve this in _cm_getNodeData()?]]>htManager2022-05-31T07:57:01-00:00Re: Using fillcolour in an output3 pattern
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7724&th=3505#msg_7724
AJM2022-05-12T08:27:54-00:00Using fillcolour in an output3 pattern
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7723&th=3505#msg_7723
htManager2022-05-11T21:30:24-00:00Re: Output 3 - _cm_output_multi()
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7670&th=3491#msg_7670
How to extend the SQL SELECT statement as well as How to manually extend the automatically extended SQL SELECT statement.]]>AJM2021-10-27T08:37:53-00:00Re: Output 3 - _cm_output_multi()
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7669&th=3491#msg_7669
This time I succeeded by storing the needed values in $GLOBALS in the _cm_initialise() method for the report title and querying the body occurences in the _cm_output_multi() method with some of these stored values too. The construction of the JOIN's of all tables was too complex for me at the moment. Maybe with the next challenge... ]]>htManager2021-10-26T10:29:11-00:00