notePathWithFileExtension()
The notePathWithoutFileExtension()
function will return path for the current page and the file name with out the extension, so if the file path in your vault is folder/folder/my cool filename.md
this function will return folder/folder/my cool filename
.
Here are all the page functions to extract information from the current page the query is running on.
markdown
```qatt
query: |
SELECT TOP 1
notePathWithFileExtension() AS notePathWithFileExtension,
notePathWithoutFileExtension() AS notePathWithoutFileExtension,
notePath() AS notePath,
noteFileName() AS noteFileName
FROM obsidian_markdown_tasks
template: |
{{#each result}}
notePathWithFileExtension: {{notePathWithFileExtension}}
notePathWithoutFileExtension: {{notePathWithoutFileExtension}}
notePath: {{notePath}}
noteFileName: {{noteFileName}}
{{/each}}
```