Fetch child data without fetching relation ids first #10

New issue

Closed

opened 2022-12-20 18:23:38 +01:00 by Dutch · 0 comments

Dutch commented

2022-12-20 18:23:38 +01:00

Owner

It should be possible to fetch child data in a single query, without the need to fetch the ids first.

SQL command would be:

SELECT * FROM kind_tabelle
WHERE id IN (SELECT child_id FROM rel_tabelle WHERE parent_id = $parentId);

Query should look something like:

@Query("SELECT * FROM Table WHERE id IN (:ids)")

Note: This would not work with IStorageResolver, because we would need the ids to resolve the data elsewhere.

It should be possible to fetch child data in a single query, without the need to fetch the ids first. SQL command would be: ``` SELECT * FROM kind_tabelle WHERE id IN (SELECT child_id FROM rel_tabelle WHERE parent_id = $parentId); ``` Query should look something like: ``` @Query("SELECT * FROM Table WHERE id IN (:ids)") ``` **Note:** This would not work with IStorageResolver, because we would need the ids to resolve the data elsewhere.