Routines

Routines

Name Type Language Deterministic Return Type Security Restriction Comments
hold_retarget_permit_test(pickup_ou integer, request_ou integer, match_item bigint, match_user integer, match_requestor integer) FUNCTION sql false SETOF action.matrix_test_result INVOKER
clear_queued_ingest_force() FUNCTION plperlu false void INVOKER
get_queued_ingest_force() FUNCTION plperlu false text INVOKER
emergency_closing_stage_1(e_closing integer) FUNCTION plpgsql false SETOF action.emergency_closing_stage_1_count INVOKER
summarize_all_circ_chain(ctx_circ_id integer) FUNCTION plpgsql false action.circ_chain_summary INVOKER
usr_visible_holds(usr_id integer) FUNCTION plpgsql false SETOF action.hold_request INVOKER
archive_stat_cats() FUNCTION plpgsql false trigger INVOKER
emergency_closing_stage_2_reservation(res_closing_entry integer) FUNCTION plpgsql false boolean INVOKER
survey_response_answer_date_fixup() FUNCTION plpgsql false trigger INVOKER
find_circ_matrix_matchpoint(context_ou integer, item_object asset.copy, user_object actor.usr, renewal boolean) FUNCTION plpgsql false action.found_circ_matrix_matchpoint INVOKER
get_ingest_queue() FUNCTION plperlu false integer INVOKER
age_parent_circ_on_delete() FUNCTION plpgsql false trigger INVOKER
item_user_circ_test(circ_ou integer, match_item bigint, match_user integer, renewal boolean) FUNCTION plpgsql false SETOF action.circ_matrix_test_result INVOKER
emergency_closing_stage_2_hold(hold_closing_entry integer) FUNCTION plpgsql false boolean INVOKER
hold_request_permit_test(pickup_ou integer, request_ou integer, match_item bigint, match_user integer, match_requestor integer, retargetting boolean) FUNCTION plpgsql false SETOF action.matrix_test_result INVOKER
age_circ_on_delete() FUNCTION plpgsql false trigger INVOKER
apply_fieldset(fieldset_id integer, table_name text, pkey_name text, query text) FUNCTION plpgsql false text INVOKER

Applies a specified fieldset, using a supplied table name and primary key name. The query parameter should be non-null only for query-based fieldsets.

Returns NULL if successful, or an error message if not.
copy_calculated_proximity(pickup integer, request integer, vacp_cl integer, vacp_cm text, vacn_ol integer, vacl_ol integer) FUNCTION plpgsql false numeric INVOKER
fill_circ_copy_location() FUNCTION plpgsql false trigger INVOKER
hold_copy_calculated_proximity(ahr_id integer, acp_id bigint, copy_context_ou integer DEFAULT NULL::integer) FUNCTION plpgsql false numeric INVOKER
emergency_closing_stage_2_circ(circ_closing_entry integer) FUNCTION plpgsql false boolean INVOKER
set_ingest_queue(integer) FUNCTION plperlu false void INVOKER
item_user_circ_test(integer, bigint, integer) FUNCTION sql false SETOF action.circ_matrix_test_result INVOKER
hold_copy_calculated_proximity_update() FUNCTION plpgsql false trigger INVOKER
find_circ_matrix_matchpoint(context_ou integer, match_item bigint, match_user integer, renewal boolean) FUNCTION plpgsql false SETOF action.found_circ_matrix_matchpoint INVOKER
set_queued_ingest_force(text) FUNCTION plperlu false void INVOKER
enqueue_ingest_entry(record_id bigint, rtype text DEFAULT 'biblio'::text, when_to_run timestamp with time zone DEFAULT now(), queue_id integer DEFAULT NULL::integer, ingest_action text DEFAULT 'update'::text, old_state_data text DEFAULT ''::text) FUNCTION plpgsql false boolean INVOKER
maintain_usr_circ_history() FUNCTION plpgsql false trigger INVOKER
find_hold_matrix_matchpoint(pickup_ou integer, request_ou integer, match_item bigint, match_user integer, match_requestor integer) FUNCTION plpgsql false integer INVOKER
purge_circulations() FUNCTION plpgsql false integer INVOKER
summarize_circ_chain(ctx_circ_id bigint) FUNCTION plpgsql false action.circ_chain_summary INVOKER
clear_ingest_queue() FUNCTION plperlu false void INVOKER
circ_chain(ctx_circ_id bigint) FUNCTION plpgsql false SETOF action.circulation INVOKER
all_circ_chain(ctx_circ_id integer) FUNCTION plpgsql false SETOF action.all_circulation_slim INVOKER
push_circ_due_time() FUNCTION plpgsql false trigger INVOKER
process_ingest_queue_entry(qeid bigint) FUNCTION plpgsql false boolean INVOKER
hold_request_permit_test(pickup_ou integer, request_ou integer, match_item bigint, match_user integer, match_requestor integer) FUNCTION sql false SETOF action.matrix_test_result INVOKER
link_circ_limit_groups(bigint, integer[]) FUNCTION sql false void INVOKER
purge_holds() FUNCTION plpgsql false integer INVOKER
circulation_claims_returned() FUNCTION plpgsql false trigger INVOKER
hold_request_regen_copy_maps(hold_id integer, copy_ids integer[]) FUNCTION sql false void INVOKER
age_hold_on_delete() FUNCTION plpgsql false trigger INVOKER
hold_request_clear_map() FUNCTION plpgsql false trigger INVOKER
copy_transit_is_unique() FUNCTION plpgsql false trigger INVOKER
complete_duplicated_entries() FUNCTION plpgsql false trigger INVOKER
copy_related_hold_stats(copy_id bigint) FUNCTION plpgsql false action.hold_stats INVOKER
item_user_renew_test(integer, bigint, integer) FUNCTION sql false SETOF action.circ_matrix_test_result INVOKER