Page History

...

Example: In the data array of the folio_users.user table (screenshot below), the field 'active' (a boolean value showing patron status) is a "first level" hierarchical field. Other first-level fields include: id, barcode, metadata, personal, proxyFor, username, createdDate, departments, patronGroup, updatedDate and externalSystemId.

You will see that some of the first-level fields have subordinate data in second-levels fields ("metadata" and "personal" fields have subordinate fields). The following query will get the data out of first-level fields, when those fields don't have subordinate fields:

...