Page History
...
But not run it as grid but as JSON.
This will show the properties field in a JSON format in most browsers.
Once you know what is in the object you can also retrieve individual elements from it. To get an individual column from the object use the "->>" operator:
Code Block | ||
---|---|---|
| ||
SELECTSELECT library_properties ->> 'size' AS lib_size FROM cqx_data.file_library |
...