Is it possible to execute a Dynamic Query with a case insensitive ORDER BY?

Issue

• When executing a Dynamic Query that outputs what is accomplished by the following SQL query:

  select * from users ORDER BY name ASC;

   

• The output result is case sensitive. For example: 

  • - Adam
    - Ben
    - Wendy
    - ava
    - bob

• Is it possible to execute a Dynamic Query that would allow for case insensitive outputs like the following example? 

  • - Adam
    - ava
    - Ben
    - bob
    - Wendy

Environment

• Quarterly Release
• DXP 7.4
• DXP 7.3
• DXP 7.2

Resolution

• There currently isn't a way to achieve the case insensitive Dynamic Query output out of the box, and the best course of action would be to proceed with opening up a feature request for this.

Additional Information

• Dynamic Query