Need help with Pre-Defined Filter, LOV and getting LOV entry

building semantic layer
1

Hi,

I am trying to create a pre-defined filter in the universe that calls a function that either returns Y or N. The function is in SQL/Server 2005, and takes two paramters, ID Number and List of Designators to look for.

So the call is Function(@ID_Number, @User_Selection)

So when the user selects more than one LOV, Info View decides to split the answer up for me into ‘Answer1’, ‘Answer2’ which now makes my function need 3 parameters which is not good. How do I get Info View not to put the ‘’ around the user input or not do the split and give me the user selections as ‘Answer1;Answer2’ like displayed in infoview after selection is made.

Hope this makes sense, and any help would be greatly appreciated.

Thanks!

Michael

mikeyb3270 (BOB member since 2009-07-27)

2

If I understand your query, the UDF(user defined function) takes 2 parameters while calling the function
Did you test it first directly in Designer or in DeskI by calling the function, does it prompt for two separate values as user input
.

haider :es: (BOB member since 2005-07-18)