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


  1. 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
  2. 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:
      • worksheet -qn Select Column From Project Where Book_LName like "*simple*" and Column_LName like "YCO*";
      • worksheet -qn Select Column from Project where (_Type = "X" and _Visible = True);
  3. A Query button is added in Origin Connector. Open it to enter query.