Inconsistent search results between TRIM Context and Desktop
TRIM Context v 6.24.1236
Today we had a report of a user not being able to find a file when using our email app that in turn calls the TRIM Desktop search window. The file was found as normal in TRIM Context.
A trace of the SQL request found the Desktop seach was including a where clause of making sure the file's Classification was active - and it wasn't. The same where clause was not included in the TRIM context search.
It does not appear possible to configure a search to turn this on or off.
Re: Inconsistent search results between TRIM Context and Desktop
If you search for a container that uses an inactive classification
In the Full TRIM Client and applications based on the SDK you can search for and find the container using normal search methods.
In the Trim Desktop Client (which is used with the ODMA interface and the Check In option) it can't find the file if you use searches like record number, title word, date, location etc. (if the file is in a Tray you can select it)
The desktop client get the workgroup server to add an additional where clause to the SQL command compared to the full client and SDK applications
If you turn off the system option "filter the classifications that a user cannot access" it makes the desktop client behave like the full client.
My interpretation of the setting was to modify search behaviour for finding classifications not for finding files based on classifications. (for example when creating a container)