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 - Show more from this author

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)

/*
GetRowsXMLMatch(fieldlist ; startRow; endrow; type; matchexpression; encodeFlag ) 
requires GetNthRecordXML custom function
creates XML data set for records matching criteria specified in matchexpression
Requires literal "thisRecord" as placeholder for N

Example:
GetRowsXMLMatch( "Members::FirstName¶Members::LastName¶Members::MemberID"; 1; 1000; "member"; 
"getNthRecord(Members::FirstName; thisrecord ) = \"Bruce\"";  0) 
 */

Let(
matchflag = Evaluate(Substitute(matchexpression; "thisrecord"; endRow))
 ;

Case( endRow >= startRow; 
List(GetRowsXMLMatch(fieldlist ; startRow; endRow -1; recordtype; matchexpression;  encodeFlag ); 

Case(matchFlag = 1;
"<" & recordtype & ">¶" & GetNthRecordXML ( fieldList ; Endrow; encodeFlag ) & "¶</" & recordtype & ">"
)
) 
)
)

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

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

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

Comments

Support this website.

Support this website.