...
Given the above CPS Path, the following SQL query is generated - note the use of sub-queries for each path component:
| Code Block | ||
|---|---|---|
| ||
SELECT
*
FROM
fragment
WHERE
parent_id IN (
SELECT
id
FROM
fragment
WHERE
xpath_component = 'categories[@code=''1'']'
AND parent_id = (
SELECT
id
FROM
fragment
` WHERE
xpath_component = 'bookstore'
AND anchor_id = 3
AND parent_id IS NULL
)
)
AND (
xpath_component = 'books'
OR xpath_component LIKE 'books[%'
)
AND (
attributes @> '{"title":"Matilda"}'
) |
...