Prefilter using Radio Button value

[CountryTrash]

Hi there,

Having solved/fixed my current invitations where the tender date is still valid I now need to another another prefilter to the same group from the same joined tables.

I have a Tender Status radio button with two options on it.

1 "Open"
2 "Closed"


I now tried to add THAT prefilter to add a condition to say (in addtion to the $my->id and closingdate >=CURDATE() that

the statusdate must NOT be a 2

(I tried "2" as well !!!)

I tried various ways but kept

AND

tenders_register.TenderStatus NOT EQUAL TO 2 (text)

I tried text, eval, and No Quotes, still shows ALL the records.


Any advise?

 

[sales2010]

do you have any option TenderStatus(raw) to select?

 

[CountryTrash]

Nope, just checked ... just Tenders_register.Tender Status

I did look before I posted ....

Still grappling with it...

 

[rob]

works for me, could you check the 'apply to' setting?
check also that the menu item doesn't have prefilters applied - this would override the list prefilters.

 

[CountryTrash]

Thanks Rob,

That was it. I left the "apply to" to "public" but the Vendor User was set to "Registered" and "Vendor"

"Eval" then did the trick