Precisely Enterworks

 View Only
  • 1.  editing an attribute based on the value of another attribute

    Posted 02-03-2023 11:14
    Hi All,
    is there a way to make an attribute editable based on the value of another attribute?

    we want users to be able to edit an attribute in the Product repository called "Intro Date" ONLY when another attribute in the Product repository called "Product Status" equals N or R.
    is this possible?
    thanks!
    Ruthy


    ------------------------------
    Ruthy Sleeth | Business Process Analyst
    New Pig | 814-686-2254
    ------------------------------


  • 2.  RE: editing an attribute based on the value of another attribute

    Posted 02-07-2023 10:38
    Hi Ruthy,

    It sounds as if you're wanting to adjust the Attribute Security Filter in real time, which I've never seen in my experience (unless EW has a trick up it's sleeve that I'm not aware of.). To go over the need here, essentially, you want Intro Date to be available only when Product Status equals N or R. Correct?

    What you can do is create a rule that will cause a validation error if Intro Date has a value in it when Product Status does not equal N or R. At least, the system will throw an error and the explanation as to why the rule is there will be available for the user to read.

    Does that work?

    Best,
    -Jon

    ------------------------------
    Jon Varo | Manager - Master Data and PIM Teams
    Fender Musical Instruments Corporation | (480) 845-5823
    ------------------------------



  • 3.  RE: editing an attribute based on the value of another attribute

    Posted 02-07-2023 10:59

    Hi Jon,

    Thank you for the suggestion – it's close.  You are correct in that we want the user to be able to edit the Intro Date only when Product Status equals N or R, however, Intro Date always needs a value.  Intro Date can be updated when the Product Status is N or R, but once the Product Status is A, then Intro Date can no longer be updated.

     

    So to create a rule to error when the Product Status = A and Intro Date was changed from one value to another.  I don't know how to do this last part.

     

    Thanks

    Ruthy

     






  • 4.  RE: editing an attribute based on the value of another attribute

    Posted 02-07-2023 11:46
    How about creating a date field, named "Restricted Intro Date", not visible to users?
    Create a rule or change notification that will always copy the value from Intro Date into Restricted Intro Date when Product Status is not a "locked value".

    When the Product Status is set to the locked value, reverse the rule... now Intro Date mimics the final entered value of Restricted Intro Date. Every time a user tries to change the value of Intro Date while Product Status is N or R, they won't be able to because the system will simply ignore the new entry in favor of what's in the Restricted Intro Date field.

    Would that work?

    ------------------------------
    Jon Varo | Manager - Master Data and PIM Teams
    Fender Musical Instruments Corporation | (480) 845-5823
    ------------------------------



  • 5.  RE: editing an attribute based on the value of another attribute

    Posted 02-07-2023 12:45

    That sounds like that would work.  thank you so much, Jon for your input.  It's greatly appreciated!!

    ��

    Ruthy

     






  • 6.  RE: editing an attribute based on the value of another attribute

    Employee
    Posted 03-08-2023 18:16

    Jon,

    Any attribute that needs to be accessed by Change Notification processing can only be hidden by placing it on a tab that is hidden, but not by security.  If a user cannot access an attribute due to an Attribute Security Filter, then Change Notification will not be able to access that attribute when that user causes it to fire.

    Ruthy,

    The EnterWorks Tech Talk:  "ETT 021 - Using Ownership Security for Repository Record Locking" in the Precisely University shows how to set up locking of attributes based on the value of another attribute.



    ------------------------------
    Brian Zupke
    Precisely Software Inc.
    ------------------------------