CA Service Management

Expand all | Collapse all

Lookup to return values based on data partition without extra Search click

Jump to Best Answer
  • 1.  Lookup to return values based on data partition without extra Search click

    Posted 09-29-2016 11:29 AM

    Background:

     

    Customer is moving off r11.2 and will be using Incidents for the first time.  This is a maturing process and all incoming tickets from employees will start as Request. Employees will be able to set Urgency for a Request but not Priority.  All inbound email tickets will be the lowest priority.  Tier 1 will determine if it is an Incident.  They will gather reports as time goes on to determine next improvements.  They are not using Priority Calculation in order to have consistent usage between Requests and Incidents.  

     

    They do want default Priorities on Request/Incident areas.  OOTB, Areas Defaults only apply to Assignee, Group, and Urgency - not Priority.

     

    I have already modified the pcat schema to add a link to priority table.  Thanks to cdtj, I have modified load_properties.htmpl to pull this value when an Area is chosen and they tab out of the field as with the other defaults.  However, this only populates the Priority field if it is set to Lookup instead of Dropdown.

     

    ISSUE:

     

    I need to either

    1:  Change the Lookup so it pops up with all the available Priorities based on the data partition - without them having to hit Search in the pop-up window.  The macro definition for dtlLookup does not include adding a whereclause.  This should function the same as if you clicked Priorities from the Administration->Service Desk->Codes->Application Data->Priorities - except respect the data partition for the analyst, OR

    2:  Figure out how to make this update the dropdown.

     

    Notes:

    There will only be 3 available priorities.  Since we are not supposed to inactivate Priorities, I have modified the dropdown attributes to limit the priority choices to 1,2,3 as well as created a data partition table for Priorities. 

     

    I have also create a .mod file to set priority on cr on new to a dummy value in order to eliminate the 'None' value.  This replaces it with a '?' in the dropdown and forces some value to be chosen. 

     

    None of this affects the back-fill of the default value from the Area.  Even the OOTB Priorities and dropdown attributes do not work for a backfill.

     

    J.W.



  • 2.  Re: Lookup to return values based on data partition without extra Search click

    Posted 10-03-2016 05:49 PM

    Hi,

    seems that I can help you with one of your issues

    1. to load search results instead of initial search form you need to predefine at least one param (excluding param defined by DOMSET), for priority lookup it could be "id greater than 0":

    <PDM_MACRO name=dtlLookup .... extraURL="QBE.GT.id=0">

     

    Also if you have problems with OOTB dropdown you can easy build your own using detailDropdown function OR it could be totally modified using JS (yeah js again ).

     

    Regards,

    cdtj



  • 3.  Re: Lookup to return values based on data partition without extra Search click
    Best Answer

    Posted 10-13-2016 05:21 PM

    Thanks, cdtj

     

    Between this and another thread you assisted on I have the solution using the Lookup macro.

    It was extraURL="ADDITIONAL_WHERE=( id = 502 or id = 503 or id = 504 )"

     

    Cheers,

     

    J.W.