0 Replies Latest reply on Jun 13, 2015 1:20 PM by estaylorco

    Portal sorting and ExecuteSQL ORDER BY are not consistent

      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?