test_cycle_inner

Column Type
uniform_resource_id VARCHAR
test_cycle_id
title
description
created_by
created_at
last_updated_at
status
version
tags
content BLOB

SQL DDL

CREATE VIEW test_cycle_inner AS
SELECT
    uniform_resource_id,
    json_extract(frontmatter, '$.test_cycleId') AS test_cycle_id,
    json_extract(frontmatter, '$.title') AS title,
    json_extract(frontmatter, '$.description') AS description,
    json_extract(frontmatter, '$.created_by') AS created_by,
    json_extract(frontmatter, '$.created_at') AS created_at,
    json_extract(frontmatter, '$.last_updated_at') AS last_updated_at,
    json_extract(frontmatter, '$.status') AS status,
    json_extract(frontmatter, '$.version') AS version,
    json_extract(frontmatter, '$.tags') AS tags,
    content
FROM uniform_resource
WHERE 
    uri LIKE '%.cycle.md%'
;