![]() To test this, run the chunk below from the command line : MARC :: Record -> new_from_usmarc ( CGI -> new -> param ( 'marc' ) ) -> as_xml_record _END_ #!/usr/bin/perl use CGI use MARC :: Record use MARC :: File :: XML print "Content-type: application/marc+xml \n \n". Using Bucardo's check_postgres script with Nagios/Icincga? Add checks for these:Ĭheck_postgres -query="SELECT COUNT(rpt.id) AS result, COALESCE(STRING_AGG(rpt.id::TEXT, ','), 'none') AS ids FROM reporter.template_folder AS rpt JOIN reporter.template_folder AS prpt ON (rpt.parent = prpt.id) WHERE rpt.shared IS TRUE AND (prpt.share_with NOT IN (SELECT id FROM _unit_ancestors(rpt.share_with)) OR prpt.shared IS FALSE) " -c 1 -u evergreen -H localhost -action=custom_query -db evergreenĬheck_postgres -query="SELECT COUNT(rpt.id) AS result, COALESCE(STRING_AGG(rpt.id::TEXT, ','), 'none') AS ids FROM reporter.report_folder AS rpt JOIN reporter.report_folder AS prpt ON (rpt.parent = prpt.id) WHERE rpt.shared IS TRUE AND (prpt.share_with NOT IN (SELECT id FROM _unit_ancestors(rpt.share_with)) OR prpt.shared IS FALSE) " -c 1 -u evergreen -H localhost -action=custom_query -db evergreenĬheck_postgres -query="SELECT COUNT(rpt.id) AS result, COALESCE(STRING_AGG(rpt.id::TEXT, ','), 'none') AS ids FROM reporter.output_folder AS rpt JOIN reporter.output_folder AS prpt ON (rpt.parent = prpt.id) WHERE rpt.shared IS TRUE AND (prpt.share_with NOT IN (SELECT id FROM _unit_ancestors(rpt.share_with)) OR prpt.shared IS FALSE) " -c 1 -u evergreen -H localhost -action=custom_query -db evergreen Listing users with permissions by work_ou share_with NOT IN ( SELECT id FROM actor. share_with AS "Parent Shared With" FROM reporter. ![]() This SQL will list the folders that are shared more widely than their parents: To fix this, the "top-level" folder has to be shared the most widely with the subfolders either at the same or a more restrictive level. Given a simple org tree of A->B->C, if a user at C shares a report folder with all of C and then shares a subfolder with A or B, the display of shared folders for all users at A or B will be broken (the location of the breakage depends on the sort order of the username). copy_circ_lib = 101 - OPTIONAL: set one or more org unit id numbers here GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13 ORDER BY copy_circ_lib, pgt. circ_limit_set_circ_mod_map lscm ON lscm. circ_mod ), ', ' ) AS "Limited Circ Mods" FROM config. items_out AS "Max Items Out" ,Īrray_to_string (array_agg (lscm. ![]() idĪnother approach, showing more columns and their human readable values, change the WHERE clause to get different ones or comment out WHERE clause to see all rules. Substitute a.org_unit=1 with the id of your library from the _unit table. I have a set declared static final and is additionally frozen.A quick way to view the circulation policies, in PostgreSQL, with the names instead of id values, similar to the Staff Client Circulation Policy Editor.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |