Filtering a dropList

[terryd]

In the "start of Option Filter & Order" embed point of an application I have
     IF p_web.getSessionLevel() <= 4 !Dealers
          WOR:OrderStatusID_OptionView{prop:filter} = p_web.CleanFilter(WOR:OrderStatusID_OptionView,'WOS:DisplayOrder <= 2 ')
      END
Which works fine. It only displays the WOS:DisplayOrder = 1 and     WOS:DisplayOrder = 2 records.
I now want to also display WOS:DisplayOrder = 5
I tried
     IF p_web.getSessionLevel() <= 4 !Dealers
          WOR:OrderStatusID_OptionView{prop:filter} = p_web.CleanFilter(WOR:OrderStatusID_OptionView,'WOS:DisplayOrder <= 2 AND WOS:DisplayOrder = 5 ')
      END
but nothing is displayed in the drop down.

What is the correct command?

[kevin plummer]

on the template tick the box to send the filter to debug view

[jari@softmade.fi]

WOS:DisplayOrder <= 2 AND WOS:DisplayOrder = 5 is impossible

Regards Jari

[debzidoodle]

WOS:DisplayOrder <= 2 AND WOS:DisplayOrder = 5 is impossible

I think you are wanting this

Code: [Select]

WOS:DisplayOrder <= 2 OR WOS:DisplayOrder = 5

[terryd]

Thanks everyone. I can't believe after 30 years I can make a stupid mistake line using AND when I should use OR.
Maybe sometimes there are stupid questions.
against stupidity the gods themselves contend in vain