FileHold stores information necessary for searching in two locations: the system’s SQL databases and full text indexes. The search tool allows the user to search both locations transparently in a single search. Generally, searching the SQL databases is faster than searching full text, but searching full text is much more flexible.
In addition to the full text content of document files, the full text index contains current metadata values for each document version and the current document name for each document version. Since permission related information is stored in the SQL databases, searching the full text index will always be followed by a permissions check in the database.
Regardless of how or where users search, they can only retrieve documents they have permission to access. For example, in order for a user to see a document in their search results they would have to be a member of the cabinet, folder, and schema that the document belongs to. Visibility to a document may also be affected by the hidden until approved feature.
Some of the options described on this page can only be changed by customers on self-hosted systems. FileHold Cloud customers should contact if changes on the application server are required.
