Determining whether an article is stored in DB or filesystem

Moderator: crythias

Post Reply
vincentb
Znuny newbie
Posts: 12
Joined: 30 Jan 2021, 07:51
Znuny Version: 6 community
Real Name: Vincent B.

Determining whether an article is stored in DB or filesystem

Post by vincentb »

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
Post Reply