A collection of parameter values. A holder for range of parameter value objects. The name of the parameter, this is what appears between the question marks in an expression. E.g. ?p country? datatype for the parameter If true, negate cumulative result of all simple value operations OR-ed gether to produce final result of this value. E.g. NOT ( x = 'a' OR x = 'b') The information that is returned by the server when a parameter is used, but there was no corresponding parameter on the request. Defined here for completeness sake, not for persisting in the model. The name of the parameter, this is what appears between the question marks in an expression. E.g. ?p country? use this to provide values on the next data request. datatype for the parameter The model item that is closest to the use of the parameter in the expression. E.g.: expression: country.cname = ?country? Parameter name: country dataType: string modelFilterItem: country.cname Set to true when a filter in the query uses the parameter and the filter is marked as optional. Set to true when multiple values or ranges can be accepted. col in ?p1? col in_range ?p2? col in_range_truncated ?p3? Set to true when a single value is expected. col = ?p1? Set to true for: col BETWEEN ?p1? and ?p1? Set to true for: col GT ?p1? col GE ?p2? col LT ?p3? col LE ?p4? Use symbol for 2 char oper. name of the parameter, use this to provide values on the next data request. Prompt UI control identifier Optional attribute indicates cut off lower limit for UI control. E.g. first date that can be selected - 2018-01-01 # let year = timestampMask( toLocal ( $current_timestamp), 'yyyy'); year + '-01-01' # Optional attribute indicates upper cut off limit for UI control. For example - last date that can be selected, e.g. 2032-12-11 # let year = timestampMask( toLocal ( $current_timestamp), 'yyyy'); year + '-12-31' # Used for select with value and select with search These elements are added to the top of selectable values. The values from the queryValueSelector will follow the static choices. The UI controls have freedom to use this field, these are user defined ranges or values that can be used in the selection. For example when defining ranges, the values used in the ranges may not be defined in the database ( ranges: :10, 11-20, 21: , the database may not contain the number 11, but 11 can still be used in defining the range). Used for select with tree. Each segment of the navigation path is a level in the tree. Use these items to make a query to load the list of selectable values Placement of NULLs, either first, last, or depending on the underlying database. For most databases NULLS LAST is the default for ascending order, and NULLS FIRST is the default for descending order. If the element is not specified then it will not be specified in the native SQL, for Cognos SQL it will be ascending nulls first, descending nulls last. An individual value, could also be a null value. A null values translates in SQL to an IS NULL condition This contains the value to filter on, except when operator is set to isNull Only used for operation=between as the second operand. Only used for operation=between for the second operand The information that is returned by the server when parameter feedback information is requested. Defined here for completeness sake, not for persisting in the model. The name of the parameter, this is what appears between the question marks in an expression. E.g. ?p country? use this to provide values on the next data request. datatype for the parameter The model item that is closest to the use of the parameter in the expression. E.g.: expression: country.cname = ?country? Parameter name: country dataType: string modelFilterItem: country.cname If true, negate cumulative result of all simple value operations OR-ed gether to produce final result of this value. E.g. NOT ( x = 'a' OR x = 'b') Parameter values that are applied to a request for data can be obtained from various places: request - supplied by the client on the request query - defined as part of the query (NYI) global - global parameters model - parameter values defined in the data module.