aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_set_queue_realtime_notify
Parameters
Name
Type
Mode
notify_user
text
IN
Definition
declare current_propcode text; data_notify json; BEGIN /** * Create by Keng (2020/06/22) * Insert data to DB realtime for realtime service manage about realtime continue * *******Warning If realtime service run more than one (run 2 in case run localhost and production) will not work! * ----if want to develop must stop service on Production! */ current_propcode = fn_current_propcode(); data_notify = sp_get_notifications_user_js(notify_user); perform sp_enqueue_realtime(notify_user, current_propcode, 'notify', data_notify); return true; END;