Adding a Checkbox to a Custom Helpdesk Page

Here are the steps I worked out to add a custom checkbox to a form on a Helpdesk page. Hopefully it will help someone else looking for a way to add similar functionality to their forms.

• Run SQL server
• Select Altiris database Incident
• Run this SQL :
  

  ALTER TABLE workitem ADD checkbox1 nchar(1) NOT NULL DEFAULT
  (N'')
  EXEC sp_addviewdef N'workitem_only_view', N'workitem.checkbox1
  AS workitem_checkbox1', N''
  EXEC sp_createHDDview 'workitem_only_view', 'workitem'
  EXEC sp_createHDDview 'workitem_detail_view', 'workitem_only_view'
  if exists (select * from sysobjects where id 
  =object_id(N'[dbo].[workitem_current_view]') and OBJECTPROPERTY(id,N'IsView') = 
  0)drop view [dbo].[workitem_current_view]
  
  

  (Replace all instances of the "checkbox1" with the name of your field.)

• Run this sql:
  

  CREATE VIEW dbo.workitem_current_view AS SELECT workitem_detail_view.* FROM 
  workitem_detail_view WHERE (workitem_is_last = N'1')
  
  

Modify the Worker Page in View Mode

• Open your "customworkitemview.ascx"
• Find the line with:
  

  </script> 
  <aw:layout id="loItem" runat="server" HorizontalAlign="Justify" Width="100%" 
  columns="4" ItemDataSourceName="WorkItem"...
  
  

• Paste this before:
  

  Protected Function IsYes(x) as String
  'converts the value stored for initials and other yes/no options from int to a boolean. 
  If x = "1" then
  return "Ok"
  Else 
  return "Nok"
  End If
  End Function
  
  

• Find the line with:
  

  <aw:Label id="lblType" runat="server" ColSpan="4" 
  ItemDataField="workitem_type_lookup_value" label="sidLblType"></aw:Label>...
  
  

• Paste this before:
  

  <aw:Label id="cbcheckbox1Yes" ItemDataField="workitem_checkbox1" width="80px" 
  runat="server" visible="false" /></aw:Label>	
  <aw:Label id="lblcheckbox1" ColSpan="4" runat="server" label="checkbox1" runat="server"
  Text="<%# IsYes(cbcheckbox1Yes.text) %>" CssClass="clsToolbar" width="30px"/>
  
  

Modify the Worker Page in Edit Mode

• Open your "customworkitemeditgeneral.ascx"
• Find the line with:
  

  <aw:DropDownList id="ddlPriority" runat="server" Width="100%"
  ItemDataField="workitem_priority_lookup_id" Label="sidLblPriority" DataTextField="value"
  DataValueField="id" DataSourceName="Priorities" currentValue="True"></aw:DropDownList>...
  
  

• Paste this before:
  

  <aw:CheckBox id="cbcheckbox1" runat="server" label="test checkbox1:" ColSpan="4"
  ItemDataField="workitem_checkbox1" valuechecked="1" valueunchecked="0" text="<-- this is an example1"></aw:CheckBox>
  

Results (with 2 checkboxes)

Edit mode

Click to view.

View mode

Click to view.