We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Serialise a database table or object into XML, JSON, or AMSX text format
Reads rows from the specified table, applies optional field selection and row filtering, then serialises the result to the chosen format. The serialised string is stored in the result buffer. Name-value pairs from argument 3 onward act as WHERE clause equality filters.
| Parameter | Description |
|---|---|
| cmd | table or object name to serialise |
| Argument 0 | output format: XML, JSON, or AMSX |
| Argument 1 | comma-separated list of field names to include, or blank for all fields |
| Argument 2 | true to omit fields with empty values from the output (default true) |
| Argument 3 | first filter field name, followed by its value, then further name/value pairs |
Serialize "table or object name to serialise", "output format: XML, JSON, or AMSX", "comma-separated list of field names to include, or blank for all fields", "true to omit fields with empty values from the output (default true)", "first filter field name, followed by its value, then further name/value pairs"