AnsweredAssumed Answered

Can't search calculated summary field when hosted; works fine locally

Question asked by DaleYoung on Aug 12, 2011
Latest reply on Oct 7, 2011 by DaleYoung


Can't search calculated summary field when hosted; works fine locally


FileMaker Server



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.

Expected result

Find should work properly against hosted file.

Actual result

Find does not work properly on hosted file.

Exact text of any error message(s) that appear

NO errors, just incorrect results.