I am trying to use a UserResponse statement in a Where clause, so that I can restrict a variable to the users response.
E.g. = Where ( =UserResponse(“Query 1 with universe” ,“1) Please enter customer number:”))
I can restrict the data using an If statement, however this doesn’t provide me with the flexibility of using the Where statement.
Does anyone know if it possible to incluse a UserResponse in a Where clause? I am using Business Objects 5.1.8.
gbvck3 
(BOB member since 2005-03-21)
It remains me a similar problem I had about it. I think the only way you have it’s to make a
= Where ( =1)
or Where ( =0)
and generate your from your UserRespons
: if userResponse = toto then 1 else 0
ps : … And welcome to B 
B !!
bernard timbal 
(BOB member since 2003-05-26)
Welcome to B:bob:B!
As you have found out, you cannot use any sort of function or comparison other than = in a Where clause in a Variable. There is a FAQ entry that discusses one possible solution.
There are also a number of different examples of variable “where” clauses in some of the presentations that I’ve done over the years… you can download them all here:
http://www.integrasolutions.net/isi_library_presentations.htm
Dave Rathbun 
(BOB member since 2002-06-06)