2 Replies Latest reply on Oct 7, 2011 12:20 PM by DaleYoung

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



      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.