MQL Syntax Cheat Sheet by [deleted]

add dimension NAME
	description VALUE
 	icon FILENAME WITH PATH
 	[!inot]hidden
	property NAME [to ADMINTYPE NAME] [value STRING] 
	unit UNITNAME label UNITLABEL multiplier MULTIPLIER offset OFFSET 
	[!inot]default 
	property NAME [to ADMINTYPE NAME] [value STRING] 
	setting NAME VALUE 
	history STRING;

	add type NAME 
		description VALUE 
		icon FILENAME WITH PATH 
		attribute NAME {, NAME} 
		derived TYPE NAME 
		abstract [truelfalse] 
		method PROG NAME {, PROG NAME} 
		trigger EVENT TYPE {actionlcheckloverride} PROG NAME [input ARG STRING] 
		[!|not]hidden 
		property NAME [to ADMINTYPE NAME] [value STRING] 
		history STRING;

	add format NAME 	
		description VALUE 
		icon FILENAME_ WITH PATH 
		creator NAME (Not Used) 
		type NAME (Not Used) 
		version VALUE 
		[!Inot]hidden 	
		suffix VALUE 
		mime VALUE 
		property NAME [to ADMINTYPE NAME] [value STRING] 
		history STRING;

	add group "group_name" 
		assign person "person name" 
		assign role "role_name" 
		description "group_description" 
		icon [path] child "group_name" 
		parent "group_name" 
		[not]hidden;

	add person "person_name"
		access "user access values"
		admin "bus and/or system access rights"
		address "address_value"
		assign "groupe role"
		assign "role_name"
		comment "comment_text"
		enable/disable email
		enable/disable iconmail
		email "email_address"
		fax "fax_number"
		fullname "fullname_value"
		phone "phone number"
		site "default site"
		vault "vault name"
		password "value"
		no password
		disable password
		type of user
		[not]hidden;

add dimension Weight
	description "Weight of the item" 
	unit g 
	default 
	label Grams 
	unitdescription "Weight in Grams (Default)" 
	multiplier 1.0
	offset 0.0 
	unit Kg
	label Kilograms 
	unitdescription "Weight in Kilograms" 
	multiplier 1000.0 
	offset 0.0;

	add type PART 
		abstract true 
		description "Part for a computer" 
		attribute Cost,Source,Weight; 

Or
 
	add type Customer
		description "Customer information" 
		icon <path of the directory> /HCCgifs/Customer.gif 
		abstract false attribute "Account Number" 
		attribute Addressl 	
		attribute Address2 
		attribute Address3 
		attribute City 
		attribute ID 
		attribute State 
		attribute "Zip Code";

	add format Word 	
		version "Office2010" 
		description "Microsoft Word" 
		suffix ".docx";

	add group Manufacturing 
		parent "HCC" 
		assign person "Joe Jackson" 
		assign person "Dave Matthews";

	add person Joe
		access all
		email joe
		fullname "Joe Jackson"
		type full,business
		vault Engineering
		no password
		icon <path of the directory> /Icons/Joe.gif
		assign role President
		assign group Manufacturing
		assign group Sales
		assign group "HVV Corp";

	add policy Production 
	enforce 
	description "Policy to govern 

PARTS„ 

	sequence A,B,C,... 
	store Production 
	type PART 
	format Excel 
	format Word defaultformat Word 
	state Planned 
		version false 
		revision false 
		promote false 
		checkouthistory false 
		owner all 
		public all 
	state Active 
		version false 
		revision true 
		promote false 
		checkouthistory false 
		owner all 
		public read,show

	add attribute NAME 
		description VALUE 
		icon FILENAME_ WITH PATH 
		type [integer, string, real, boolean, date] 
		default VALUE range = RANGE_ITEM 
		[not]hidden 
		[not]multiline 
		[not]rangevalue 
		[not]multivalue 
		dimension DIMENSION NAME;  
		trigger modify PROG_TYPE PROG NAME [input ARG_STRING];

	add relationship "relationship_ name" 
		description "relationship_description" 
		icon [path]_name 
		attribute ATTRIBUTE NAME 
		trigger EVENT_TYPE TRIGGER TYPE PROG_NAME [!| not]preventduplicates 
		derived RELATIONSHIP NAME 
		abstract [truelfalse] 
		[!lnot]hidden 
		property NAME [to ADMINTYPE NAME] [value STRING]
		history STRING 
		from 
			type "from types" 
			meaning "meaning_text" 
			cardinality [one, many] 
			revision [none, float, replicate] 
			clone [none, float, replicate] 
			[not] propagatemodify 
		to
			type "to_types" 
			meaning "meaning_text" 
			cardinality [one, many] 
			revision [none, float, replicate] 
			clone [none, float, replicate] 
			[not] propagatemodify;

add role "role name" 
		assign person "person_name" 
		assign group "group_name" 
		description "description_name" 
		icon [path] child "role name" 
		parent "role name" 
		[not]hidden;

	add policy NAME
		description VALUE
		icon FILENAME_WITH_PATH
		type TYPE_NAME (,TYPE_NAME)
		type all
		format FORMAT_NAME (,FORMAT_NAME)
		format all
		defaultformat FORMAT_NAME
		sequence REVISON_SEQUENCE
		[not]enforce
		store STORE_NAME
		allstate USER_ITEM ACCESS_ITEM (,USER_ITEM ACCESS_ITEM)
		[!|not]hidden
		property NAME [to ADMINTYPE NAME] [value STRING]
		history STRING

	state Obsolete 
	version false 
	revision true 
	promote false 
	checkouthistory false 
	owner all 
	public read,show; 

modify policy "Production" 
	state "Planned" 
	add signature "Ready" 
	approve "Vice President" 
	reject "Vice President" 
	state "Active" 
	add signature "Obsolete" 
	approve "Vice President" 
	reject "Vice President";

	add attribute "Screen Size in Inches" 
		description "The diagonal measure of a monitor screen in inches" 
		type string default 15 
		range = 15 
		range = 17 
		range = 19 
		range = 21;

	add relationship "System Box Assembly" 
		description "Relationship for assembling the major components of the System Box" 
		attribute "Quantity" 
		from 
			type "System Box" 
			meaning "Is comprised of..." 
			cardinality many 
			revision replicate 
			clone none 
		to	
			type "SYSTEM BOX PART" 
			meaning "is a component of..." 
			cardinality many 
			revision float 
			clone none;

	add program NAME 
		description VALUE 
		icon [path] 
		java|external|mgl
		execute immediateldeferred 
		execute user USER NAME 
		[!l not] needsbusinessobject 
		[!lnot]downloadable 
		[!lnot]pipe 
		[!lnot]pooled 
		[!lnot]hidden 
		rule NAME 
		property NAME [to ADMINTYPE NAME] [value STRING] 
		history STRING 
		code "command or code";

	add role Shipper
	description "Shipper in the company";

	state STATE_NAME
		action COMMAND
		check COMMAND
		notify USER_NAME {,USER_NAME} message VALUE
		notify signer message VALUE
		route USER_NAME message VALUE
		owner ACCESS_ITEM {,ACCESS_ITEM}
		public ACCESS_ITEM {,ACCESS_ITEM}
		user USER_NAME ACCESS_ITEM {,ACESS_ITEM} [filter EXPRESSION]
		signature SIGN_NAME [SIGNATURE_ITEM {, SIGNATURE_ITEM}]
		stateproperty NAME [to ADMINTYPE NAME] [value STRING]
		trigger EVENT_TYPE TRIGGER_TYPE PROG_NAME [input ARG_STRING]
		revision [true|false]		
		version [true|false]
		promote [true|false]
		icon FILENAME
		checkouthistory [true|false];

	Signatures are usually added to the policy afterwards:
	
	modify policy "policy name"
		state "state name"
		add signature "signature name"
		approve "user_name"
		reject "user_name";