sorting multiple criteria

[balooka]

Hello

Not sure if this is the correct topic, but here it goes:

 

The search returns a set of records and the two fields I'd like to sort them on are 'locked' and a time field 'TIME'.

 

'Locked=1' means that the record does not need any attention now but should still be listed, and the time it a deadline.

 

I can sort on one of them without a problem, but I would like to know if I can sort them like this:

 

REC#1 -> LOCKED = 0  - TIME is 16:00

REC#2 -> LOCKED = 0  - TIME is 16:50

REC#3 -> LOCKED = 0  - TIME is 17:00

REC#4 -> LOCKED = 0  - TIME is 17:20

REC#5 -> LOCKED = 0  - TIME is 18:00

REC#6 -> LOCKED = 1  - TIME is 13:00

REC#7 -> LOCKED = 1  - TIME is 14:20

REC#8 -> LOCKED = 1  - TIME is 15:00

 

Is this possible?

[eos]

Not sure if you're really asking the question for this answer, but here goes:

 

Menu Records -> Sort Records … ; Sort Order: Locked (ascending), Time (ascending)

[balooka]

hmm I think I did forget to ask the question… sorry about that.

 

Your answer is correct and the same as I had done it. But it's not working. In that order, Time (asc) is not working anymore.

The other way around, the locked is not working. Tried to separate the two in two different sorts in a script, but no luck.

The Time field is from a related record, so I figured that might be a problem and then populated a field in the parent DB with

the same time and tried to sort again, not working… very odd. I'm working at it for over an hour now.

 

note

I was about to post some images for you but my machine froze up. So after opening and checking the data, it now works ?!?

very very odd. Working now - thank you very much, Eos!