Dataview Query - Pull data from kanban view into a page

What I’m trying to do

I’m fairly new to Obsidian (loving it) and dataview query language so please bare with me. I have done a good amount of reading on it and watched some really good youtube tutorials to get a better understanding of it in practice.

I’m running the kanban plugin and have 3 boards. To do, Doing, Done. I prefer to organise my projects like this and I don’t necessarily use check boxes. Some projects have due dates where as some don’t. I have tags for each page link/item with #project/…

Now I would like to be able to query data from the kanban view on a table including:
Task, Status, Project, Date Created and File (only uncompleted ones). I have found a couple of other posts whereas someone else managed to do something similar. Below is the code string which I’m using:

Things I have tried

TABLE WITHOUT ID 
regexreplace(Tasks.text, "\[.*$", "") as Task, 
meta(Tasks.section).subpath as "Status", 
tasks.Project as "Project", 
file.link as "File" 
FROM #project 
FLATTEN file.tasks As Tasks 
WHERE !Tasks.done
SORT date(Tasks.due.file.name) 

I’m struggling to figure out a couple of things.

If a text item in the kanban view has been assigned to a page then the item does not show up on the table, only the ones created on kanban but not assigned to any pages.
Project column contains no data, just a - symbol, I can’t work it out how to pull any data from/to it. I checked and made sure that on the pages which are linked to the kanban board items, that ‘Project’ is contained on the metadata.

Heres a screenshot with the current setup.

Markdown from Kanban:

To do

  • [[Start mix prep]] #project/nickrichards @[[2024-01-08]]
  • [[Book session]] #project/nickrichards

Doing

  • Finish mix solace #nickrichards
  • Finish mix King BB #nickrichards

Done

  • Artwork #nickrichards

%% kanban:settings

{"kanban-plugin":"basic","show-checkboxes":true,"hide-tags-in-title":true,"show-add-list":true,"hide-tags-display":false,"show-relative-date":false,"link-date-to-daily-note":true,"hide-date-in-title":true}

%%

Kanban markdown screenshot: