NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: ccordes on November 21, 2010, 05:35:44 PM

Title: Browse refuses filter
Post by: ccordes on November 21, 2010, 05:35:44 PM

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

Title: Re: Browse refuses filter
Post by: kevin plummer on November 21, 2010, 05:44:56 PM

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

Title: Re: Browse refuses filter
Post by: ccordes on November 21, 2010, 06:27:49 PM

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

Title: Re: Browse refuses filter
Post by: ccordes on November 22, 2010, 10:23:58 AM

 :o 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.