This property contains SQL used by the Notifier to fetch push requests. Each row is a push request that determines what information is sent in the message, who receives the information, when, and where. You must set this property.
The result set of this statement must contain at least five columns, and can optionally contain two other columns. These columns can have any name, but must be in the following order in the result set:
resend interval (optional)
time to live (optional)
For more information about these columns, see Creating the push request table.
You might want to include a WHERE clause in your request_cursor to filter out requests that have been satisfied. For example, you can add a column to your push request table to track the time you inserted a request, and then use a WHERE clause to filter out requests that were inserted prior to the last time the user synchronized.
The statement is executed in a standalone transaction.