Radicore Forum: Transaction Patterns

Home » RADICORE development » Transaction Patterns » Tree structure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Tree structure [message #4657 is a reply to message #4656]

Sat, 28 February 2015 08:31

htManager
Messages: 435
Registered: May 2014

Senior Member

I suppose that the queries are generated in the _cm_getNodeData of the class file. I copied the code from the xample file and tried to change it. But I haven't much experience in generating SQL-queries, so that I suppose that I did something wrong. Especially because I have a primary key consisting of several fields. Here is my code, maybe you can see what I am doing wrong:

$this->sql_select = 'hallen_plaetze_nodes.node_id, '
. 'hallen_plaetze_nodes.hallen_plaetze_node_desc, '
. 'hallen_plaetze_nodes.hallen_plaetze_nodes_logo_fname, '
. 'hallen_plaetze_level.hallen_plaetze_level_seq, '
. 'COUNT(child.node_id) AS child_count';
$this->sql_from = 'hallen_plaetze_nodes '
. 'LEFT JOIN hallen_plaetze_level ON '
. '(hallen_plaetze_level.verbaende_art_id=hallen_plaetze_nodes .verbaende_art_id AND '
. 'hallen_plaetze_level.verbaende_kuerzel=hallen_plaetze_nodes .verbaende_kuerzel AND '
. 'hallen_plaetze_level.halle_no=hallen_plaetze_nodes.halle_no AND '
. 'hallen_plaetze_level.hallen_plaetze_level_id=hallen_plaetze _nodes.hallen_plaetze_level_id) '
. 'LEFT JOIN hallen_plaetze_nodes AS child ON (hallen_plaetze_nodes.node_id=child.node_id_snr) ';
$this->sql_where = '';
$this->sql_groupby = 'hallen_plaetze_nodes.node_id, '
. 'hallen_plaetze_nodes.hallen_plaetze_node_desc, '
. 'hallen_plaetze_nodes.hallen_plaetze_level_id, '
. 'hallen_plaetze_level.hallen_plaetze_level_seq';
$this->sql_having = '';
$this->sql_orderby = 'hallen_plaetze_nodes.hallen_plaetze_level_id,'
. 'hallen_plaetze_nodes.node_id';

Report message to a moderator

[Message index]

		Tree structure By: htManager on Sat, 05 July 2014 06:17
		Re: Tree structure By: AJM on Sun, 06 July 2014 04:40
		Re: Tree structure By: htManager on Mon, 07 July 2014 05:52
		Re: Tree structure By: htManager on Wed, 11 February 2015 11:05
		Re: Tree structure By: AJM on Thu, 12 February 2015 04:34
		Re: Tree structure By: htManager on Thu, 12 February 2015 08:31
		Re: Tree structure By: AJM on Fri, 13 February 2015 05:10
		Re: Tree structure By: htManager on Thu, 26 February 2015 09:12
		Re: Tree structure By: AJM on Sat, 28 February 2015 06:20
		Re: Tree structure By: htManager on Sat, 28 February 2015 08:31
		Re: Tree structure By: AJM on Sun, 01 March 2015 04:23
		Re: Tree structure By: htManager on Mon, 02 March 2015 04:44
		Re: Tree structure By: htManager on Thu, 23 April 2015 11:49
		Re: Tree structure By: AJM on Fri, 24 April 2015 04:07
		Re: Tree structure By: htManager on Mon, 04 May 2015 11:48
		Re: Tree structure By: AJM on Tue, 05 May 2015 04:30
		Re: Tree structure By: htManager on Mon, 01 June 2015 11:32
		Re: Tree structure By: AJM on Tue, 02 June 2015 05:12
		Re: Tree structure By: htManager on Tue, 02 June 2015 10:46
		Re: Tree structure By: AJM on Tue, 02 June 2015 13:05
		Re: Tree structure By: htManager on Mon, 11 January 2021 12:54
		Re: Tree structure By: AJM on Mon, 11 January 2021 13:50
		Re: Tree structure By: htManager on Mon, 11 January 2021 15:47
		Re: Tree structure By: htManager on Wed, 13 January 2021 04:10
		Re: Tree structure By: AJM on Wed, 13 January 2021 05:25
		Re: Tree structure By: htManager on Wed, 13 January 2021 06:13
		Re: Tree structure By: AJM on Thu, 14 January 2021 05:09
		Re: Tree structure By: htManager on Sat, 16 January 2021 03:43
		Re: Tree structure By: AJM on Sat, 16 January 2021 05:06
		Re: Tree structure By: htManager on Sun, 24 January 2021 14:57

Previous Topic:	List view (List3)
Next Topic:	POPUP3 not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Nov 25 05:11:59 EST 2024

Total time taken to generate the page: 0.01814 seconds