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
Returns rows as JSON array.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
Matrix | 9.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example | Flags |
---|---|---|---|
MatrixRef | The matrix reference number. | $matrix | |
FieldNames | A list of field names for the JSON. | "Model¶Names" | |
Flags | The flags for the json creation. Pass 1 to get all values as text. Pass 2 to get all dates, times and timestamps in SQL format. |
1+2 | Optional |
Returns JSON text or error.
Query matrix as JSON:
# Matrix as JSON object
Set Variable [ $JSON ; Value: MBS( "Matrix.JSONRecords"; $result; "a¶b¶c" ) ]
Show Custom Dialog [ "Matrix as JSON" ; $JSON ]
Created 8th April 2019, last changed 17th December 2019
Matrix.JSONRecord - Matrix.Max
Feedback: Report problem or ask question.