...
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"; |
...