Omit "File" column in TABLE results

[joerncodes]

As the title said, I would love a way to omit the "File" column in the result of a TABLE query.

My notes tend to have pretty long and complex names, and I'd love to use a shorter YAML field to link to the file instead. I would be delighted if there was an option to hide the "File" column.

[blacksmithgu]

I will add a quick-fix hack for this by allowing you to write

TABLE field AS File, ...

which will render field in place of 'File'. In the long run, I will add a configuration option for it.

[joerncodes]

That works for me!

[SkepticMystic]

An immediate workaround is to group by a unique field. So this codeblock groups by file.name, then returns the title yaml field of each group. But since the group condition is unique, it just displays each note's field, and doesn't display the first column.

table rows.title as Title
from #SN
group by file.name

[joerncodes]

That's true, the problem I had with that is that this doesn't work:

table rows.icon + " " + rows.title as Title from #SN group by file.name

[SkepticMystic]

You get something like this, right?

I think I've posted an issue related to this.

[joerncodes]

Correct!

[stevelr]

I ran into this problem also, and one thing that was confusing was that in example on the obsidian-dataview README, the File name has the column Name, not File, and I don't see anything in the documentation explaining how to rename it.

I will add a quick-fix hack for this by allowing you to write

TABLE field AS File, ...

which will render field in place of 'File'. In the long run, I will add a configuration option for it.

One issue with this proposed solution is that it doesn't allow naming the column, for example, if the field is "name" and I want the column heading to be "Name".

My preferred fix would be to find a way to disable the column entirely. Then any field, with any heading, could be in the first column, and if we still want a file name, we can add file.name to any column.

[rxian]

It appears that we now have full control over which columns to display with dataviewjs in the recent release.

[calpa]

I think there should be an option to toggle whether show the File column or not.

[steve-bate]

@rxian Can you point to the documentation for that? I looked but couldn't find it. Thanks.

[rxian]

@rxian Can you point to the documentation for that? I looked but couldn't find it. Thanks.

Its the Dataview JavaScript API: https://blacksmithgu.github.io/obsidian-dataview/docs/api/intro

[blacksmithgu]

This is now possible via

TABLE WITHOUT ID ... FROM
...

[robmiller]

For anyone else who was, like me, looking for the "rename the File column" use-case here rather than the "omit the File column" one, the change committed in this issue does also allow you to do that. You just need to add a column that displays file.link:

TABLE WITHOUT ID
  file.link AS "Some other name",
  foo AS "Foo"
FROM #bar

[bodiequirk]

@robmiller Thank you!! This is exactly what I was looking to do. The "File" title was truly annoying as a default, so thanks for the workaround.

[blacksmithgu]

You can also change the default "File" title in the Dataview settings.

[maia-sh]

Building on @robmiller's comment, in case this of use to anyone else, here's a snippet to keep the file link but change display text to another the values of another column (title):

TABLE WITHOUT ID
  link(file.link, title) AS "Title",
  foo AS "Foo"
FROM #bar

Or an implicit field:

TABLE WITHOUT ID
  link(file.link, file.path) AS "File Path",
  foo AS "Foo"
FROM #bar