Untitled

 avatar
user_6688396
plain_text
6 months ago
621 B
2
Indexable
Never
SELECT
          wok."formValues",
          wok.description,
          wit."personalFormsId",
          wok.id AS "workItemId",
          wit.id AS "itemTypeId",
          wit.board_belonging AS "boardId"
        FROM
          work_items wok
        
        INNER JOIN work_item_types wit
        ON wok."itemTypeId" = wit.id
        
        INNER JOIN personal_forms psf
        ON wit."personalFormsId" = psf.id
        
        WHERE wok."formValues" IS NOT NULL
        AND wok.deleted = false
        AND wit.deleted = false
        AND wok.id = 15207

        ORDER BY
          wok.id ASC