Overview

What's New

General Syntax

Command Syntax Notation

Item Commands

List Admintype Command

About Administrative Object Names

Adding History to Administrative Objects

Common Clauses

Active Clause

Description Clause

Dump Clause

Hidden Clause

history clause

Icon Clause

In Vault Clause

Output Clause

Owner Clause

Property Clause

Recordseparator Clause

Select Clause

Tcl Clause

Visible Clause

Where Clause

application Command

association Command

attribute Command

attribute Command Syntax

Add Attribute Command

Syntax for the Add Attribute Command

Type Clause for the Add Attribute Command

Default Clause for the Add Attribute Command

Reset on Clone or Revision Flag for the Add Attribute Command

Maximum Length Clause for the Add Attribute Command

Dimension Clause for the Add Attribute Command

Format and Keepformat Clause for the Add Attribute Command

Rule Clause for the Add Attribute Command

Range Clause for Add Attribute Command

Range Compared with a Relational Operator for the Add Attribute Command

Range Compared with a Pattern (Special Character String) for the Add Attribute Command

Multiple Ranges for the Add Attribute Command

Ranges Defined Within a Program for the Add Attribute Command

Trigger Clause for the Add Attribute Command

Multiline Clause for the Add Attribute Command

History Clause for the Add Attribute Command

Copy Attribute

Modify Attribute

Check Attribute

Convert Attribute

Print Attribute

Delete Attribute

businessobject Command

businessobject Command Syntax

Add Business Object

Copy Business Object

Print Business Object

Revise Business Object

Modify Business Object

Expand Business Object

Syntax for the Expand Businessobject Command

From Clause for the Expand Businessobject Command

To Clause for the Expand Businessobject Command

Relationship Clause for the Expand Businessobject Command

Type Clause for the Expand Businessobject command

Select To/From Patterns for the Expand Businessobject Command

Relationship and Business Object Patterns for the Expand Businessobject Command

Where Clause for the Expand Businessobject Command

Withroots Keyword for the Expand Businessobject Command

Filter and Activefilter Clauses for the Expand Businessobject Command

Recurse Clause for the Expand Businessobject Command

Set Clause for the Expand Businessobject Command

Structure Clause for the Expand Businessobject command

SELECT_ BO and SELECT_REL Clauses for the Expand Businessobject Command

Terse Clause for the Expand Businessobject Clause

Limit Clause for the Expand Businessobject Command

Size Clause for the Expand Businessobject Clause

Connect Business Object

Connect Business Object for DesignSync File Access

Disconnect Business Object

Disconnect Business Object for DesignSync File Access

Check Business Object

Checkin Business Object

Checkout Business Object

Execute Business Object

Lock Business Object

Unlock Business Object

Sync Business Object

Deduplicatefile and Duplicatefile Businessobject Commands

Delete Business Object

Delete Business Object for DesignSync File Access

Business Object State

Purge Business Object or Business Object List

Rechecksum Business Object or Business Object List

Validate Business Object or Business Object List

Log Business Object Events

businessobject list Command

channel Command

checkshowaccess Command

command Command

compare Command

config Command

connection Command

context Command

dataobject Command

dimension Command

env Command

escape Command

eventmonitor Command

export Command

expression Command

extract Command

filter Command

form Command

format Command

group Command

import Command

index Command

inheritancerule Command

inquiry Command

interface Command

location Command

mail Command

menu Command

monitor Command

mql Command

package Command

page Command

password Command

path Command

pathtype Command

person Command

person Command Syntax

Add Person

Add Person Command Syntax

Access Clause for the Add Person Command

Admin Clause for the Add Person Command

Address Clause for the Add Person Command

Assign Clause for the Add Person Command

Comment Clause for the Add Person Command

Mail Options for the Add Person Command

Fax Clause for the Add Person Command

Fullname Clause for the Add Person Command

Password Clauses for the Add Person Command

Phone Clause for the Add Person Command

Site Clause for the Add Person Command

Type Clause for the Add Person Command

Vault Clause for the Add Person Command

Assignment Selectable for the Add Person Command

History Clause for the Add Person Command

Copy Person

Modify Person

Delete Person

policy Command

policy Command Syntax

Add Policy

Add Policy Syntax

Type Clause for the Add Policy Command

Format Clause for the Add Policy Command

Defaultformat Clause for the Add Policy Command

Sequence Clause for the Add Policy Command

Enforce Clause for the Add Policy Command

State Clause for the Add Policy Command

Store Clause for the Add Policy Command

Allstate Clause for the Add Policy Command

History Clause for the Add Policy Command

Majorsequence and Minorsequence Clauses for the Add Policy Command

Copy Policy

Modify Policy

Modifying Policy States

Modifying Signature Requirements

Print Policy

Delete Policy

portal Command

product Command

program Command

program Command Syntax

Add Program

Add Program Syntax

Code Clause for the Add Program Command

Java or External or MQL Clause for the Add Program Command

Execute Clause for the Add Program Command

Execute User Clause for the Add Program Command

JPOs and Program User Access

Needsbusinessobject Clause for the Add Program Command

Downloadable Clause for the Add Program Command

Piped Clause for the Add Program Command

Pooled Clause for the Add Program Command

Trusted Clause for the Add Program Command

Rule Clause for the Add Program Command

History Clause for the Add Program Command

Copy Program

Execute Program

Compile Program

Extract Program

Insert Program

Modify Program

property Command

query Command

Query Command Syntax

Add Query

Add Query Syntax

Businessobject Clause for the Add Query Command

Vault Clause for the Add Query Command

Limit Clause for the Add Query Command

Expandtype Clause for the Add Query Command

Temporary Query

Evaluate Query

Copy Query

Modify Query

Select Clauses in Queries

Delete Query

Guidelines for Defining Queries

Where Clause Guidelines

Criteria Based on Evaluating Values Against the Execution of a Program Object

Indexed Attributes and Basics

Processing Relational Expressions

Searching Based on Lengthy String Fields

Using .value

Using .isset

Query Syntax

Query Parsing

Selects and Macros in Where Clauses

Searching on Date/Time

Creating Sets to Search

Using Const for Reserved Words

Invalid Where Clauses

Modeling Considerations

Avoiding Unbounded Queries and Large Expands

Object Existence

Query Instantiation

Nested Queries

relationship Command

Relationship Command Syntax

Add Relationship

Add Relationship Syntax

Attribute Clause

Trigger Clause

To and From Clauses

Preventduplicates Clause

Derived Clause

Abstract Clause

History Clause

Dynamic Clause

Compositional Clause

Copy Relationship

Modify Relationship

Delete Relationship

resource Command

role Command

rule Command

searchindex Command

server Command

sessions Command

set Command

set Command Syntax

Add Set Command

Copy Set Command

Modify Set Command

Expand Set Command

Execute Set Command

Print Set Command

Sort Set Command

Delete Set Command

site Command

store Command

Store Command Syntax

Add Store Command

Modify Store Command

Print Store Command

Tidy Store Command

Inventory Store Command

Validate Store

Sync Store Command

Deduplicatefile and Duplicatefile Store Commands

Delete Store Command

Purge Store Command

Rechecksum Store Command

Rehash Store Command

Emptyprefix Store Command

system Command

table Command

Table Command Syntax

Add Table Command

Copy Table Command

Modify Table Command

Evaluate Table

Delete Table Command

Print Table Command

thread Command

toolset Command

trace Command

transaction Command

transition Command

type Command

uniquekey Command

user Command

validate Command

vault Command

version Command

webreport Command

Appendix: Macros

History and Common Usage

Available Macros

Macro Categories

Intrinsic Macros

Business Object Identification Macros

Format Macros

Lifecycle Check and Action Macros

Program Range Macros

Dynamic UI Macros

Connection Macros

JPO Macros

Trigger Macro Categories

Trigger Event Macros

Activity Event Macros

Attribute Event Macros

Business Object Event Macros

Connection Event Macros

Process Event Macros

Query Event Macros

State Event Macros

Appendix: Selectables

About Selectables

Definition Objects

Relationship Direction

Ownership Inheritance

Appendix: MQL Parser Keywords