IWP filters records when using "Sort by field name" on column header
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.
Sort by Field Name
Sorts by field name but drops out some of the records
Exact text of any error message(s) that appear
FMS Advanced 12.0.4 on a Windows 7 Enterprise virtual machine in a data center.