Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 10.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3   11.4    Statistic    FMM    Blog  

QuickList.GetList

Queries the list as text.

Component Version macOS Windows Linux Server iOS SDK
List 4.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "QuickList.GetList"; ListRef { ; NoReturnEnding; Delimiter } )   More

Parameters

Parameter Description Example Flags
ListRef The reference to the list returned from QuickList.New function. $List
NoReturnEnding Pass 1 to have no extra newline character on the end of the returned list. Default is 0 to include one to easily concat lists. 1 Optional
Delimiter The delimiter to use.
Can be empty to have no delimiter.
Common use is to pass "¶", ", " or "; ".
", " Optional

Result

Returns text or error.

Description

Queries the list as text.
Lines are separated by return character.

Examples

Create a list and query it:

$listID = MBS( "QuickList.New"; "Hello¶World")
$list = MBS( "QuickList.GetList"; $listID)
$r = MBS("QuickList.Free"; $listID)

Try with delimiter:

Set Variable [$listID; Value:MBS( "QuickList.New"; "Hello¶World")]
Set Variable [$list1; Value:MBS( "QuickList.GetList"; $listID)]
Show Custom Dialog ["Result default"; $list1]
Set Variable [$list2; Value:MBS( "QuickList.GetList"; $listID; 0; "")]
Show Custom Dialog ["Result with empty delimiter"; $list2]
Set Variable [$list3; Value:MBS( "QuickList.GetList"; $listID; 0; " ")]
Show Custom Dialog ["Result with space delimiter"; $list3]
Set Variable [$r; Value:MBS("QuickList.Free"; $listID)]

Build a 10000 entry List:

Let ( [
q = MBS("QuickList.New");
// add 10000 entries
t = While ( [ i = 0 ] ; i < 10000 ; [ i = i + 1; r = MBS( "QuickList.AddValue"; q; "test " & i ) ] ; 0 );
// get as text
r = MBS("QuickList.GetList"; q);
// free memory
f = MBS("QuickList.Free"; q)
];
Length(r) & ¶ & r )

See also

Example Databases

Blog Entries

FileMaker Magazin

Created 21st September 2014, last changed 20th June 2021


QuickList.GetColumn - QuickList.GetValue

Feedback: Report problem or ask question.




Links
MBS Xojo blog

Start Chat