Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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”
//and import both the selected columns and their X columns
Select Column from Project where (_LName like "Trial*" and Column_Y = True);


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

...