Problem:

How can I turn off the NoFiltOptfilter for a catalog when using a UNIX Data Server?

Resolution:

Place the following option in the odbc.ini file that's in the Relativity Data Server home directory, in the section for the DSN involved:

NoFiltOpt=1

This should turn off the "push down" filter for that DSN, and allow all the rows to be returned by the query. If that doesn't solve the problem, then we can take a look at an ODBC trace to see what the might be causing it.