"List Order By" parameter with the dropdown list box on WSP.

Document ID : KB000020111
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

In CA Service Desk Manager (CA SDM) Web Screen Painter, there is the "List Order By" parameter on the dtlDropdown properties (as shown in Figure 1).

When a value is set here, it does not seem to be effectively functioning, Is this a problem?

Figure 1:

Figure 1

Solution:

It is necessary to set some parameters when the "List Order By" is used. This knowledge document focuses on the "Status" and "Impact" fields as examples.

Out of the box, the status and impact fields are coded as following in the form detail_in.htmpl file.

<PDM_MACRO name=dtlDropdown hdr="Status" attr=status factory=crs_in>

<PDM_MACRO name=dtlDropdown hdr="Impact" attr=impact evt="onBlur='manual_modify();detailSyncEditForms(this)'" lookup=no>

"List Order By" on the properties on the WSP is specified as "list_orderby" in the source of the htmpl file. In order to specify with the "list_orderby", it is necessary to set the following factors.

  • factory : Factory name that is linked to the dropdown listbox.
  • list_display : Set $list.COMMON_NAME or $list.sym .
  • rel_attr_name : Set REL_ATTR .
  • list_orderby : Set id or enum (CA Support verified "code" and "sym" worked with "Status" field).

The sort order will be Ascending with the specified column here. Not possible the Descending.

  • use_list_display : Set 1.
  • whereclause : Needs to set even if all existed values are target.

So one could modify status and impact definitions to include the list_orderby clause as below:

  • Status

    <PDM_MACRO name=dtlDropdown hdr="Status" attr=status factory=crs_in list_display="$list.COMMON_NAME" list_orderby="code" rel_attr_name="REL_ATTR" use_list_display="1" whereclause="sym<>'XX'">

    <PDM_MACRO name=dtlDropdown hdr="Status" attr=status factory=crs_in list_display="$list.COMMON_NAME" list_orderby="sym" rel_attr_name="REL_ATTR" use_list_display="1" whereclause="sym<>'XX'">

  • Impact

    <PDM_MACRO name=dtlDropdown hdr="Impact" attr=impact evt="onBlur='manual_modify();detailSyncEditForms(this)'" lookup=no factory=imp list_display="$list.sym" list_orderby="sym" rel_attr_name="REL_ATTR" use_list_display="1" whereclause="enum=0 OR enum=3 OR enum=5">

    <PDM_MACRO name=dtlDropdown hdr="Impact" attr=impact evt="onBlur='manual_modify();detailSyncEditForms(this)'" lookup=no factory=imp list_display="$list.sym" list_orderby="enum" rel_attr_name="REL_ATTR" use_list_display="1" whereclause="enum=0 OR enum=3 OR enum=5">

Note: This knowledge document provides just an example for reference. Creating customizations is normally out of the realm of standard CA Technologies Support engagements.