Purpose: The ODBC Custom query is an available configuration option when setting up an ODBC store in ShipWorks. This feature allows you to specify your desired SQL query ShipWorks utilizes to download/upload information from/to your ODBC store/database (instead of choosing a single database table).


THE ODBC CUSTOM QUERY IS AN ADVANCED FEATURE MEANT TO BE USED BY CUSTOMERS WHO ARE FAMILIAR WITH SQL, DATABASES, ETC. THE SHIPWORKS SOFTWARE DOES NOT VALIDATE THE QUERIES USED AND INCORRECTLY SPECIFIC QUERIES MAY ADVERSELY AFFECT OR CORRUPT YOUR DATA.


THIS FEATURE IS FOR ADVANCED USERS ONLY. THE SOFTWARE DOES NOT VALIDATE THE CUSTOM QUERIES USED. INCORRECTLY SPECIFIED SQL QUERIES MAY NOT WORK AND MAY END UP ADVERSELY AFFECTING OR CORRUPTING YOUR DATA. THIS FEATURE IS PROVIDED "AS IS". SHIPWORKS MAKES NO PROMISES, WARRANTIES, OR REPRESENTATIONS OF ANY KIND, AND SHIPWORKS SPECIFICALLY DISCLAIMS ALL WARRANTIES AND CONDITIONS, EXPRESS, IMPLIED, STATUTORY OR OTHERWISE, WITH RESPECT TO THE SUBJECT MATTER HEREOF, INCLUDING BUT NOT LIMITED TO IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL SHIPWORKS BE LIABLE TO YOU FOR INJURY OR ANY SPECIAL, INCIDENTAL, INDIRECT OR CONSEQUENTIAL DAMAGES OF ANY KIND, OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, BUSINESS INTERRUPTION OR ANY OTHER COMMERCIAL DAMAGES OR LOSS, WHETHER OR NOT ADVISED OF THE POSSIBILITY OF DAMAGE, AND ON ANY THEORY OF LIABILITY, ARISING OUT OF OR IN CONNECTION WITH THE CUSTOM QUERIES FEATURE.