locked
DB query result RRS feed

  • Question

  • i want to send the DB query result by email
    Sunday, October 6, 2013 10:13 AM

Answers

  • Hello,

    use "Query Database" Activity (category: Utilities) configure the connect to the data source and type your query. If you expect more than 1 result but just want o sent only one email flatten in tab "Run Behavior" with line break.

    Use the "Send Email" Activity to send a smtp-mail.  Configure the connection to the SMTP-Sever. To use the Published Data from "Query Database" Activity link "Query Database" to "Send Email" Activity and then in the body of "Send Email" Activity click mit right mouse key and choose "Subscribe->Published Data" and select "Full line as a string with fields separated by ;" .

    Regards,

    Stefan


    www.sc-orchestrator.eu , Blog sc-orchestrator.eu

    Sunday, October 6, 2013 11:56 AM
    Answerer
  • If you expect more than 1 result but just want to send only one email flatten in tab "Run Behavior" with line break.


    www.sc-orchestrator.eu , Blog sc-orchestrator.eu

    Sunday, October 6, 2013 5:25 PM
    Answerer

All replies