Topic
  • 3 replies
  • Latest Post - ‏2013-09-16T09:57:07Z by PIM10
wpc_guy
wpc_guy
40 Posts

Pinned topic How to get Last Modified user for an item

‏2013-09-11T06:58:33Z |

Hi,

   We are trying to find the user who modified certain items in Production .  Ideally we should have a ValueRule which would capture the userInfo whenever an item is modifed but since that we don't have it in place, we are having difficult to trace the user.

   I couldn't find any direct Scripting/JAVA APIs which can help me to fetch LastModified user. If anyone has come across this issue and resolved, please share the same. Thanks!!

 

Regards,

Jaheer

  • PIM10
    PIM10
    6 Posts

    Re: How to get Last Modified user for an item

    ‏2013-09-16T09:49:19Z  

    Hi Jaheer,

    Not sure wheather it ll work for you or not, but you can take the help of following query to fetch the needed information:

    select * from alo where ALO_TIMESTAMP > to_date('2013-09-16','YYYY-MM-DD')and ALO_DESCRIPTION like '%Price%'
    and ALO_EVENT_NAME like '%ITEM_ADDED'

    Regards,

    Pritam

     

     

     

     

  • PIM10
    PIM10
    6 Posts

    Re: How to get Last Modified user for an item

    ‏2013-09-16T09:52:07Z  
    • PIM10
    • ‏2013-09-16T09:49:19Z

    Hi Jaheer,

    Not sure wheather it ll work for you or not, but you can take the help of following query to fetch the needed information:

    select * from alo where ALO_TIMESTAMP > to_date('2013-09-16','YYYY-MM-DD')and ALO_DESCRIPTION like '%Price%'
    and ALO_EVENT_NAME like '%ITEM_ADDED'

    Regards,

    Pritam

     

     

     

     

    "Price" indicated above is basically the Catalog name...... :)

  • PIM10
    PIM10
    6 Posts

    Re: How to get Last Modified user for an item

    ‏2013-09-16T09:57:07Z  
    • PIM10
    • ‏2013-09-16T09:52:07Z

    "Price" indicated above is basically the Catalog name...... :)

    By using the above query you can find the user id, but if you need the user name then please use the following query: 

    select SCU_USERNAME from SCU where SCU_USER_ID like '123' -- 123 is the user id

    Thanks,

    Pritam