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: 12.1   12.2   12.3   12.4   12.5   13.0   13.1   13.2   13.3   13.4    Statistic    FMM    Blog  

QuickList.JoinJSON

Joins text in a QuickList as JSON array.

Component Version macOS Windows Linux Server iOS SDK
List 13.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "QuickList.JoinJSON"; List )   More

Parameters

Parameter Description Example
List The reference to the quicklist. $List

Result

Returns text or error.

Description

Joins text in a QuickList as JSON array.
Values in the QuickList must be valid JSON.

See JSON.GetArrayItemsAsQuickList function to split JSON to a QuickList.

Examples

Try the function by adding three values:

Let([
list = MBS( "QuickList.New" );
r = MBS( "QuickList.AddValue"; list; "{\"id\": 1}" );
r = MBS( "QuickList.AddValue"; list; "{\"id\": 2}" );
r = MBS( "QuickList.AddValue"; list; "{\"id\": 3}" );
result = MBS( "QuickList.JoinJSON"; list );
r = MBS( "QuickList.Free"; list )
]; result)

Filter JSON items:

Set Variable [ $json ; Value: "[{\"id\": 1},{\"id\": 2},{\"id\": 3}]" ]
# turn into a list
Set Variable [ $list ; Value: MBS( "JSON.GetArrayItemsAsQuickList"; $json ) ]
#
# now loop over entries to filter
Set Variable [ $n ; Value: MBS( "QuickList.Count"; $list ) ]
If [ $n > 0 ]
    Loop
        # get next item
        Set Variable [ $n ; Value: $n - 1 ]
        Set Variable [ $item ; Value: MBS( "QuickList.GetValue"; $list; $n ) ]
        #
        # if meets criteria, then remove it
        If [ JSONGetElement ( $item ; "id" ) = 2 ]
            Set Variable [ $r ; Value: MBS( "QuickList.Remove"; $list; $n ) ]
        End If
        #
        # next
        Exit Loop If [ $n ≤ 0 ]
    End Loop
End If
#
Set Variable [ $json ; Value: MBS( "QuickList.JoinJSON"; $list ) ]
Show Custom Dialog [ "after filter" ; $json ]
#
Set Variable [ $r ; Value: MBS( "QuickList.Free"; $list) ]

See also

Release notes

Blog Entries

This function checks for a license.

Created 31st May 2023, last changed 19th July 2023


QuickList.InsertValue - QuickList.List

💬 Ask a question or report a problem