Sort order not working in "Collection" properties

On premise, 9.01.12. Did something break in the "Order by" for Collections? As an example, if I use just "CreateDate" it works fine. However, if I try:

CreateDate desc
CreateDate asc
CreateDate Desc
CreateDate Asc

I will always get:

"Invalid property CreateDate desc in ORDER BY clause".

I've checked the help documentation and I'm supposedly doing everything correctly. Has anyone else seen this? It fails no matter what field I pick if I try and add Asc or Desc to it.

Find more posts tagged with

General Discussions

Accepted answers

unknown

Did you try using all caps for ASC, DESC?

All comments

Stephen Cena

Forgot to add the screen capture....

kwmyers

I see this in 8.03 all the time. Just ignore it and go on. The order by will work. At least in 8.03 it does.

Stephen Cena

That's truly sad if that's the case. Does this mean Infor is going to send us a list of errors messages we're supposed to believe and when we're supposed to believe them?

Ryan Pukanski

Is CreateDate bound to the form? I get that error sometimes but if I bind the property and set it to hidden it goes away.

unknown

Try this :

kwmyers

Agreed. But there are many other bugs I wish they would fix before this one! Here is 8.03 when I use ASC or DESC.

Stephen Cena

It's bound to a grid column on the form.

Stephen Cena

I opted to ditch the Collection level setting in Design Mode. Instead, I opted to solve it with a small amount of code & the StdFormInitCompleted event. The code to create the filter from user input already exists, so I just make sure it's the first thing I call on form load.

0712131256598360.doc

unknown

Did you try using all caps for ASC, DESC?

Stephen Cena

Wow; the one I didn't try and that actually works. Someone should either fix the code so case sensitivity doesn't matter or the documentation should indicate case sensitivity matters.

I guess I just need to remember to use all caps going forward.

unknown

Noted. I have forwarded to documentation.

Copyright © 2025 Infor. All rights reserved.