Page Comparison

...

1. Log into the management console of WSO2 DSS and click Create in the Data Service menu.
2. Add a name for the data service and go to the next step.
3. Connect to the Company database that you defined above.
4. Click Next to go to the Queries screen.
5. Click Add New Query to specify the query details:

   1. Enter UpdateAccBalance as the query ID.

   2. Enter the following SQL dialect:

      Code Block
      UPDATE ACCOUNT SET Balance=:Balance WHERE AccountID=:AccountID

6. Click Generate Input Mapping to automatically generate input mappings for the AccountID and Balance fields.
   Image RemovedImage Added
   

7. At the bottom of the page you will find the Events section:
   Image Modified

8. Click Manage Events and add a new event as shown below:
   Image RemovedImage Added 

   The fields in the Add Events screen are explained below.

   1. Event Id: account_balance_low_trigger
      

      Info
      The ID used for identifying the event-trigger used in data services queries.

   2. Xpath: /updateAccountBalanceQUpdateAccountBalance/Balance<200
      

      Info
      Represents an XPath expression that is run against the XML message presented. That is, the request/response message. When this evaluation returns returns true, the event is triggered.

   3. Target Topic: product_stock_low_topic
      

      Info
      The topic to which the event notifications are published.

   4. Event Sink URL: mailto:youremail@wso2.com 
      

      Info
      A subscription can be any endpoint that is complaint compliant with WS-Eventing. For example, you can use an SMTP transport to send a message to a mail inbox, where an email address is given as the subscription. Here, many subscriptions can be defined for the given topic.

9. Save the event.

10. Save the UpdateAccBalance query.

11. Create an operation for the UpdateAccBalance query as shown below.
    

12. Save the Operation.

13. Click Finish to navigate to the Deployed Services window from where you can manage data services.

...