Similar To and Is Not Blank Operators for Viewpoint Queries

Additional query operators are available to perform new types of analyses using a viewpoint query. The Similar To operator performs a fuzzy match on node properties with the String, Memo, Numeric String, or Sequence data type. A fuzzy match may include up to two characters difference anywhere in the property value. A prefix length can be specified to limit the fuzzy match to the end of a string value. The Is Not Blank operator can be used to identify nodes which have a property value that is not blank.

Business Benefit: Viewpoint queries can use the Similar To operator to identify nodes with property values that are similar but not an exact match. This includes misspellings, past vs. present tense, plural vs. singular, possessive vs. non-possessive, hyphenation, within vs. without parenthesis, and much more. The Is Not Blank operator allows for identification of nodes which have a non-blank value for one or more properties.

Key Resources