Can't search calculated summary field when hosted; works fine locally
Operating system version
Mac OS X Server 10.6.7
Description of the issue
I have a field that is a calculation of the sum of a calculation on a related table. Both locally and when hosted on FileMaker server the correct values are displayed. When searching against this field, it works properly when local, and does not work when hosted; as a matter of fact searching against the server version will only succeed if you search for nulls.
I have a small sample file that I can upload to demonstrate the results.
Steps to reproduce the problem
Create a new file (mine is called ec2) with five columns:
Field Name / Field Type / Formula / Entry Option
e / Text / Indexed
c / Text
flag / Text
flagy / Calculation (Number) / from ec2, = If ( flag = "y"; 1; 0)
num ys / Calculation (Number) / Unstored, from ec2, = Sum ( ec2 2::flagy )
Before creating the "num ys" field, go to the relationship graph and create a self-join relationship on field "e".
Enter some data. Put some "y"s in the "flag" field, so that the "num ys" field has different values - 0, 1, 2, 3, etc.
Perform a find on the "num ys" field - observe that it works correctly locally.
Host this file on FM Server.
Perform the same find, and note that you cannot get any values to return.
Find should work properly against hosted file.
Find does not work properly on hosted file.
Exact text of any error message(s) that appear
NO errors, just incorrect results.