GetFoundList ( field ; start ; result )

Returns the current set as a return delimited list. Uses tail recursion.

Average rating: 3.9 (12 votes) Log in to vote

Joshua Willing - Show more from this author
Willing Apps

Sample input:

GetFoundList ( table::id ; 1 ; "" )

Sample output:

1
2
4
6
8
9
7

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

/*
\\ GetFoundList ( field ; start ; result )
 \\
 // This function uses tail recursive
// 
\\
 \\ start should always be set to 1
 //
// result should always be set to ""
*/

//HISTORY : 
//    v1 - Created by Joshua Willing Halpern



Let ([
   ~value = GetNthRecord ( field ; start ) ;
   result = If ( start > 1 ; result &¶& ~value  ; ~value ) ;
   start = start + 1 
];

If ( start > Get ( FoundCount ) ; result ; GetFoundList ( field ; start ; result ) )

)

This function simply returns a return delimited list of the selected field values for the current found set. It is great for gathering a list of ids.

This function should handle found sets under 50,000 records as per Filemaker's recursion limit.

Feedback welcome, especially potential improvements.

Comments

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

GetFoundList ( field ; start ; result )

Comments

Support this website.

Support this website.