fetch_item_related_tasks

prehnite_core::db::query

Function fetch_item_related_tasks 

Source 
pub async fn fetch_item_related_tasks(
    conn: &mut SqliteConnection,
    item_id: i64,
) -> Result<Vec<Task>, Error>
Expand description

アイテムに紐づいたタスクをアイテムidから取得します。

SELECT *
FROM view_deserializable_task
WHERE item_id = ?
ORDER BY task_pos NULLS LAST;