none
how to filter data imported from ODC data connection RRS feed

  • Question

  • When the user clicks Data, existing connections and then selects one of the .ODC connection files on the computer is it possible to filter the data before it is imported?  Where the filter is applied on the server? 

    When the user selects the order header file I do not want them to download all the orders in the file. Would like for the user to be able to enter a date range of orders to load into excel.

    thanks,


    Saturday, February 7, 2015 6:01 PM

Answers

  • The command text for an odc connection is the SQL statement.  You can add a WHERE clause to the SQL to filter the data.  the syntac depends on the type of Database Server you are using.

    I normally record a macro while creating the ODC.   The syntax of the statement of the connection statement will be in the recorded macro.  Then you can edit the recorded macro statement and make any required changes like add a where.

    • Edited by Joel Engineer Saturday, February 7, 2015 6:37 PM
    • Marked as answer by Steve Richter Saturday, February 7, 2015 10:26 PM
    Saturday, February 7, 2015 6:34 PM