Relation Functions to Query Parameters
Creo supports following parameter types:
• Series parameter— It is represented by a two column table where the first column contains the argument stamp and the second column contains the corresponding value for each stamp. The value and the argument can be with or without units. The argument column is always sorted in ascending order (lowest to highest) and the values must be unique.
• List parameter—It is represented by a single column table that contains the parameter values, these values can be with or without units.
You can use the following functions 
to query the parameters.
to query the parameters.Function | Description | ||
|---|---|---|---|
has_value (Param, Value, (Column)) | Returns True if the value exists in the specified column. Otherwise returns False. Where: Param—name of a parameter Value—value to check for column (optional)—column number | ||
match_value (Param, Value, (Column)) | Returns the topmost row where the value is found in the column. If param is not found it returns 0. Otherwise returns error. Where: Param—name of a parameter Value—value to check for column (optional)—column number | ||
min/max/average | Returns the minimal, maximal, or average value of the param. Applicable only for numerical parameter values.
| ||
value_by_argument | Returns the value in the same row as the argument found when it exists, or a linear interpolation between the two closest values. When argument is out of the interval, the result is undefined and an error is shown. Param—name of a parameter Argument—value in the first (left) column interpolation_order—specifies an exact match (0), or linear interpolation (1). | ||
weighted_average | Returns the weighted average value of the Column values of the parameter. The weighted average is calculated by the formula: Sum (Ti+1-TI*(vi+1+VI/2))/(Tlast-T0).
where: Param—name of a parameter | ||
value | Returns the value in the specified cell when used in the right side of the relation. Sets the value for the cell when used in the left side of the relation. Where: Param—name of a parameter Row_Number—row number of the specified cell. column (optional)—column number | ||
count_rows | Returns the number of rows in the parameter. where: Param—name of a parameter |
