ALL value not displaying in LOVs

[system]

I want to add LOV like ‘ALL’ in list of values.

Followed the method mentioned in FAQ at this link

120×120 10.4 KB

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…

customised query:
SELECT DISTINCT
table.column
FROM
table
UNION select ’ ALL’

Not showing ALL value in LOVs,why? where is wrong.please suggest.my database is SQL Server.

---

JaiSimha (BOB member since 2010-12-19)

[system]

Hello,

Are you using BO 4.0? If that is the case, then please go through below thread:

https://bobj-board.org/t/190853

---

chinmay1383 (BOB member since 2010-05-11)

[system]

chinmay1383, I am using BOXI3.0.

Why it is not working the procedure in BOXI3.0?

---

JaiSimha (BOB member since 2010-12-19)

[system]

Simha.,

If you want ALL or * for the list values then create a predefined condition. Below is the syntax

@Select(Trade\Trade) IN @Prompt('Trade Number(s) or * for All','A','Trade\Trade',multi,free) OR ('*' IN @Prompt('Trade Number(s) or * for All','A','Trade\Trade',multi,free))

Hope this helps !!!

---

RUC (BOB member since 2010-05-03)