3 Replies Latest reply on Jan 23, 2014 6:32 AM by TSGal

    IWP filters records when using "Sort by field name" on column header



      IWP filters records when using "Sort by field name" on column header


      FileMaker Server


      Server FMP Advanced 12.0.4

      Operating system version

      Server on Windows 7 Enterprise, Accessed by FMP and by IWP

      Description of the issue

      I have a list view that shows records in a table like format, where the column headers are buttons that sort by that field using the "Sort by Field name" script step. This works as expected in FMP 12 on my desktop, accessed through the server. However, when I log in with the same user name into the same file on the server, it has an irregular behavior of filtering out some of the records. A list of 13 might shrink to 12, a list of 7 might shrink to 4. This is true even when sorting a text field where all of the records have valid text.

      Has me  a bit perplexed . . .

      Steps to reproduce the problem

      Execute from a button the step "Sort by Field Name" where the button specifies the field name.

      Expected result

      Sort by Field Name

      Actual result

      Sorts by field name but drops out some of the records

      Exact text of any error message(s) that appear


      Configuration information

      FMS Advanced 12.0.4 on a Windows 7 Enterprise virtual machine in a data center.