Option Filter

sabzam

Dear All,

I have added another filter in the Item table of type option. Still I am having a problem in passing one of the options to the filter from the report. The option is of the like Trees & Fruit. Can anyone tell me what should I do differently? Please note taht the other option which is a single word option has passes successfully without much trouble.

Igor_Beeone

Hello,
it's seems that the problem is in & symbol.
Tell which type of database are You using. (SQL/Native)
Is there any way to rename & symbol?
1) Also you can try using index of an option (Maybe it will help)
2) You can rename this option but leave translation (Caption) same as before
Br,
Igor Beeone

kine

When you are entering filter for this value, you need to add quotes around it to mark it as "one value" and not filter...

sabzam

Hi My exact code is

Setfilter ("Sales Type Filter", 'Dev & Print');

It seems that it can't recognise it. I have tried to put " and ' in all possible places but still it seems that I can't sort it out. Anyone has got any possible solution?

idiot

I would use this manner
Setfilter ("Sales Type Filter", "Sales Type Filter"::"Dev & Print");

Alternative each option is also represented by a number. Maybe try
Setfilter ("Sales Type Filter", "Sales Type Filter"::1);
Where 1 is the order of the option in the option list

Hope this helps