SemQL Reference Guide

Overview

Using this guide, you will learn the SemQL language and its usage in Semarchy Convergence for MDM.

Tip: If you want to try Semarchy Convergence for MDM, you can use our demonstration environment and getting started guide: Getting Started with Semarchy.

Contents

  1. SemQL Reference Guide
    1. Overview
    2. Contents
  2. Preface
    1. Audience
    2. Document Conventions
    3. Other Semarchy Resources
    4. Obtaining Help
    5. Feedback
  3. Introduction to SemQL
    1. SQL-Like Clauses
    2. Not a Query Language
    3. Qualified Attribute Names
    4. Built-in and Customized Functions
  4. SemQL Syntax
    1. Language Elements
      1. Values, Operators and Functions
      2. Expressions, Conditions, Order By Clause
        1. Examples of Expressions
        2. Example of Conditions
        3. Example of Order By Clauses
      3. Comments
    2. Values
    3. Operators
      1. Arithmetic Operators
      2. Character Operators
      3. Comparison Operators
      4. Logical Operators
    4. Functions & Expression Constructs
      1. Built-in Functions
        1. Useful & Noteworthy Functions
        2. Functions for Matching
      2. Other Constructs
        1. CASE Expression
      3. Customized Functions
  5. Attributes and Variables
    1. Variables
      1. Built-in Platform Variables
      2. Model Variables
      3. Using Variables
    2. Attribute Qualified Names
    3. Using Current Entity's Attributes
      1. Simple Attributes
      2. Complex Attributes
        1. Display Name
        2. Definition Attribute
      3. Built-in Attributes
    4. Using Related Entities' Attributes
      1. Parent Entities
      2. Child Entities
        1. Any and All Syntax
        2. Cascading References
        3. ParentRecord
    5. Attributes of Duplicates
  6. Using SemQL in Convergence for MDM
    1. Using SemQL at Design-Time
      1. SemQL in the Certification Process
        1. Certification Process Clauses
        2. Available Attributes by Clause
        3. Certification Process SemQL Example
          1. Enricher Expressions
          2. Validation Conditions
          3. Matcher
      2. SemQL in Privilege Grants
      3. SemQL in Applications
        1. Business Object Filters
        2. Form/Table View Attributes
    2. Using SemQL at Design-Time
      1. Filters
      2. Duplicates Filters
  7. The SemQL Editor
  8. Appendix A: SemQL Functions List