[FX.php List] Re: Limit number of returned Portal rows

[Kevin Becker]

@ Nick and Dan
1) I get the same results as Nick for a related field not in a portal. 
Only the first record gets returned.

@Nick
2) The possibility of using -relatedsets.filter (pg.99) and
-relatedsets.max (pg.100) is very promising.  But how do I incorporate
that into an FX.php query?  I tried this:

	$v -> AddDBParam("-relatedsets.max", 10);

but I get an error of 958 - Parameter missing in query.  Does FX support
this?  Will it someday?

Kevin Becker

Nick on Monday, May 12, 2008 at 10:30 PM -0500 wrote:
>Actually it is possible in two ways:
>  1) don't put the related fields in a portal and you only ever get the
>first related record.
>  2) use -relatedsets.filter to limit the amount of returned related
>records, a filemaker server 9 feature. see page ~90 in the pdf:
>http://www.filemaker.com/downloads/pdf/fms9_cwp_xslt_en.pdf