acs_messaging_send_query -message_id message_id -query query \
[ -bind bind ]
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)
|