BusinessObjects Board

Using UserResponse in Where clause?

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 :uk: (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 :mrgreen: B !!

bernard timbal :fr: (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:

Dave Rathbun :us: (BOB member since 2002-06-06)