schedule criteria for ID wrong!

[Dennis Lee]

I am trying to list doors with ID between 1 to 4 only. However, the schedule seems to think that ID 13 and 14 also fall between 1 and 4. I actually had this kind of trouble before too, but couldn't figure out why.

Is this a bug???

[Anonymous]

I think this is how the numbers ware sorting. Try to begin the ID with 01...(09, 10, 11, 12....)

[Dennis Lee]

Learn something new everyday! Thanks.
The math expression is misleading though... 1 < 13 > 4 .....???

[Barry Kelly]

I think your two element ID criteria need to be enclosed in brackets.

Barry.

[Laszlo Nagy]

The thing to know here is that Element ID is a text type variable and not a number. You entered numbers for them but it will keep handling them as texts so comparisons and sorting happen on a character by character basis.
This is why putting a zero in front of single digit number will result in good sorting.

[Dennis Lee]

Thanks for the clarification, Laszlo, never occurred to me to consider it a text variable, but now it makes sense.