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

[Chris Hansen]

Hey list, sorry not to respond to list earlier...

This is a bug in FMS which I have reported to them.  In earlier  
versions of FileMaker, the data returned respected your settings for a  
given portal -- a portal which only displayed 6 rows, only returned 6  
rows, and a vertical scroll bar caused all portal records to be  
returned.  Now, FileMaker has added parameters so that you can specify  
the behavior, except they don't work with the FMPXMLRESULT grammar  
(ironic, since this grammar is in place for situations where a less  
verbose response is preferred.)

That said, once this bug is fixed, it will work exactly as Kevin  
attempted to use it below.  In addition, I think it would make sense  
to add functions to FX.php so that you don't have to remember that  
FileMaker syntax...

Finally, if you look FileMaker's XML documentation, you'll note  
they've added support now for combining logical AND and OR in a single  
query via XML!  Woot!  I haven't had a chance yet to test if this is  
broken, too.  Anybody excited enough to try this out and report back?

Best,

--Chris Hansen
   FileMaker 8 Certified Developer
   FileMaker 7 Certified Developer
   Creator of FX.php
   "The best way from FileMaker to the Web."
   www.iViking.org

On May 13, 2008, at 9:51 AM, Kevin Becker wrote:
> @ 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
>
>
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>