2 Replies Latest reply on Feb 17, 2014 8:12 AM by lars_mortensen

    FileMaker server 11 vs 12 searching calc with related fields

    lars_mortensen

      After some time, the searches of a particular type becomes unreliable, and searches incorrect.

       

      These are searches on calculated fields that include related fields from multiple tables (eg. Table A relate to Table B)

       

      After restarting the FileMaker Server 12 searches are normal again.

       

      We see this error in 2 independent files on the same FileMaker Server 12.

       

      In FileMaker 11 we did not have this problem, the searches were slow (unindex), but the result was correct.

        • 1. Re: FileMaker server 11 vs 12 searching calc with related fields
          wimdecorte

          Can you give some more info or a demo file?

           

          Incorrect in what way?  What do the calcs do: list, count,...

          • 2. Re: FileMaker server 11 vs 12 searching calc with related fields
            lars_mortensen

            In the following example, we have three related tables: Assignment, Invoice and InvoiceLines.

            We are searching in the field “TotalRemainingInvoice” on a layout based on Assignment.

             

            Searching for 110,000 in “TotalRemainingInvoice” will also find 0 and other values. The strange thing is that many of assignment-records (but not all) are containing 110,000 as AssignmentPrice, but it seems to skip a part in the formula? (it doesn't make any sense)

            When we restart the FileMaker Server 12 computer the searches works fine again for a while (3 to 7 days).

             

            Assignment

            Assignment::TotalRemainingInvoice [Calculation, number] =

            Truncate ( AssignmentPrice - Sum(Invoice::PriceMUAmountSum) ; 0 )

             

            Assignment::AssignmentPrice [Number]

             

            Invoice

            Invoice::PriceMUAmountSum [Calculation, number] =

            Sum(InvoiceLines::PriceMUAmount)

             

            IncoiceLines

            InvoiceLines::PriceMUAmount [Calculation, number] =

            If(GroupCode = "Consult." ;  Price ; ""  )

             

            InvoiceLines::GroupCode [Text]

             

            InvoiceLines::Price [Number]

             

             

             

            rel.jpg