Directus_files uses JSON for tags - moving to CSV?

Help
1

Currently directus_files appears to be using a JSON rather than a CSV array for the tags field. Since we can’t filter JSON, this kind of defeats the purpose I think. It’d be nice to just pull files based on their tags, but currently we can’t.

Have you considered moving from JSON tags to CSV tags?

1 Answer

1
2

You can create custom fields on Directus system tables. So in your use case, you can create a Tags table and then create a m2m between the directus_files and your tags table.

I know, but it feels like a missed opportunity for the default tags field - there's little use for it right now unless someone pulls the whole object based on other filters and then filters by tags.

 –