11 concat(cmHandles.xpath, '/state') AS xpath,
14 '{"cm-handle-state": "READY", "last-update-time": "',
17 'YYYY-MM-DD"T"HH24:MI:SS.MSTZHTZM'
19 '", "data-sync-enabled": false}'
24 cmHandles.dataspace_id,
25 cmHandles.schema_node_id
37 xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]$'
43 '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]'
48 xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state$'
61 concat(cmHandlesStates.xpath, '/datastores'),
62 to_jsonb('{}' :: json),
63 cmHandlesStates.anchor_id,
65 cmHandlesStates.dataspace_id,
66 cmHandlesStates.schema_node_id
78 xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state$'
84 '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state'
89 xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/datastores$'
103 cmHandlesDatastores.xpath,
107 concat('{"sync-state": "NONE_REQUESTED"}') :: json
109 cmHandlesDatastores.anchor_id,
110 cmHandlesDatastores.id,
111 cmHandlesDatastores.dataspace_id,
112 cmHandlesDatastores.schema_node_id
124 xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/datastores$'
130 '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/datastores'
135 xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/datastores/operational$'
137 ) AS cmHandlesDatastores;