I have workspaces authored in FME2018 that use informix spatial readers. In 2018 I am able to set a WHERE clause within the FeatureReader. In version 2021.1 I can no longer do this as the WHERE clause option is greyed out.
Is this a known bug or intended behaviour?
I think you should submit a case to have this answered.
Thanks for the advice, I've just submitted a case for this.
We currently have an outstanding ticket addressing this issue (internal reference number: FMEENGINE-69861). We will update this ticket when this issue has been addressed.
In the meantime, there are a few workarounds that could work:
1. Use the "SQL to Run Before Read" parameter available in the IBM Informix reader parameters
2. Using two workspaces - in the parent workspace would be a WorkspaceRunner pointing to the child workspace and in the child workspace, parameterize the WHERE clause in the IBM Informix Reader.
3. Set up an ODBC connection for the Informix database and use the where clause that way. The ODBC format in the FeatureReader does not seem to be impacted by this so it might be a suitable workaround.
-Andrea