How to include ALL for an object of type number...

[system]

Hi,

I have a situation where I need to include ALL in the user prompt for an object type number. I tried an option by creating new object which says To_Char([Object]) and then used in the condition object. It parsed fine in the universe but when pulled in the report it throws an error. Do anyone have any suggestions on this. I’m on Oracle10g and BOXI3.1

Thanks.

---

santhosh_03 (BOB member since 2009-07-08)

[system]

Here you can check FAQ: Designer

---

Arjun (BOB member since 2008-07-28)

[system]

@santhosh_03

I have a situation where I need to include ALL in the user prompt for an object type number.

Objects have to return the same data types. If you try to include ALL on a numeric or date object LOV via a union, you’re going to see errors.

I tried an option by creating new object which says To_Char([Object]) and then used in the condition object. It parsed fine in the universe but when pulled in the report it throws an error.

So converting everything to character data should work. What is the complete definition, and what is the error shown on the report?

---

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