How to filter out specific Change Orders from the Change Calendar based on Category.

book

Article ID: 15367

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction



Is it possible to filter out specific Change Orders from being shown on the Change Calendar by default?

Environment

SDM 12.9SDM 14.1SDM 17.0

Resolution

This can be achieved by modifying the Web Forms Resource.

Administration tab-> Security and Role Management-> Role Management-> Web Forms-> Change Calendar

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKmuAAG" alt="Change calendar.png" width="736" height="582">

 

Then select Edit to modify the Resource.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKmtAAG" alt="change calendar resource.png" width="1245" height="358">

 

To have the filter persist for the Change Calendar string, the Additional Where Clause must be separated from the (sched_start_date>0) that was already there. (I.E: ADDITIONAL_WHERE=(Your Clause) AND (sched_start_date>0)

 

The example below is filtered out by Change Order Category, but the Categories "Code" must be entered into the clause, not the category itself.

$cgi?OP=SEARCH_RETURN_ALL+SID=$SESSION.SID+FID=123+FACTORY=chg+HTMPL=list_chgsched.htmpl+QBE.EQ.active=1+KEEP.isHierSearch=0+schedInitialView=30+init=1+ADDITIONAL_WHERE=(category!%3D'PET')%20%20AND%20(category!%3D'PEN')%20%20AND%20(sched_start_date>0)

 

So any Change Orders that have a Category Code of 'PET' or 'PEN' will not show in the Change Calendar by default.

This can also be verified by viewing the Additional Search Arguments from the Change Calendars Search Filter.

The additional WHERE clause should automatically be entered here.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKmsAAG" alt="additional search arguments.png" width="881" height="497">

Attachments

1558717765657000015367_sktwi1f5rjvs16up0.png get_app
1558717763880000015367_sktwi1f5rjvs16uoz.png get_app
1558717761953000015367_sktwi1f5rjvs16uoy.png get_app