How to fetch section a task is under

[WhaleJ84]

Hey, I have a file tasks/states which uses the Kanban plugin. In this board, I have a column for 'backlog, in progress, blocked, etc..' and within these columns I have a single entry which is a link to a file which has the task outlined.

All I want to do is have a query to say for example Fetch which column (section) 'Water the plants' is under, and have it return that it is under backlog, or whatever stage it is at.

I've read through a bunch of other discussions and can't quite find the query where I can hard-code it to always look at the tasks/states file but just change the task I am querying for.

[AB1908]

I feel like this was added in the beta. Can you upgrade using BRAT and then poke around in console?

[WhaleJ84]

Sorry, I don't understand what BRAT is, nor would I know what to look for in the console.
Is there some other way I can help?

[blacksmithgu]

You can access the section for a task via the implicit header or section field in task queries.

[WhaleJ84]

That's pointed me in the right direction, returning all the headings using:

TABLE WITHOUT ID
file.tasks.section AS State
FROM "tasks/states"

Although it returns the full hierarchy (e.g. state > Backlog instead of just Backlog), but that's fine if there's no way to shorten that.

My issue persists when trying to filter it down to just the task I want. Including the following tasks (separately, not in one query) on the end returns no results when querying for the file called Water the plants.md:

WHERE text = [[Water the plants]]
WHERE file.tasks.text = "[[Water the plants]]"
WHERE link = [[Water the plans]]
WHERE file.tasks.link = "[[Water the plants]]"

With the remaining combinations (not shown) of including double-quotes around the wikilink and file.tasks. prepended to the field tried also; it always returns 0 results.

To reiterate, what I want is a query similar to:

TABLE WITHOUT ID
file.tasks.section AS State
FROM "tasks/states"
WHERE text = [[Water the plants]]

And the output I'm looking for is a single line of Backlog (or states > Backlog), excluding all other tasks tracked in tasks/states that are not Water the plants.

I am new to Dataview, so I am probably missing something minor, but this has me trumped - what am I doing wrong?

[AB1908]

Can you try comparing file.name and use the file name on the right side?

[WhaleJ84]

Can you try comparing file.name and use the file name on the right side?

Using WHERE file.name = "Water the plants" and the variants with and without double-quotes and wikilinks all return 0 results.
I tried the same with filenames that do not have spaces in them also, so that doesn't seem to be the fault.

[AB1908]

Can you paste some note contents along with the desired output?

[WhaleJ84]

tasks/states.md

---

kanban-plugin: basic

---

## Backlog

- [ ] [[Water the plants]]
- [ ] [[Learn DQL better]]


## In Progress

- [ ] [[Get query resolved]]




%% kanban:settings
\```
{"kanban-plugin":"basic"}
\```
%%

tasks/Water the plants.md

This is a reminder to water the plants.


\```dataview
TABLE WITHOUT ID
file.tasks.section AS State
FROM "tasks/states"
WHERE file.name = "Water the plants"
\```

Desired outcome

Actual outcome

Almost any use of WHERE returns 0 results, and any time the query 'does work' it returns all the tasks in the board.

[Lednerb]

You can use this method:

#720 (comment)

In my case I'm using this code snippet to display all upcoming appointments for the specified month:

TASK
FROM "Journal"
WHERE contains(file.name, "2022-06-") and !completed and (meta(section).subpath = "📅 Termine")
SORT file.name

[WhaleJ84]

The meta command functions but returns the name of the file and not the name of the section it is tracked under in the kanban board. In my situation I am already in the file so it's not quite what I am after.

I track the states in the kanban board by dragging the tasks to their respective state, and my desired outcome is to be able to go into any of the tasks and have its state dynamically fetched from the kanban board. This way I can modify all the tasks states from the board without having to manually go into every task and change a line one by one.

Thanks for the snippet, though. Will come in handy for other plans I have!

[AB1908]

IIRC, file.section is a new attribute that contains section metadata.