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 #1501 is a reply to message #1486]

Fri, 18 July 2008 02:19

bonzo_bcn
Messages: 152
Registered: June 2008

Senior Member

this is being generated:
SELECT SQL_CALC_FOUND_ROWS equipo.equipo_id, participante.participante_id, participante.catsalut, participante.nombre, participante.apellido1, participante.apellido2, CASE WHEN part_equipo_xref.participante_id IS NULL THEN 'F' ELSE 'T' END AS selected
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_i d)
WHERE equipo.equipo_id='2' AND participante.participante_id IN (SELECT participante_id FROM part_ent_xref WHERE entidad_id=2) LIMIT 10 OFFSET 0 =>Count=1

and this should be generated

SELECT SQL_CALC_FOUND_ROWS equipo.equipo_id, categoria.fecini, categoria.fecfin, participante.participante_id, participante.catsalut, participante.nombre, participante.apellido1, participante.apellido2, CASE WHEN part_equipo_xref.participante_id IS NULL THEN 'F' ELSE 'T' END AS selected
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_i d)
LEFT JOIN categoria ON (categoria.categoria_id=equipo.categoria_id)
WHERE equipo.equipo_id='2' AND participante.participante_id IN (SELECT participante_id FROM part_ent_xref WHERE entidad_id=2) LIMIT 10 OFFSET 0 =>Count=1

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: Thu Nov 28 17:08:18 EST 2024

Total time taken to generate the page: 0.01116 seconds