Origin Connector to allow basic SQL selection and Improve Origin Internal Query SQL Support
Version: 2020
Type: Features
Category: Data Handling
Subcategory: Database Import
Jira: ORG-20107
- Following object notations are supported in internal query SQL
- _Type, _SName, _LName, _DatasetType, _Comments, _Visible, Column_Y, Column_Z, Column_P1, Column_D1, Column_[Name], , Sheet_SName, Book_SName, Book_LName
- New worksheet command to output SQL query result to workbook.
- worksheet -qn: Output to new book
- worksheet -qa: Output to active book, this will first delete all existing columns
- Example:
- A Query button is added in Origin Connector. Open it to enter query.