...
Internal query SQL supported for Origin File Connector is designed to select desired data stored in an Origin project file. SQL operates through simple, declarative statements. This makes data extraction more flexible, helps to organize data in an Origin project and maintain the
Syntax:
Code Block |
---|
SELECT COLUMN FROM Range WHERE Condition |
Note: only data column is supported as object used in Origin File Connector.
...
Here’s an appendix of special key words Origin supports in Condition.
Table of Contents | ||||
---|---|---|---|---|
|
_Type
Let you select columns with specified plot designation.
Example |
---|
//search the whole project and select unhidden X columns Select Column from Project where (_Type = "X" and _Visible = True); |
Column_Y
When you select a Y column, it will also import the associated X column.
Example |
---|
//search the whole project and select columns with long name starting by “Trial” |
Column_Z
When you select a Z column, it will also import the associated X and Y columns.
Example |
---|
//search the whole project and select columns with long name starting by “Trial” //and import the selected columns and their associated X&Y columns Select Column from Project where (_LName like "Trial*" and Column_Z = True); |
_SName
Let you select columns of specified short name.
...
Let you select columns of specified long name. Wildcard “*” and “?” are supported. “*” represents any string of characters, and “?” represents any single character
Example |
---|
//search the whole project and select column with whose long name starting with “Trial” Select Column from Project where _LName like "Trial*"; |
...
Let you select columns whose Comment matches the specified condition. Wildcard “*” and “?” are supported. “*” represents any string of characters, and “?” represents any single character.
Examlpe |
---|
//search the whole project and select column with comment beginning with starting by letter “S” and end by digit “3” Select Column from Project where _Comments like "S*3"; |
...