Hello,
For some reason, I have migrated a part of my (OTRS 6) tickets from the (MariaDB) otrs database onto the filesystem, and Ieft another part in the DB.
This works as expected, no problem with that.
But now, I am wondering if, using only a MySQL request (i.e. without using commands at the Linux prompt), I can determine whether or not a given article has been migrated to filesystem. Any suggestion?
PS: At first, I thought that the "content_path" field from the "article_data_mime" table was the solution, but now I believe that no, since apparently this content_path value is always set anyway, whether or not the article has been migrated to the filesystem...
Thanks
Determining whether an article is stored in DB or filesystem
Moderator: crythias