Brian Dunning's FileMaker Custom Functions

GetRowsXMLMatch ( fieldlist ; startRow ; endrow ; type ; matchexpression ; encodeF

Get records in XML format for records meeting match criteria

  Average rating: 4.0 (38 votes) Log in to vote

Bruce Robertson   Bruce Robertson

Share on Facebook Share on Twitter

  Sample input:
GetRowsXMLMatch( "Members::FirstName¶Members::LastName¶Members::MemberID"; 1; 1000; "member"; "getNthRecord(Members::FirstName; thisrecord ) = \"Bruce\""; ""; 0)
  Sample output:
<member>
<Members::FirstName>Bruce</Members::FirstName>
<Members::LastName>Smith</Members::LastName>
<Members::MemberID>2393</Members::MemberID>
</member>
<member>
<Members::FirstName>Bruce</Members::FirstName>
<Members::LastName>Jones</Members::LastName>
<Members::MemberID>2922</Members::MemberID>
</member>
<member>
<Members::FirstName>Bruce</Members::FirstName>
<Members::LastName>Johnson</Members::LastName>
<Members::MemberID>324</Members::MemberID>
</member>

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Get records in XML format where a record attribute meets a match expression. Match criteria typically expressed in getNthRecord format. Requires literal "thisRecord" as placeholder for N; see example. Requires GetNthRecordXML custom function.

MODIFIED: 4/18/2007 - big speed improvement.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.