AnsweredAssumed Answered

Portal sorting and ExecuteSQL ORDER BY are not consistent

Question asked by estaylorco on Jun 13, 2015

Title

Portal sorting and ExecuteSQL ORDER BY are not consistent

Post

Hello Forum,

(using FMA 14.0.1)

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?

Outcomes