Object Changes - Revision history

Gityerfix at 21:22, 8 August 2008

2008-08-08T21:22:51Z

Gityerfix at 21:21, 8 August 2008

2008-08-08T21:21:56Z

Gityerfix at 00:55, 27 July 2008

2008-07-27T00:55:17Z

Gityerfix at 05:31, 26 July 2008

2008-07-26T05:31:55Z

Gityerfix at 22:08, 25 July 2008

2008-07-25T22:08:40Z

Gityerfix: /* Example MODIFY Statements */

2008-07-18T14:13:46Z

‎Example MODIFY Statements

Gityerfix at 13:06, 5 July 2008

2008-07-05T13:06:43Z

Gityerfix at 19:34, 14 June 2008

2008-06-14T19:34:43Z

Gityerfix: New page: {| style="width:80%;vertical-align:top;" |- ! style="width:30%;" | Statement ! style="width:70%;" | Description |- | OBJECT | Defines a new business object or changes to an existing object...

2008-06-13T19:03:05Z

New page: {| style="width:80%;vertical-align:top;" |- ! style="width:30%;" | Statement ! style="width:70%;" | Description |- | OBJECT | Defines a new business object or changes to an existing object...

New page

{| style="width:80%;vertical-align:top;"
|-
! style="width:30%;" | Statement
! style="width:70%;" | Description
|-
| OBJECT
| Defines a new business object or changes to an existing object, such as the addition of ATTRIBUTES or TRIGGERS. These statements are generated by the Schema Designer and can be seen in the wsp.mods file. A new FACTORY must be created manually in a custom .mod file.
|-
| MODIFY
| Defines a modification to existing ATTRIBUTES. These statements are generated by the Schema Designer and can be seen in the wsp.mods file. The Schema Designer is limited in its capabilities to modify default ATTRIBUTES which may will require manually creation in a custom .mod file.
|-
| MODIFY FACTORY
| Defines a modification to a default FACTORY. These statements are created manually in a custom .mod file.
|-
|}

== Example OBJECT Statements ==
'''Generated by Schema Designer when creating a new table:'''
<source lang="javascript">OBJECT zchg_type {
DISPLAY_NAME "Change Type";

ATTRIBUTES zchg_type {
delete_flag del SREL actbool
REQUIRED
{
ON_NEW DEFAULT 0;
};
description STRING 480;
sym STRING 100
REQUIRED
DISPLAY_NAME "symbol";
last_mod_dt DATE { ON_CI SET NOW; };
last_mod_by SREL cnt { ON_CI SET USER;
ON_NEW DEFAULT USER; };
};

FACTORY zchg_type {
STANDARD_LISTS {
MLIST OFF;
RLIST OFF;
};
FUNCTION_GROUP "change_mgr";
REL_ATTR id;
COMMON_NAME sym;
};
};</source>

'''Generated by Schema Designer when adding a custom COLUMN or TRIGGER to an existing table:'''
<source lang="javascript">OBJECT cr {
ATTRIBUTES Call_Req {

zxfer_reason SREL zxfer_reason

DISPLAY_NAME "Transfer reason";
};

TRIGGERS {
POST_CI val_fieldupdate_site(persistent_id, audit_userid, CHANGED_ONLY, type) 57 FILTER(EVENT("UPDATE"));
};
};</source>

'''Generated manually when creating a new FACTORY:'''
<source lang="javascript">OBJECT cr {
FACTORY zallcrs {
STANDARD_LISTS {
SORT_BY "open_date DESC, id DESC, status, priority DESC, ref_num";
MLIST OFF;
RLIST OFF;
};
FUNCTION_GROUP "call_mgr";
REL_ATTR persistent_id;
COMMON_NAME ref_num;
};
};</source>

== Example MODIFY Statements ==
'''Generated by Schema Designer when changing a default ATTRIBUTE:'''
<source lang="javascript">MODIFY cr status
{
REQUIRED;
};</source>

'''Generated manually when making a change to a default ATTRIBUTE not possible in the Schema Designer:'''
<source lang="javascript">MODIFY cr impact
{
ON_NEW DEFAULT 2;
};</source>

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Customizations]]
 [[Category:r6]]
 [[Category:r11]]

@@ Line 1: / Line 1: @@
 __NOTOC__
-[[Category:Customization]]
+[[Category:Customizations]]
 {{Global Header}}
 {{Global Announcement}}

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Customization]]
-<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
+{{Global Header}}
-To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>
+{{Global Announcement}}
 == Overview ==

@@ Line 98: / Line 98: @@
 ----
-<div align='center'><font color="red">To make corrections or additions to this article, select the ''edit'' tab above.<br>
+<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
 To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>

← Older revision		Revision as of 13:06, 5 July 2008
Line 1:		Line 1:
		+	[[Category:Customization]]
	{\| style="width:80%;vertical-align:top;"		{\| style="width:80%;vertical-align:top;"
	\|-		\|-

@@ Line 20: / Line 20: @@
 |-
 |}
 == Example OBJECT Statements ==
@@ Line 52: / Line 51: @@
    };
 };</source>
 '''Generated by Schema Designer when adding a custom COLUMN or  TRIGGER to an existing table:'''
@@ Line 67: / Line 65: @@
    };
 };</source>
 '''Generated manually when creating a new FACTORY:'''
@@ Line 82: / Line 79: @@
    };
 };</source>
 == Example MODIFY Statements ==

@@ Line 1: / Line 1: @@
 [[Category:Customization]]
 {| style="width:80%;vertical-align:top;"
 |-
@@ Line 15: / Line 20: @@
 |-
 |}
@@ Line 86: / Line 90: @@
      REQUIRED;
 };</source>
 '''Generated manually when making a change to a default ATTRIBUTE not possible in the Schema Designer:'''
@@ Line 94: / Line 96: @@
      ON_NEW DEFAULT 2;
 };</source>

← Older revision		Revision as of 19:34, 14 June 2008
Line 93:		Line 93:
	ON_NEW DEFAULT 2;		ON_NEW DEFAULT 2;
	};</source>		};</source>
		+
		+
		+
		+	----
		+	<div align='center'><font color="red">To make corrections or additions to this article, select the ''edit'' tab above.<br>
		+	To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>