I can see another question about this. However if my understanding is correct. The where clause is not working for me at any level.

I am using the blm national dataset which has a large number of records for all states. I only need to utilize 1-3 states at this time in my workbench. I have attempted a where clause on the reader

, an SQL before read (which seems like the most efficient) and a where clause on the table.

However the sql before will not run at all.

When running the where clause SECDIVID LIKE 'MN% it runs but in the test filter directly after the reader i begin getting unfiltered records. This should not be possible if it has already filtered by the where.

I am not willing to sit through all of the records (it will be at least 4 hrs) to see what happens.

does this work for anybody else?

What am i doing wrong?

I can see the following in the log. but why doesn't it only return these states. It works in Arcdesktop.

GEODATABASE_FILE_1 Reader: Using Enhanced geometry

Using WHERE clause 'SECDIVID<space>LIKE<space><apos>MN%<apos><space>OR<space>SECDIVID<space>LIKE<space><apos>MI%<apos><space>OR<space>SECDIVID<space>LIKE<space><apos>WI%<apos>'

All network information will be ignored. As a result, edges will be treated as polyline features and junctions will be treated as point features

All relationship information will be ignored. As a result, simple relationships will not be read, and attributed relationships will be read as tables

GEODATABASE_FILE reader: Building features into bulk mode features