LOV Selects

building semantic layer
1

Hello, does anybody know how to retrieve via MANAGER0 the LOV’s select statement? I have over 2500 objects in a universe, 750+ have lov stored in the repository. i would like to know, which of the objects with list of values share the same select(or same table). thanks in advance. daniel

Listserv Archives (BOB member since 2002-06-25)

2

The name of the table is UNV_OBJCONTENT

FIELDS : OBJ_LIST_VALUES
JETID021,L,U,N,N,

Name of the list, L if the list exist, and the diffÈrents options

Attention the list and the name are generated by default -----Message d’origine-----
¿ : BUSOB-L@LISTSERV.AOL.COM
Objet : LOV Selects

Listserv Archives (BOB member since 2002-06-25)

3

The select statement is not stored in the repository because the LOV is treated as a binary document. The LOV is not stored as meta-data. The only way to see the embedded select statement of a LOV is to open the file in something like notepad. There is other binary “junk” you will see, but the select statement is there. Note: the Universe name is embedded in there as well and this is how the LOV is linked back to the Universe.
Simon

Listserv Archives (BOB member since 2002-06-25)