acs_messaging_send_query (public)
acs_messaging_send_query -message_id message_id -query query \ [ -bind bind ]
Defined in packages/acs-messaging/tcl/acs-messaging-procs.tcl
Given an SQL query returning columns recipient_id, grouping_id, and wait_until, arrange for all to be sent for this message. Example: acs_message_send_query -message_id $new_message -query { select subscriber_id as recipient_id, forum_id as grouping_id, bboard_util.next_period(period) as wait_until from bboard_forum_subscribers where forum_id = :forum_id } -bind [list forum_id $forum_id] Assuming bboard_util.next_period(period) returns the next date at which a digest should be sent, the above will enter info to send all subscriptions for a single message. The bind argument, if given, must be a list, NOT an ns_set.
- Switches:
- -message_id (required)
- -query (required)
- -bind (optional)
- Partial Call Graph (max 5 caller/called nodes):
- Testcases:
- No testcase defined.