I have ESS with ODBC on Oracle who's working fine. In the Oracle table, I have a FMP calculated field like that:
Hide project = Not IsEmpty( DATACLOSED ), Number, Unstored, Auto indexed and 'Do not evaluate if all..' is not checked.
This field is related to another FMP table named CONFIG with only one record and the following calculated field:
static_0 = 0, Number, Auto indexed and 'Do not evaluate if all..' is not checked.
They are linked to each other like this Hide project = static_0, but nothing appear in portal view.
If I change = for X in the relation, the portal is full. The layout is on the CONFIG table with the one and only occurence record show. If I filter the portal with the field Hide project, all is fine, but slower.