Topic
9 replies Latest Post - ‏2012-12-13T11:25:32Z by Keith6868
Keith6868
Keith6868
15 Posts
ACCEPTED ANSWER

Pinned topic Maximo - creating an object data restriction using values from main object

‏2012-12-11T12:29:40Z |
I want to create an object restriction on the 'EVERYONE' security group on the 'Status' field on an incident ticket so that, if the current status is 'RESOLVED', the status dropdown will only contain the 'CLOSED' and 'CANCELLED' statuses.

Unfortunately, I can't work out whether it is possible to achieve this effect.

So far, I have:

Object: SYNONYMDOMAIN
Application: INCIDENT
Type: QUALIFIED
Condition: domainid = 'INCIDENTSTATUS' and (maxvalue 'RESOLVED' or ....

and am stumped for what might come next. I do not know how to refer to the 'status' value on the incident so as to get the effect of:

:status = 'RESOLVED' and maxvalue in ('CLOSED','CANCELLED'))

Is this effect possible and how do I frame the condition?
Updated on 2012-12-13T11:25:32Z at 2012-12-13T11:25:32Z by Keith6868
  • Keith6868
    Keith6868
    15 Posts
    ACCEPTED ANSWER

    Re: Maximo - creating an object data restriction using values from main object

    ‏2012-12-11T12:51:54Z  in response to Keith6868
    Sorry, my conditions are all wrong. I think this is right:

    Condition:

    domainid = 'INCIDENTSTATUS' and
    (maxvalue in ('CLOSED','CANCELLED') or ...

    and the bit that is missing should have the effect of:

    :status != 'RESOLVED')

    Needless to say, that second clause does not work.
  • SystemAdmin
    SystemAdmin
    5842 Posts
    ACCEPTED ANSWER

    Re: Maximo - creating an object data restriction using values from main object

    ‏2012-12-12T03:56:38Z  in response to Keith6868
    You don't need to do it that way - if you have the condition in Conditional Expression Manager, just go into the Domains application and find the INCIDENTSTATUS domain. There is a place to put a condition there, next to each specific value.
    Shannon
  • SystemAdmin
    SystemAdmin
    5842 Posts
    ACCEPTED ANSWER

    Re: Maximo - creating an object data restriction using values from main object

    ‏2012-12-12T08:23:29Z  in response to Keith6868
    Hi Keith,

    Do this..
    Step 1:
    From Conditional expression manager create new condition exp:1010
    object: INCIDENT
    Expression= :status not in(‘RESOLVED’)

    Step 2:
    Goto Domains Application search for the INCIDENTSTATUS domain.
    Select the internal statuses which are displaying when the incident status is in RESOLVED except CLOSED,CANCELLED.
    Then from set conditions button add New row
    Add previous created condition 1010 to all selected values(statuses) and then save.
    Now when the incident is in RESOLVED status then status dropdown displays only 'CLOSED' and 'CANCELLED' statuses.
    • SystemAdmin
      SystemAdmin
      5842 Posts
      ACCEPTED ANSWER

      Re: Maximo - creating an object data restriction using values from main object

      ‏2012-12-12T09:40:54Z  in response to SystemAdmin
      Hi Keith ,

      I think ajays trick should work...we can put conditions fopr every synonymn domain value....

      else this can be handelled in bean class customization..
  • Keith6868
    Keith6868
    15 Posts
    ACCEPTED ANSWER

    Re: Maximo - creating an object data restriction using values from main object

    ‏2012-12-12T17:11:23Z  in response to Keith6868
    Thanks for this tip: sounds more promising and less complicated than what I was doing. However, I haven't managed to make it work yet.

    I am using Maximo 7.1.1.5. Here is what I did as a test:

    1. Click on 'Go To > System Configuration > Platform Configuration > Domains'
    2. Search for 'INCIDENTSTATUS'
    3. Click to get values for the domain (Synonym Domain' dialogue box)
    4. Expand 'INPROG' status
    5. Click on 'View/Modify Conditions' button
    6. Value ID pf 'INCIDENTSTATUS|INPROG' comes up in dialogue box
    7. Click on brown arrow next to 'Condition Number' and menu option 'Select Value'
    8. Filter list for Condition '1012' (previously set up to contain "status in ('RESOLVED'))
    9. Click on condition '1012'. 'View/Modify Conditions' dialogue box now shows 'Condition Number' as '=1012'
    10. Click on 'OK'
    11. Click on 'OK' on 'Synonym Domain' dialogue box
    12. Click on 'Save Domain'

    Then, I repeated steps 3 to 6 to check that the condition was still there: it wasn't - the 'Condition Number' box was blank.

    I tried to populate it a couple more times with the same result.

    In forlorn hope, I opened an incident in 'RESOLVED' status and the 'In Progress' status is still showing.

    So I seem to have a problem getting Maximo to store the condition number. Anyone come across that problem?
    • MaximoLearner
      MaximoLearner
      35 Posts
      ACCEPTED ANSWER

      Re: Maximo - creating an object data restriction using values from main object

      ‏2012-12-13T05:38:18Z  in response to Keith6868
      After step 12, run this script

      SELECT * FROM MAXDOMVALCOND WHERE DOMAINID = 'INCIDENTSTATUS'

      if you found any result related your conditionnum, it means record is saved.

      Even after saving you are able to see INPROG status in RESOLVED incident, then turn admin mode ON and turn admin mode OFF.

      Hope it works.
      • MaximoLearner
        MaximoLearner
        35 Posts
        ACCEPTED ANSWER

        Re: Maximo - creating an object data restriction using values from main object

        ‏2012-12-13T05:41:16Z  in response to MaximoLearner
        And also I observed that at step 8: Filter list for Condition '1012' (previously set up to contain "status in ('RESOLVED'))

        I think you have to change conditon as "status not in ('RESOLVED')"

        Cheers,
        NJSReddy
  • Keith6868
    Keith6868
    15 Posts
    ACCEPTED ANSWER

    Re: Maximo - creating an object data restriction using values from main object

    ‏2012-12-13T10:48:41Z  in response to Keith6868
    I found out why this would not work for me.

    There is a 'New Row' button in the 'View/Modify Conditions' dialog box but, despite having super-user permissions, it does not appear on my screen.

    Hence, the boxes I was taking to be data entry boxes are actually just filter boxes.

    If I go to Application Designer, find that button, click on its 'Properties' and remove the 'Signature Option' currently set to 'ADDCONDITION' and save, then go back to the Domain Administration application, I am now able to see the 'New Row' button and use it to add conditions.

    My test now works so many thanks for the help on this.
  • Keith6868
    Keith6868
    15 Posts
    ACCEPTED ANSWER

    Re: Maximo - creating an object data restriction using values from main object

    ‏2012-12-13T11:25:32Z  in response to Keith6868
    Just in case anyone is interested, the problem I encountered with the 'New Row' button is acknowledged as a bug: APAR 'IZ64904'.

    The APAR proposes a workaround which does not involve removing the 'ADDCONDITION' signature option from the 'New row' button properties on 'View/Modify Conditions' which seems to work.

    This bug is fixed in 7.1.1.6.