Difference between revisions of "Relate Issues And Change Orders"

From SDU
Jump to: navigation, search
(added some formatting and code tags. Made the images resizable.)
Line 1: Line 1:
−
== '''PROCEDURE CREATING THE LREL RELATIONSHIP''' ==
+
'''Creating a LREL between Changes and Issues'''
  
 +
= Adding the Cutomization =
 +
==Create a LREL relation between Issue and Change Order ==
 +
# Write a majic file called “lrel1.maj”, in site\mods\majic folder with the following contents:
  
−
2.1 Create a LREL relation between Issue and Change Order
+
<source lang="text" >LREL lrel1 iss impacted_iss <> chg impacted_chg;</source>
−
Step1: Write a majic file called “lrel1.maj”, in site\mods\majic folder
+
  
−
LREL lrel1 iss impacted_iss <> chg impacted_chg;
+
# Recycle the service
 +
# Verify if these objects have been created properly by giving the commands
  
−
Step2: Recycle the service
+
<tt>Bop_sinfo –da chg </tt>
−
Step3: Verify if these objects have been created properly by giving the commands
+
 
−
Bop_sinfo –da chg
+
<tt>Bop_sinfo –da iss</tt>
−
Bop_sinfo –da iss
+
 
−
We can check the same in wsp_schema as well
+
We can check the same information in the wsp_schema table from the MDB.
 
Explanation:
 
Explanation:
−
Impacted_iss is the Lrel object to the Issue Table
 
−
Impacted_chg the Lrel object to the chg Table
 
  
 +
* ''Impacted_iss'' is the Lrel object to the Issue Table
 +
* ''Impacted_chg'' the Lrel object to the chg Table
  
−
2.2 Create a customised htmpl tab page called as “Chg_iss_tab.htmpl”
 
  
 +
== Create a customised htmpl tab page called “Chg_iss_tab.htmpl” ==
  
 +
<source lang="html4strict">
 
<html lang="en"><HEAD>
 
<html lang="en"><HEAD>
 
<PDM_PRAGMA RELEASE=110>
 
<PDM_PRAGMA RELEASE=110>
Line 77: Line 81:
 
</HTML>
 
</HTML>
 
<PDM_IF 0>
 
<PDM_IF 0>
−
 
+
</source>
−
.3 Modifications to detail_chg
+
== Modifications to 'detail_chg.htmpl' ==
 
Create a button to attach issues
 
Create a button to attach issues
 +
<source lang="JavaScript">
 
ImgBtnCreate("UPDATE_LREL", "Attach Issues", "update_lrel('chg', '$args.persistent_id', 'iss', 'impacted_chg',  'Issues', msgtext(211), '')", true, 0);
 
ImgBtnCreate("UPDATE_LREL", "Attach Issues", "update_lrel('chg', '$args.persistent_id', 'iss', 'impacted_chg',  'Issues', msgtext(211), '')", true, 0);
 +
</source>
  
 
Include a Tab called “Related Issues”
 
Include a Tab called “Related Issues”
−
 
+
<source lang="JavaScript">
 
<PDM_TAB ID=rel FILE="chg_iss_tab.htmpl" NAME="Related Issues">
 
<PDM_TAB ID=rel FILE="chg_iss_tab.htmpl" NAME="Related Issues">
 +
</source>
  
−
2.4 Modifications to list_iss
+
== Modifications to 'list_iss.htmpl' ==
 
Add the Below line  
 
Add the Below line  
 +
<source lang="JavaScript">
 
<PDM_IF "$args.KEEP.ForLrel" == "1">
 
<PDM_IF "$args.KEEP.ForLrel" == "1">
 
document.writeln('<INPUT TYPE=hidden NAME=HTMPL VALUE=update_lrel_iss.htmpl>');
 
document.writeln('<INPUT TYPE=hidden NAME=HTMPL VALUE=update_lrel_iss.htmpl>');
 
</PDM_IF>
 
</PDM_IF>
−
 
+
</source>
 
After the line  
 
After the line  
 +
<source lang="JavaScript">
 
<PDM_IF "$args.KEEP.Forchild" == "1">
 
<PDM_IF "$args.KEEP.Forchild" == "1">
 
document.writeln('<INPUT TYPE=hidden NAME=HTMPL VALUE=update_lrel_iss.htmpl>');
 
document.writeln('<INPUT TYPE=hidden NAME=HTMPL VALUE=update_lrel_iss.htmpl>');
 
</PDM_IF>
 
</PDM_IF>
−
 
+
</source>
  
 
Explanation:
 
Explanation:
 +
 
This is added so that when we search for the Issues to be attached to the current Change Request the search page will not go to the default list page but go to the update_lrel_iss page.
 
This is added so that when we search for the Issues to be attached to the current Change Request the search page will not go to the default list page but go to the update_lrel_iss page.
  
Line 105: Line 115:
 
'''Note: Follow the above 4 points with the object Iss(Issue) also'''
 
'''Note: Follow the above 4 points with the object Iss(Issue) also'''
  
−
3. HOW TO ATTACH ISSUES TO CHANGE ORDERS
+
= How to use the Customization =
−
Login to the tool and open the Change Order:
+
 
−
[[Image:detail_chg.jpg]]
+
After logging in the Service Desk web interface, open a Change Order:
 +
[[Image:detail_chg.jpg|480px|center|frame]]
 +
 
 +
When you click on 'Attach Issues' the search filter for Issues will be shown:
 +
[[Image:Attach_Issues.jpg|280px|center|frame]]
  
−
When you click on attach issues
+
Click Search and you'll get a list of Issues
−
[[Image:Attach_Issues.jpg]]
+
[[Image:search.jpg|480px|center|frame]]
  
−
Click Search[[Image:search.jpg]]
+
Add the Tickets that needs to be attached and then see the tab “Issues” to find all the attached Issues to the current Change Order  
−
Add the Tickets that needs to be attached and then see the tab “Issues” to find all the attached Issues to the current Change Order
+
[[Image:Final.jpg|480px|center|frame]]
−
+
−
[[Image:Final.jpg]]
+

Revision as of 13:43, 25 May 2009

Creating a LREL between Changes and Issues

Adding the Cutomization

Create a LREL relation between Issue and Change Order

  1. Write a majic file called “lrel1.maj”, in site\mods\majic folder with the following contents:

<source lang="text" >LREL lrel1 iss impacted_iss <> chg impacted_chg;</source>

  1. Recycle the service
  2. Verify if these objects have been created properly by giving the commands

Bop_sinfo –da chg

Bop_sinfo –da iss

We can check the same information in the wsp_schema table from the MDB. Explanation:

  • Impacted_iss is the Lrel object to the Issue Table
  • Impacted_chg the Lrel object to the chg Table


Create a customised htmpl tab page called “Chg_iss_tab.htmpl”

<source lang="html4strict"> <html lang="en"><HEAD> <PDM_PRAGMA RELEASE=110> <PDM_WSP mode=edit factory=chg preview="NBTAB=chg_iss_tab"> <PDM_INCLUDE FILE=styles.htmpl> <PDM_INCLUDE FILE=std_head.htmpl busy=no> <SCRIPT LANGUAGE="JavaScript" SRC="$CAisd/scripts/sitemods.js"></SCRIPT> </HEAD> <BODY> <PDM_INCLUDE FILE=std_body.htmpl filename=""> <PDM_FORM NAME="frmDTLRO"> <SCRIPT LANGUAGE="JavaScript"> tab_banner("Related Issues List");

docWriteln(""); docWriteln(""); docWriteln(""); docWriteln(""); docWriteln(""); docWriteln(""); <PDM_IF $args.impacted_chg.length == 0 > <PDM_MACRO NAME=dtlStartRow> docWriteln(""); <PDM_MACRO NAME=dtlEndTable> <PDM_ELSE> var counter=0; <PDM_LIST SOURCE=args.impacted_chg> var sClass; if(counter%2) sClass = "results1"; else sClass = "results0"; counter++; var strHTML=""; docWriteln(strHTML); docWriteln(""); docWriteln(''); docWriteln(''); docWriteln(""); </PDM_LIST> </PDM_IF> docWriteln("
Ref#StatusDescription
");

docWriteln("No Issue Attached");

docWriteln("
");

var start_a_tag = "<A" + detailNextID(true) + 

          " HREF=\"javascript:showDetailWithPersid('" +
          '<PDM_FMT ESC_STYLE=C>$args.impacted_chg.persistent_id</PDM_FMT>' +
          "')\">";

var ecsaped_name=<PDM_FMT ESC_STYLE=C>"$args.impacted_chg.ref_num"</PDM_FMT>; end_a_tag="</A>"; docWriteln(start_a_tag+ecsaped_name+end_a_tag);

docWriteln("		<PDM_FMT ESC_STYLE=C PAD=NO>$args.impacted_chg.status.sym</PDM_FMT><PDM_FMT ESC_STYLE=C PAD=NO>$args.impacted_chg.description</PDM_FMT>
");

</SCRIPT> </PDM_FORM> </BODY> </HTML> <PDM_IF 0> </source>

Modifications to 'detail_chg.htmpl'

Create a button to attach issues <source lang="JavaScript"> ImgBtnCreate("UPDATE_LREL", "Attach Issues", "update_lrel('chg', '$args.persistent_id', 'iss', 'impacted_chg', 'Issues', msgtext(211), )", true, 0); </source>

Include a Tab called “Related Issues” <source lang="JavaScript"> <PDM_TAB ID=rel FILE="chg_iss_tab.htmpl" NAME="Related Issues"> </source>

Modifications to 'list_iss.htmpl'

Add the Below line <source lang="JavaScript"> <PDM_IF "$args.KEEP.ForLrel" == "1"> document.writeln('<INPUT TYPE=hidden NAME=HTMPL VALUE=update_lrel_iss.htmpl>'); </PDM_IF> </source> After the line <source lang="JavaScript"> <PDM_IF "$args.KEEP.Forchild" == "1"> document.writeln('<INPUT TYPE=hidden NAME=HTMPL VALUE=update_lrel_iss.htmpl>'); </PDM_IF> </source>

Explanation:

This is added so that when we search for the Issues to be attached to the current Change Request the search page will not go to the default list page but go to the update_lrel_iss page.


Note: Follow the above 4 points with the object Iss(Issue) also

How to use the Customization

After logging in the Service Desk web interface, open a Change Order:

Detail chg.jpg

When you click on 'Attach Issues' the search filter for Issues will be shown:

Attach Issues.jpg

Click Search and you'll get a list of Issues

Search.jpg

Add the Tickets that needs to be attached and then see the tab “Issues” to find all the attached Issues to the current Change Order

Final.jpg
Retrieved from "http://greggsmith.net/wiki/index.php?title=Relate_Issues_And_Change_Orders&oldid=3894"