Clarity Service Management

Expand all | Collapse all

Inactive names returned

  • 1.  Inactive names returned

    Posted 10-26-2018 12:00 PM

    Typing in lastname in requester field of change order search returns active and inactive names.  Shouldn't it just return active names.  How would the user know which one to choose?

  • 2.  Re: Inactive names returned

    Posted 10-26-2018 02:49 PM

    Hello Patsy,

    Can you confirm if this has been happening for a while now?  Did this just start happening?


    I did come across something that might be of help, but it does come from an older release of SDM.  I would suggest checking if your test environment has the problem as well, and if it does, try the following:


    1)backup the table usp_pdmMacroParam by command.
    pdm_extract usp_pdmMacroParam > backup.txt

    2)Get the target row by below command.
    pdm_extract -f "select * from usp_pdmMacroParam where caption = 'Extra URL' and id =1487" > target.txt

    3)Modify the value for the 2nd field default_value from "" to "QBE.EQ.delete_flag=0". The record would look like this.
    TABLE usp_pdmMacroParam
    caption default_value del description help_form id is_advanced is_required
    last_mod_by last_mod_dt macro name name_val_localized size_textbox tooltip
    type value_list
    { "Extra URL" ,"QBE.EQ.delete_flag=0" ,"0",
    "For passing extra URL information. Not for general use.",
    "-properties_extraURL_index.html" ,"1487" ,"1" ,"0" ,"" ,"" ,"1150",
    "extraURL" ,"0" ,"" ,"For passing extra URL information" ,"1" ,"" }

    4)Load back the modified target.txt with pdm_load command
    pdm_load -u -f target.txt

    5)Recycle services to take effect.

  • 3.  Re: Inactive names returned

    Posted 10-31-2018 08:28 AM

    This solution works.  I tried it in Development and it fixes the problem, the inactives don’t show up when you are searching in the search window.  I will apply it in production over the weekend.


    Patsy Waring

    EOHHS - CA Service Management - Development & Administration


    Office:   617-847-6502

    Mobile: 321-863-4544

    Mail To:<>

    Mail to: Patricia.waring@DXC.COM<mailto:Patricia.waring@DXC.COM>

    100 Hancock Street - 5th floor- 5217, Quincy, Mass 02171

  • 4.  Re: Inactive names returned

    Posted 10-26-2018 06:41 PM

    Isn't this the default behaviour?
    When trying to enter related , so called SREL attributes, like the requester in a detail edit form, the system restricts the list of possible values to active only ones.
    You don't want to specify an inactive requester, when editing a change.


    But when doing searches for changes,this restriction is not there anymore.
    You need to be able to search for changes with inactive requesters. The requester might left the company, and therefore his record was inactivated.
    But of course you want to be able to search for his changes, he once have requested.


    Sure, the list of autosuggestions might contain duplicates. But you always have the chance to popup the full contact selection list with more information,either by pressing tab or click in on the label of the searchfield.