Nested Data in Filters

[nckre]

Does someone have a good example on how to adapt the table filters for nested data?

e.g. consider the following schema

-Table 'tasks'
-id
-status

-Table 'task_text'
-id
-task_id
-text
-language

How could I do a DataTableFilterField for task.text when making a drizzle query like db.findMany.tasks { with: text } which returns text as an object inside task?

In the cells I can easily render this with an accessor function, but struggling to combine this with filters.

[sucessdy]

Hi nckre👋,
I also struggle with this but I read the official docs and here what I find.
In Drizzle, we need to do like this.

This joins task_text with tasks using task_id since text is in another table.
Apply a WHERE filter to check if text contains the search term.

const filteredTasks = await db .select({ id: tasks.id, status: tasks.status, text: task_text.text }) .from(tasks) .leftJoin(task_text, eq(tasks.id, task_text.task_id)) .where(like(task_text.text, searchText));