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
Queries array values as QuickList.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
JSON | 13.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example |
---|---|---|
json | A JSON text or reference. | "[{\"key\": 1}]" |
Returns quicklist refernece number or error.
Try the function:
Let([
list = MBS( "JSON.GetArrayItemsAsQuickList"; "[{\"id\": 1},{\"id\": 2},{\"id\": 3}]" );
text = MBS( "QuickList.GetList"; list );
r = MBS( "QuickList.Free"; list )
]; text)
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) ]
This function checks for a license.
Created 31st May 2023, last changed 31st May 2023