Increasing Default Field Size - Revision history

Gityerfix at 01:03, 27 July 2008

2008-07-27T01:03:43Z

Gityerfix at 06:13, 26 July 2008

2008-07-26T06:13:46Z

Gityerfix at 15:15, 18 July 2008

2008-07-18T15:15:02Z

Gityerfix at 21:41, 19 March 2008

2008-03-19T21:41:50Z

Gouranga at 19:17, 19 March 2008

2008-03-19T19:17:06Z

Gouranga at 19:15, 19 March 2008

2008-03-19T19:15:53Z

Gouranga: Increasing Default Field Size

2008-03-19T19:14:57Z

Increasing Default Field Size

Gouranga: How to Increase the field length of an out of the box field

2008-03-19T19:13:28Z

How to Increase the field length of an out of the box field

New page

'''How to Increase the field length of an out of the box field'''

'''Requirement:'''
To display multiple attributes in Service Desk multiple notification macro

Ex: To display Urgency, Request Type, Reference Number and Summary in Subject line (see below)

''Urgency @{call_req_id.urgency.sym} - @{call_req_id.type.sym} @{call_req_id.ref_num} - @{call_req_id.summary}''

The subject line of the macro OOB is 80 characters and the system won’t allow you to add multiple attributes to subject line due to character limitation. This change will help you add multiple attributes to your custom Multiple Notification Macros, Initial, Close and Manual Notify activity notifications etc.

The below steps will demonstrate how to increase the field length of Multiple notification macro Subject line field.

Database Table: act_type
Field name: notify_title

'''Step1:'''

Create a Schema (.Sch) file in site/MODS directory as below

'''zAct_Type.sch (Schema definition)'''

TABLE Act_Type {
notify_title STRING 100 ;
}

'''Step 2:'''
Create a MOD (.MOD) file in site/mods/MAJIC directory as below

'''zAct_Type.MOD (Object/Attribute definition)'''

OBJECT aty {
ATTRIBUTES Act_Type {
notify_msg_title STRING 100;

};
};

'''Step 3:'''
Make the change in database.

Table: Act_Type
Field: notify_title
Length: 100

'''Step 4:'''
Configure the primary server
After Configuration, the length definition will be updated in ddict.sch and WSP.

'''Note:'''
1. You need to do all the above 4 steps to make it work successfully.
2. Please note, this is not supported by CA. Try it out first in test box.
3. You must see “Duplicate definition, use MODIFY statement” errors in stdlogs. Please ignore as this wont cause any issues.

You can follow the above steps to increase the field length of properties and other out of the box fields. When you increase field length of properties, you need to make the change both in template and as well as property table (cr_prp, cr_prptpl)

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Customizations]]
-<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 60: / Line 60: @@
 You can follow the above steps to increase the field length of properties and other out of the box fields. When you increase field length of properties, you need to make the change both in template and as well as property table (cr_prp, cr_prptpl)
 ----
-<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 21:41, 19 March 2008
Line 60:		Line 60:

	You can follow the above steps to increase the field length of properties and other out of the box fields. When you increase field length of properties, you need to make the change both in template and as well as property table (cr_prp, cr_prptpl)		You can follow the above steps to increase the field length of properties and other out of the box fields. When you increase field length of properties, you need to make the change both in template and as well as property table (cr_prp, cr_prptpl)
		+
		+
		+	----
		+	<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>

@@ Line 1: / Line 1: @@
-'''How to Increase the field length of an out of the box field'''
+__NOTOC__
@@ Line 18: / Line 24: @@
 Field name: notify_title
+== Procedures ==
 '''Step1:'''
 Create a Schema (.Sch) file in site/MODS directory as below
@@ Line 41: / Line 47: @@
 };
 };
 '''Step 3:'''
@@ Line 60: / Line 65: @@
 You can follow the above steps to increase the field length of properties and other out of the box fields. When you increase field length of properties, you need to make the change both in template and as well as property table (cr_prp, cr_prptpl)

@@ Line 15: / Line 15: @@
 Database Table: act_type
 Field name: notify_title
 Create a Schema (.Sch) file in site/MODS directory as below
@@ Line 27: / Line 28: @@
 notify_title STRING 100 ;
+}
 '''Step 2:'''
@@ Line 44: / Line 46: @@
 Make the change in database.
-Table: Act_Type
+'''Table:''' Act_Type
-Field: notify_title
+'''Field:''' notify_title
-Length: 100
+'''Length:''' 100
 '''Step 4:'''

@@ Line 55: / Line 55: @@
 -- You need to do all the above 4 steps to make it work successfully.
 -- Please note, this is not supported by CA. Try it out first in test box.
--- You must see “Duplicate definition, use MODIFY statement” errors in stdlogs. Please ignore as this wont cause any issues.
+-- You might see “Duplicate definition, use MODIFY statement” errors in stdlogs. Please ignore as this wont cause any issues.
 You can follow the above steps to increase the field length of properties and other out of the box fields. When you increase field length of properties, you need to make the change both in template and as well as property table (cr_prp, cr_prptpl)

@@ Line 53: / Line 53: @@
 '''Note:'''
-.	You need to do all the above 4 steps to make it work successfully.
+-- You need to do all the above 4 steps to make it work successfully.
-.	Please note, this is not supported by CA. Try it out first in test box.
+-- Please note, this is not supported by CA. Try it out first in test box.
-.	You must see “Duplicate definition, use MODIFY statement” errors in stdlogs. Please ignore as this wont cause any issues.
+-- You must see “Duplicate definition, use MODIFY statement” errors in stdlogs. Please ignore as this wont cause any issues.
 You can follow the above steps to increase the field length of properties and other out of the box fields. When you increase field length of properties, you need to make the change both in template and as well as property table (cr_prp, cr_prptpl)