Radicore Forum: How To » How to filter by a parent field in a link1 transaction

Home » RADICORE » How To » How to filter by a parent field in a link1 transaction

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

Re: How to filter by a parent field in a link1 transaction [message #1503 is a reply to message #1486]

Fri, 18 July 2008 05:25

bonzo_bcn
Messages: 152
Registered: June 2008

Senior Member

I only added this code to test:

 $this->sql_select  = null;
 $this->sql_from    = null;
 $this->sql_groupby = null;
 $this->sql_having  = null;
 $this->sql_from    = $this->_sqlForeignJoin($this->sql_select, $this->sql_from, $this->parent_relations);

And it's generating a wrong FROM clause:

FROM equipo CROSS JOIN participante 
LEFT JOIN part_equipo_xref ON (equipo.equipo_id=part_equipo_xref.equipo_id AND participante.participante_id=part_equipo_xref.participante_id) 
[B]part_equipo_xref LEFT JOIN participante ON (participante.participante_id=part_equipo_xref.participante_id)[/B]

The code in bold wasn't included in the originally generated sql.

Report message to a moderator

[Message index]

		How to filter by a parent field in a link1 transaction By: bonzo_bcn on Wed, 16 July 2008 13:24
		Re: How to filter by a parent field in a link1 transaction By: AJM on Wed, 16 July 2008 14:57
		Re: How to filter by a parent field in a link1 transaction By: bonzo_bcn on Wed, 16 July 2008 15:21
		Re: How to filter by a parent field in a link1 transaction By: AJM on Wed, 16 July 2008 16:30
		Re: How to filter by a parent field in a link1 transaction By: bonzo_bcn on Thu, 17 July 2008 15:15
		Re: How to filter by a parent field in a link1 transaction By: AJM on Thu, 17 July 2008 15:49
		Re: How to filter by a parent field in a link1 transaction By: bonzo_bcn on Thu, 17 July 2008 15:58
		Re: How to filter by a parent field in a link1 transaction By: AJM on Thu, 17 July 2008 16:49
		Re: How to filter by a parent field in a link1 transaction By: bonzo_bcn on Thu, 17 July 2008 17:09
		Re: How to filter by a parent field in a link1 transaction By: AJM on Thu, 17 July 2008 18:10
		Re: How to filter by a parent field in a link1 transaction By: bonzo_bcn on Fri, 18 July 2008 02:19
		Re: How to filter by a parent field in a link1 transaction By: AJM on Fri, 18 July 2008 05:05
		Re: How to filter by a parent field in a link1 transaction By: bonzo_bcn on Fri, 18 July 2008 05:25
		Re: How to filter by a parent field in a link1 transaction By: AJM on Fri, 18 July 2008 06:07
		Re: How to filter by a parent field in a link1 transaction By: bonzo_bcn on Fri, 18 July 2008 06:17
		Re: How to filter by a parent field in a link1 transaction By: AJM on Fri, 18 July 2008 06:33

Previous Topic:	override noedit on foreign field in multi2
Next Topic:	How ro remove the 'page created in' message

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Nov 25 03:31:56 EST 2024

Total time taken to generate the page: 0.01101 seconds