expose SQl behind an object in the universe

[satinsilhouette]

Is there anyway to expose the sql behind an
object in the universe? I am looking for a
way to get at the sql used to generate an lov
and expose it up to Crystal so that the BO API
can pick it up?


Thanks so much!
satinsilhouette

 

[hilfy]

I don't think you can do this directly. The only way I can thing of would be to go through the Designer app to look at the universe and see which data the LOV is based on and then build your SQL accordingly.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[xlbo]

how about putting that object as the result of a query and then looking at the SQL that is generated in the query designer ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[ErrorMessage]

The LOV is populated by a simple sql statement
usually something along the lines of...

select
distinct column_name
from
table_name

HTH

Knowledge is knowing a tomato is a fruit. Wisdom is not putting it in a fruit salad.