Business View LOV ?? XI R2

[lstieg]

Very new to business views, I have created a view that links 2 tables, inner joined on customer number, want to limit it so it only pulls back lov based on ACTIVE status, thought I was doing this by putting a filter in the data foundation but when I use the parameter in the report it is still pulling back all, can anyone help or point me to some GOOD documentation on creating these things???

Thanks in advance.

 

[DarkAngel]

In case you have not found a solution yet...

Base your LOV on an SQL command where the CustStatus="Active".

In BVM, add a data foundation (or edit your existing DF). Insert, Insert Data Tables. Under your DB Connection, double-click Add Command, enter your SQL and click OK.

Then create your list of values.