Bug 248 - Parameter - Combobox Dynamic Query Always Sorts ASC

Cory Fifield -

Found in Version
Resolved in Version


Bug: When adding a Combobox Parameter that uses Dynamic Query with an ORDER BY clause, the order will be ignored and defaults to ASC order.


Steps to reproduce:

  1. Create / Open View
  2. Go to Parameters
  3. Add A Parameter
  4. Enable Dynamic
  5. Add Dynamic Query using a ORDER BY
    • (SELECT ContactName FROM Customers ORDER BY ContactName DESC)
  6. Set Type to Combobox
  7. Run View


Expected Result: When sorting the values in descending order they should sort in descending order.

Actual Result: The query defaults to sorting ASC even if specified to order by DESC

Have more questions? Submit a request