I customised an object like that and click on Do not generate SQL before running
SELECT DISTINCT
RESOURCE_.RESOURCE_NAME
FROM
RESOURCE_
WHERE
( RESOURCE_.RESOURCE_TYPE_CODE=‘AGENT’ )
union
SELECT ‘ALL’
FROM
RESOURCE_
WHERE
( RESOURCE_.RESOURCE_TYPE_CODE=‘AGENT’ )
The problem is that everytime I export it it lose the union part of the query. Any ideas why ?
gogo (BOB member since 2005-06-03)
Did you check the option “export with universe” in the properties tab of the object?
rajkiransri (BOB member since 2005-04-07)
yes
gogo (BOB member since 2005-06-03)
Your second query for including ‘ALL’ is wrong. It should be a dummy table. Read this FAQ for more details.
Jansi 
(BOB member since 2008-05-12)
Ok it makes sense.
How to you create an object that reference DUAL in it
Associate it with the SYS.DUAL or equivalent table so it will parse (optional)
gogo (BOB member since 2005-06-03)
Did you read the FAQ suggested above?
Jansi (BOB member since 2008-05-12)