Browse refuses filter

[ccordes]

I have a relatively simple browse Orders - Customers filtered by two status fields. Status=Approved and orderstatus = NewCOD. which never returns any records.
This is in the filter -
'((Ord:DrStatus=' & Status:Approved & ') AND (Ord:Satus=' & status:CODNew &'))'
Both Ord:DrStatus and Ord:Status are in the Hot Fields.
and looking in the data, there are orders that meet these criteria.
Status:Approved and Status:CODNew are equates.

I put a ds_debug statement after the filter is that outputs ThisView{Prop:filter} as this -
'((Ord:DrStatus=1) AND (Ord:Satus=4))'

Any suggestions on why this might not work?

Thanks,
chris

[kevin plummer]

Hi Chris,

Is this right?

Ord:Satus

If yes then try the filter on each element to see which one is failing or maybe both

[ccordes]

typo. but I will try just one and the other.

[ccordes]

  OH Man, now that  is the danger of entrenched thinking. Even after the error is pointed out, I don't see it.
I copied the filter out to Free mind and then copied the pieces back. The ord:satus filter didn't work! Why? whi -I yi yi - satus . Thanks Kevin.