Returns the sales for current selection, but with a forced exclusion of all ingredients containing the string ' garlic'. Returns the sales for current selection, but with new selections both in ' Year' and in ' Region'. It is not equivalent to the syntax (or any other text on the right side of the equal sign implicitly resulting in an empty element set) which is interpreted as no region. Information noteThe syntax in the two previous examples is interpreted as “no selections” in ' Region', that is to say all regions given other selections will be possible. Double quotes can also be substituted with grave accents, for example. Double quotes can be substituted with brackets, for example. For example, will select all ingredients that contain the string ’ Garlic’. strings that contain wild cards or start with a relational operator or an equals sign. Then case sensitive matches between the listed values and the individual field values will be made.ĭouble quotes should be used for searches, i.e. Single quotes should be used if the listed values are explicit field values. If the listed values contain blanks or special characters, or if you want to use wild cards, then you need to enclose the values in quotation marks. The listed values will simply be matched with the field values. Unless the listed values contain blanks or special characters, quotes are not needed. The curly brackets define an element set, where the elements can be either explicit field values or searches of field values. The values are separated by commas, for example. The most common example of a set expression is one that is based on a list of field values enclosed in curly brackets. If there are many distinct values – more than a couple of hundred – then this operation is CPU intense and should be avoided. This modifier will take the selected values from DeliveryDate and apply those as a selection on OrderDate. Based on another fieldĪ simple case is a selection based on the selected values of another field, for example. There are several ways to define the selection as described in the following. If no set identifier is referenced, the current selection state is implicit. Field names and field values can be quoted as usual, e.g.Ī set modifier modifies the selection of the preceding set identifier. The modifier consists of one or several field names, each followed by a selection that should be made on the field, all enclosed by. Such a modification can be written in the set expression. A set can be modified by an additional or a changed selection.
0 kommentar(er)
