Where LOV is used?

[system]

Is there a way to tell in what universes and objects a List of Values is used?

I don’t have Auditor.

(I searched in this forum but couldn’t find this; my apologies if this has been answered already.)

thanks much.

---

dnewton (BOB member since 2004-01-30)

[system]

@dnewton

Is there a way to tell in what universes and objects a List of Values is used?

The Designer SDK could be used. Take a look at this utility as a starting point. The “GetInfo” part of that utility could be tweaked to get the LOV name.

---

Dwayne Hoffpauir (BOB member since 2002-09-19)

[system]

I don’t have the Designer SDK. But I figured out how to do the basics of this in SQL:

– get object list for LOV named OBJEC0IO

select *
from unv_objcontent
where obj_list_values like ‘%OBJEC0IO%’

– find the object for matching IDs from previous query

select *
from unv_object
where object_id = 654 and universe_id = 41

---

dnewton (BOB member since 2004-01-30)