topic Re: Filter on a View in Application Development and Automation Discussions

Filter on a View

Former Member — Wed, 19 Mar 2008 12:23:19 GMT

Hello firends,

I have created a View based on AFPO table.I would like to exclude 2 order types out of the view.Is there a way i can achieve this by going into 'Selection Condition Tab' and excluding just 2 Order Types. If someone can please show me the exact parameters in the Selection Condition Tab.Points will be assigned.

Thanks.

Re: Filter on a View

Former Member — Wed, 19 Mar 2008 12:33:35 GMT

Hi,

In the Select Conditions, you can give the table name as "T003O" and field name as AUART operator is NE and value NMO for order type NMO.

Let me know if it works.

Thanks,

Anil.

Re: Filter on a View

Former Member — Wed, 19 Mar 2008 12:41:44 GMT

Follow the below steps.

1. In the Selction Conditon Tab, On the first row SELECT the Table Name as AFPO, 2. Field Name as DAUAT Select Operator as NE.

3. Provide the value to be excluded in the Comp Value field within quotes.

4. In the AND/OR field ENter AND if you want to exclude one more value.

5. In the next entry follow the above steps.

Hope this helps.

Thanks,

Balaji