sp_get_user_logs


Parameters

Name Type Mode
category text IN (DEFAULT NULL)
user_names text[] IN (DEFAULT NULL)
log_types text[] IN (DEFAULT NULL)
start_date date IN (DEFAULT NULL)
end_date date IN (DEFAULT NULL)
shift t_shift[] IN (DEFAULT NULL)
reference_id integer IN (DEFAULT NULL)
search_text text IN (DEFAULT NULL)
id bigint OUT
category text OUT
user_name text OUT
log_type text OUT
log_date date OUT
log_time timestamp with time zone OUT
log_shift t_shift OUT
reference_id integer OUT
reference_text text OUT
log_text text OUT

Definition