get_full_chain.sql

WITH RECURSIVE 
r_back AS (
    SELECT fw.id, fw."previousWorkId"
    FROM "FieldWork" AS fw
    WHERE fw.id = 640

    UNION ALL

    SELECT fw.id, fw."previousWorkId"
    FROM "FieldWork" as fw
        JOIN r_back
            ON fw.id = r_back."previousWorkId"
),
r_forward AS (
    SELECT fw.id, fw."previousWorkId"
    FROM "FieldWork" AS fw
    WHERE fw.id = 640

    UNION ALL

    SELECT fw.id, fw."previousWorkId"
    FROM "FieldWork" as fw
        JOIN r_forward
            ON fw."previousWorkId" = r_forward.id
)
SELECT * FROM r_back
UNION
SELECT * FROM r_forward;