CA Service Management

 View Only
Expand all | Collapse all

How to Restrict Chg Workflow statuses by Data partition

  • 1.  How to Restrict Chg Workflow statuses by Data partition

    Posted Jul 30, 2019 10:35 AM


    Hi Team

    How can we restrict Change Workflow Status by Data Partition? I cant see tskstat table while creating data partition constraint.

    On some workflow task types, We have Four Statuses,

    1.Pending
    2.Approved
    3.Reject
    4.Audit Required
    5.Skip

    SO once those workflow trigger with pending status, Change Manager decides whether Audit Required they change the status to 'Audit Required' and then audit team get notification to take action on it. When audit team done their work and change the status, They should Only See APPROVE and REJECT, no other status should be seen.

    How can we achieve this?

    #ca_sdm_17.1
    #caservicedesk17.0 

    ​​​​​


  • 2.  RE: How to Restrict Chg Workflow statuses by Data partition
    Best Answer

    Posted Jul 30, 2019 11:00 AM
    Hi Aamir,

    You can add tskstat to ctab object, after do that you can see tskstat in the constraints of datapartitions.

    ------------------------------
    Regards,
    Yonatan Sosa Sanchez
    IT Services Specialist
    ------------------------------



  • 3.  RE: How to Restrict Chg Workflow statuses by Data partition

    Posted Jul 30, 2019 01:07 PM
    Edited by Aamir Khan Jul 30, 2019 01:33 PM
    Hi Yonatan

    Thanks for advising

    I have successfully upload that using pdm load.

    The constraint i used

    code LIKE 'APP'


     but still when going to approver page, all statuses are showing. Can you please advise on it.










  • 4.  RE: How to Restrict Chg Workflow statuses by Data partition

    Posted Jul 31, 2019 08:47 AM
    Just to check before going further,

    Do you test with the same account/role that you make the modification to the DP with?

    If yes you are probably using an admin role that is not affected by your DP.


  • 5.  RE: How to Restrict Chg Workflow statuses by Data partition

    Posted Jul 31, 2019 10:25 AM
    Hi Pier

    Yes i was checking from Admin user, But just now i have checked with other use as well who has IT Staff accesstype. But still it showing all statuses.


  • 6.  RE: How to Restrict Chg Workflow statuses by Data partition

    Posted Jul 31, 2019 10:55 AM
    As per another post, there seems to be some weird things going on with DP on task statuses. One of my customer went the other way and restricted the available statuses from the htmpl web page with a where clause on the dropdown.


  • 7.  RE: How to Restrict Chg Workflow statuses by Data partition

    Posted Aug 01, 2019 01:20 PM
    Can you advise with the code on detail_wf.hmpl page. 

    May be we can do this with <pdm_IF> 

    supposing role code is 'KTRE'


  • 8.  RE: How to Restrict Chg Workflow statuses by Data partition

    Posted Aug 02, 2019 08:32 AM
    As per what I know, you do not easily have access to current Role used by the logged in user. Only the access type.

    What we did is use form group.

    As for the code itself :
    <PDM_MACRO name=dtlDropdown hdr="Status" attr="status" lookup=no size=20 whereclause="code in ('test')">


  • 9.  RE: How to Restrict Chg Workflow statuses by Data partition

    Posted Aug 05, 2019 04:26 AM
    Edited by Aamir Khan Aug 05, 2019 04:31 AM
    Dear Pier

    i have webform name 'rest'.  I have a copy of level2 role which name is  'Status Hide' and it  is bind with the webform 'rest'.

    In thi swebform i have detail_wf.htmpl file where i have following code for status by default

    <PDM_MACRO name=dtlReadonly hdr="Status" attr=status.sym colspan=2>

    when i put below whereclause in above pdm_macro and saves the page, that where clause vanishes... Pls advise.

    whereclause="code in ('APP')"





    ​​


  • 10.  RE: How to Restrict Chg Workflow statuses by Data partition

    Posted Aug 05, 2019 07:24 AM
    WhereClause and dtlreadonly aren't compatible.
    You need to use a dtlLookup .


  • 11.  RE: How to Restrict Chg Workflow statuses by Data partition

    Posted Aug 05, 2019 07:44 AM
    Hi Pier

    this is also not working. web engines fails to connect for this page. may be something we are missing.  ...


  • 12.  RE: How to Restrict Chg Workflow statuses by Data partition

    Posted Aug 05, 2019 07:48 AM
    I'm on vacation and do not have access to a system right now. If no one else can help you, I will be able in 2 or 3 days.