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 #1496 is a reply to message #1495]

Thu, 17 July 2008 15:49

AJM
Messages: 2350
Registered: April 2006
Location: Surrey, UK

Senior Member

bonzo_bcn wrote on Thu, 17 July 2008 20:15

By modifying the relationship I could retrieve only one date

Why only one date? If you set 'Parent Field' to 'CALCULATED' you can put as many field names as you like into 'Calculated Field'.

Quote:

would it be possible to remove from the read records the ones that don't meet the criteria player.birthdate between category.date1 and category.date2?

Yes. Simply iterate through the $rows variable and remove the ones you don't want. This might not be a good idea though as the number of rows displayed would not be the same as the number of rows retrieved, and this could mess up your pagination. If would be *FAR* better to do all the necessary filtering in the sql SELECT statement.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

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 May 16 16:08:17 EDT 2024

Total time taken to generate the page: 0.01154 seconds