Fundamentals > Relations and Parameters > Relations > Parameters Used in Relations > Relation Functions to Query Parameters
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.
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.
* 
For Series parameter the values are from the second column.
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).
* 
When argument values change with a constant step, the value returned is the simple arithmetic mean of all values.
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
Was this helpful?