Combined Filtering

sabzam

Dear All,

I need to have a filter on a customer list but using sort of comibned filtering. For example I need a list of all customers which begin with an A and the list of customer which begin with a B. Should I still use the setfilter and how?

bbrown

Customer.SETFILTER("No.", '%1|%2', 'A*', 'B*');

sabzam

I am sorry I haven't properly explained myself. Let me give you another example. Let 's say I want all customer whose name begin with A and all the customers whose name begin with a B and surname begin with a B.

bbrown

Not possible with a single pass. You will need to pass thru the data twice and write results to a temp table.

I haven't had much coffee yet, so maybe there's something I'm forgetting here.

diptish.naskar

Is sirname a new field or the user enters the sirname along with the name.. :?:

sabzam

Ah no it had to be surname not sirname