AnsweredAssumed Answered

Portal sorting and ExecuteSQL ORDER BY are not consistent

Question asked by estaylorco on Jun 13, 2015
Latest reply on Jun 15, 2015 by Fred(CH)

Summary

Portal sorting and ExecuteSQL ORDER BY are not consistent

Product

FileMaker Pro

Version

14.0.1

Operating system version

Max OS X Yosemite

Description of the issue

Hello Forum,

I just encountered what I think is a bug.  I have a portal of companies where I sort by the company name in ascending order.  The default name I give a company upon creation is (Untitled Company) -, followed by a timestamp.

When this saves down, it shows up in the portal in the "U" section, so that I have, for example, in this order:

Unrein Constructors, Inc.
Unser Construction, Inc.
(Untitled Company) - etc.


In a script, for certain reasons, I execute the following SQL query using ExecuteSQL:

ExecuteSQL ( "SELECT id, name FROM Company ORDER BY name ASC"; ""; "" )

Now, ExecuteSQL properly returns the sort order as this:

(Untitled Company) - etc.
A ... T ...
Unrein Constructors, Inc.
Unser Construction, Inc.


In other words, it floats to the top.

I think this a bug.  It would seem that FM's indexing system is ignoring the "(", and it really shouldn't do that.

Thoughts?

Steps to reproduce the problem

(See Description)

Expected result

(See Description)

Actual result

(See Description)

Exact text of any error message(s) that appear

None

Outcomes