Dynamically changing the queries RRS feed

  • Question

  • I am working on creating a report from the Postgre SQL Database. I have the ODBC diversinstalled and everything is working fine.Currently using the query is something like

    SELECT name, description, createddate
        FROM public.product;

    And it works fine and generates the reports in CSV. Now I need to modify my application so I can get input from the user like the

    SELECT name, description, createddate
        FROM public.product where createddate> xx-xx-xxxx and craeteddate<xx-xx-xxxx;

    I need to receive the datarange from user and supply them in the query, how can I approach this in BizTalk. Any help is greatly appreciated.

    Tuesday, April 4, 2017 8:47 PM


All replies