Error rendering macro 'rw-search'

null

Downloads

Versions Compared

Old Version 5

changes.mady.by.user lukas thoma

Saved on

compared with

New Version 6

changes.mady.by.user lukas thoma

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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
languagesql
 SELECTSELECT 
library_properties ->> 'size' AS lib_size
FROM 
cqx_data.file_library

...