URGENT HELP NEEDED - PROMPT PASSING VALUES!

[system]

Hey guys,

I am sorry but i need urgent help on this issue. I have a very ver simple freehand sql report, which is something like this.

SELECT 
ACCOUNT_NUMBER,
ACCOUNT_TEAM,
ACCOUNT_DATE,
CUSTOMER_NAME

FROM MAIN_USERS_TABLE

WHERE 

CUSTOMER_ADD_STATE = 'NY'

AND

ACCOUNT_TEAM IN @PROMPT(SELECT OR ENTER YOUR ACCOUNT TEAMS)

My dilemma is that we have a bunch of teams and then we have some outside vendor teams that we do not want to
show ALL accounts to but only their accounts.

This report will be scheduled and have 3 schedules. One schedule will be to generate data for ALL TEAMS and the
other two will be two generate data for outside team1 and outside team 2. I am not worried about outside teams
because i can manually enter their team names in the schedule prompt and thats it.

What i want to do is i want to have like lets say * that if i enter * in my prompt it will select ALL TEAMS for the prompt value.

How can i do this?

---

NycPriya (BOB member since 2010-11-04)

[system]

I think you can set default value for the prompt. It will take default value if nothing is selected.

just refer the BO guide or google, you get the syntax. Hope this helps!

---

sivakumar_bo (BOB member since 2006-04-22)

[system]

I think you are looking for : * to be appear in the list of values. and if you select * that should provide you the result of what All items together will product.
If this is correct then refer this link :

FAQ: Designer

Now that my LOV lets me use ALL for all values, how do I get the ALL in the list? Author: Dwayne Hoffpauir There are two approaches - overriding the LOV SQL, and creating a universe object. Overriding the LOV SQL Press the SQL button in the query panel of the LOV Add the phrase UNION SELECT ‘ALL’ FROM DUAL or similar dummy table for your particular database. For SQL Server (if you don’t care if the object parses or not) add SELECT xx From xx UNION SELECT ‘ALL’ (You don’t need a FRO…

Adding ALL to the list of values

Hello Sandi, I tried the following SQL to add “ALL” in the LOV for ProjectType object (on the universe side). Select ‘All’ from Dual union all SELECT DISTINCT VW_RPT_CUS_SEP_RenamedStandardFields.ProjectType FROM VW_RPT_CUS_SEP_RenamedStandardFields I am getting the following error message when I validate the SQL Exception: DBD, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name ‘Dual’.State: 42S02 Do I need to do any additional steps to include ALL to the LOVs Hema h…

---

bryanket (BOB member since 2009-10-22)