Routines

Routines

Name Type Language Deterministic Return Type Security Restriction Comments
sp_login1 FUNCTION PLPGSQL false jsonb INVOKER
fn_get_user_info FUNCTION PLPGSQL false record INVOKER
sp_get_property_by_prop_group_id FUNCTION PLPGSQL false json INVOKER
fn_logout FUNCTION PLPGSQL false record INVOKER

User logout
sp_gen_jasper_report_url FUNCTION PLPGSQL false text INVOKER
fn_change_password FUNCTION PLPGSQL false record INVOKER

Change user’s password using old and new password To reset or inititalize password, set old_password to null
fn_check_permission FUNCTION PLPGSQL false boolean INVOKER
fn_get_user_permissions FUNCTION PLPGSQL false SETOF record INVOKER

Get user’s permissions (category_id is the first charecter of permission code)
sp_tr_configs_init FUNCTION PLPGSQL false trigger INVOKER
sp_get_batch_reports_js FUNCTION SQL false json INVOKER
sp_gen_report_url2 FUNCTION PLPGSQL false text INVOKER
fn_period FUNCTION PLPGSQL true record INVOKER
fn_prop_connection FUNCTION SQL false text INVOKER
sp_system_notify FUNCTION SQL false boolean INVOKER
sp_get_report_list FUNCTION SQL false SETOF record INVOKER
sp_get_run_batch_report_by_index FUNCTION PLPGSQL false json INVOKER
fn_connection FUNCTION SQL false text INVOKER

Create connection string
fn_login FUNCTION PLPGSQL false record INVOKER
fn_get_permission_codes FUNCTION SQL false SETOF record INVOKER
fn_user_email FUNCTION SQL false text INVOKER
sp_get_password_policy FUNCTION PLPGSQL false record INVOKER
fn_parse_param_values FUNCTION PLPGSQL true jsonb INVOKER
fn_get_users FUNCTION SQL false SETOF record INVOKER
sp_get_user_s_by_prop_id_json FUNCTION SQL false jsonb INVOKER
sp_raise_error_if FUNCTION PLPGSQL false void INVOKER
sp_get_user_p_by_prop_id_json FUNCTION SQL false jsonb INVOKER
sp_tr_reports_update_permission FUNCTION PLPGSQL false trigger INVOKER
fn_prop_params FUNCTION SQL false SETOF record INVOKER

Get system parameters from property database
sp_logout_all FUNCTION PLPGSQL false integer INVOKER
sp_set_session FUNCTION PLPGSQL false void INVOKER
fn_gen_password_reset_token FUNCTION PLPGSQL false text INVOKER
sp_gen_report_url FUNCTION PLPGSQL false text INVOKER
fn_get_user_permission FUNCTION SQL false jsonb INVOKER
sp_update_reports FUNCTION PLPGSQL false record INVOKER
sp_change_work_shift FUNCTION SQL false void INVOKER
sp_gen_report_file FUNCTION PLPGSQL false record INVOKER
fn_add_user FUNCTION PLPGSQL false record INVOKER
fn_assign_user_property2 FUNCTION PLPGSQL false record INVOKER
fn_system_config_js FUNCTION PLPGSQL false jsonb INVOKER
sp_assign_user_property FUNCTION SQL false record INVOKER
fn_prop_query FUNCTION SQL false SETOF record INVOKER

Run sql query and return data from specified property
fn_get_login_token FUNCTION SQL false text INVOKER
sp_get_run_batch_report FUNCTION PLPGSQL false json INVOKER
fn_gen_access_token FUNCTION SQL false text INVOKER
sp_login FUNCTION PLPGSQL false jsonb INVOKER
fn_get_config FUNCTION SQL false text INVOKER
fn_period_start FUNCTION SQL true date INVOKER
sp_save_batch_report FUNCTION PLPGSQL false json INVOKER
fn_set_config FUNCTION PLPGSQL false integer INVOKER
fn_gen_activate_url FUNCTION PLPGSQL false text INVOKER
sp_get_reports_js FUNCTION PLPGSQL false json INVOKER
fn_handle_error FUNCTION PLPGSQL false json INVOKER
sp_reset_password FUNCTION PLPGSQL false record INVOKER
sp_get_connection_string FUNCTION SQL false text INVOKER
fn_result_success FUNCTION SQL false json INVOKER
fn_get_session FUNCTION PLPGSQL false text INVOKER
sp_tr_users_check_image_size FUNCTION PLPGSQL false trigger INVOKER
fn_get_user_permission_json FUNCTION SQL false jsonb INVOKER
fn_verify_token FUNCTION PLPGSQL false record INVOKER
fn_prop_params_js FUNCTION PLPGSQL false json INVOKER
sp_db_kill_connections FUNCTION SQL false boolean INVOKER
sp_get_user_g_by_prop_id_json FUNCTION SQL false jsonb INVOKER
fn_period_end FUNCTION SQL true date INVOKER
sp_db_search FUNCTION SQL false SETOF record INVOKER
fn_parse_date FUNCTION SQL true date INVOKER
fn_revoke_permissions FUNCTION PLPGSQL false record INVOKER
sp_get_reports_option_js FUNCTION PLPGSQL false json INVOKER
fn_work_shift FUNCTION SQL false character varying INVOKER
sp_get_reports_list_js FUNCTION PLPGSQL false json INVOKER
fn_encrypt_password FUNCTION PLPGSQL false trigger INVOKER
sp_get_batch_report_js FUNCTION SQL false json INVOKER
fn_prop_exec FUNCTION SQL false text INVOKER

Execute sql command on property database
sp_run_batch_report FUNCTION PLPGSQL false integer INVOKER
sp_get_batch_report_details_js FUNCTION SQL false json INVOKER
fn_system_date FUNCTION SQL false date INVOKER

Get system date from property’s database
fn_set_group_permissions FUNCTION PLPGSQL false record INVOKER
sp_get_user_du_by_prop_id_json FUNCTION SQL false jsonb INVOKER
sp_sync_room_avail_interface FUNCTION PLPGSQL false SETOF jsonb INVOKER
sp_clear_my_lock_record FUNCTION PLPGSQL false boolean INVOKER
fn_result FUNCTION SQL false json INVOKER
fn_grant_permissions FUNCTION PLPGSQL false record INVOKER

Grant permissions to specified user and property
sp_get_report_for_print_js FUNCTION PLPGSQL false json INVOKER
sp_verify_token FUNCTION PLPGSQL false record INVOKER
sp_gen_jasper_report_file FUNCTION PLPGSQL false record INVOKER
fn_get_password_json FUNCTION SQL false json INVOKER
fn_dashboard_url FUNCTION PLPGSQL false text INVOKER
fn_result_error FUNCTION SQL false json INVOKER
sp_check_permission FUNCTION PLPGSQL false boolean INVOKER
fn_set_user_permissions FUNCTION PLPGSQL false record INVOKER
sp_tr_users_init FUNCTION PLPGSQL false trigger INVOKER
fn_json_bytes_to_bytea FUNCTION SQL true bytea INVOKER
sp_get_printform_list_js FUNCTION PLPGSQL false json INVOKER
sp_notify_realtime_event FUNCTION PLPGSQL false boolean INVOKER
sp_clear_my_lock_record_by_id FUNCTION PLPGSQL false boolean INVOKER
sp_telegram_send_msg FUNCTION SQL false boolean INVOKER
fn_report_service_settings FUNCTION SQL true json INVOKER
sp_register_property FUNCTION SQL false record INVOKER
sp_tr_service_token_init FUNCTION PLPGSQL false trigger INVOKER
sp_request_password_reset FUNCTION PLPGSQL false record INVOKER