Clarity

  • 1.  INSERT query for locking the attributes

    Posted Jun 26, 2018 04:59 AM

    Please help me with the INSERT query for locking the attributes into ODF_LOCKED_ATTRIBUTES table?



  • 2.  Re: INSERT query for locking the attributes

    Broadcom Employee
    Posted Jun 26, 2018 05:20 AM

    there is already some discussion on this thread Locking an attribute via XOG or GEL 



  • 3.  Re: INSERT query for locking the attributes

    Posted Jun 27, 2018 09:20 AM

    Hi Gaagoo,

     

    Please find below the update queries for locking/unlocking of attributes: -

     

    update odf_locked_attributes

    set attribute_code = 'aaa_***'
    where attribute_name = (select attribute_name from DB table where attribute_name = 'value')
    and attribute_code = 'aaa';

     

    commit;

     

    update odf_locked_attributes

    set attribute_code = 'aaa'
    where attribute_name = (select attribute_name from DB table where attribute_name  = 'value')
    and attribute_code = 'aaa_***';

     

    commit;

     

    ....something similar!!

     

    Hope this helps!

     

    Regards,

    Suhail.