Hi all,
  Having a little problem here, trying to do a orderby on 2 fields, first on works fine, thats just on the status, 2nd one is a custom date field. This however is not working at all.

Basically they get ordered by the status with no problems, it is however not ordering it by the date at all. Am I doing something stupid here or is this a bug with EE? Or does orderby for some reason not work on a custom date field even when its just returning a integer???

Thanks

Steven Lockey

Edit: More info-

Works fine if I just do ‘orderby=“completion”’ but ‘orderby=“status|completion”’ just does exactly the same as ‘orderby=“status”’ instead of ordering them by completion date when they have the same status. Its like its completely ignoring the 2nd parameter in the orderby.

Hello intunet,

I am sorry to hear you are running into this problem.

You are correct, sorting on a custom date field will not yield consistent results. Your code looks good, it’s just not going to work with custom date.

Is there anything else I can help with?

Cheers,

Out of curiosity, is there a reason why this doesn’t work?
As far as I understood it, date fields should just be # of seconds since a fixed time, aka an integer, which is about the easiest type of thing to orderby?

Or am I missing something that complicates this?

Thanks

Hello intunet,

I take this back. You are right, you can sort on a custom date field.

I tried this:

And it works for me. Trying:

also made for a happy result.

Can you try simplifying like I did and tell me what results you get?

Thank you,
Shane