Hello, is it possible to find out which structures / queries are restricted to a specific value (single value or hierarchy) of an infoobject.
e.g.
We restricted the item to a value, which was deleted after the query was built.
Thank you
Dieter
1 Answer
-
Former MemberPosted on Jul 14, 2004 at 02:24 PMHello Dieter,
You might be able to do this using a combination of tables RSZRANGE, RSZELTXREF and RSZCOMPDIR.
1. RSZRANGE - restrict on HIENM (Hierarhcy name) and it gives you the list of objects that use the hierarchy. Then download only the values of field ELTUID.
2. RSZELTXREF - use the values from RSZRANGE to populate the field TELTUID. When you run it, it will give you a list of the locations of the object i.e. query or structure.
3. RSZELTXREF - re-enter the values you have just downloaded into the TLTUID field again. Run it. (This will then give you a list of the queries that are using structures. Add these to the list you got from Step 2.
4. RSZCOMPDIR - enter the values from Step 2 and 3 into the COMPUID field, run it and you will get a list of the queries using the hierarchy.
Hope it helps.
Add comment
Add comment