How to find staff using a particular cataloger proxy
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description
We are working to create some new Cataloger Proxy groups. We have one called ARCCATSTA.
In the Staff Privileges section, when we highlight in ARCCATSTA and click on Display Proxies, we get a message "The user ARCCATSTA has no proxies".
However, we can see that multiple users have a Cataloger Proxy of ARCCATSTA.
Is there a way to display the Cataloger Proxies for a Cataloger Proxy?
Resolution
The Help says that "Display Proxies" is used to get a list of the user's proxies.
It seems that you want to do the opposite: to display the users who are using the cataloger proxy of ARCCATSTA.
The following SQL will give you that:
> s+ <pw_library>
SQL> select Z66_REC_KEY from z66 where Z66_CATALOG_PROXY = 'ARCCATSTA';
Or to see the users for *every* Catalog Proxy:
SQL> select Z66_CATALOG_PROXY, Z66_REC_KEY from z66 where Z66_CATALOG_PROXY is not null order by Z66_CATALOG_PROXY, Z66_REC_KEY;
- Article last edited: 1-Oct-2017