Skip to main content
Question

process flow action - get user_id of person who is doing a change

  • September 15, 2021
  • 1 reply
  • 127 views

Forum|alt.badge.img+7
  • Sidekick (Customer)
  • 39 replies

Hello,

 

does anyone knows, if there is a possibility to get the <current user id> (who is doing a special transaction) in backend or mobile application?

 

The order-ID is clear to me, but I am not aware of the correct syntax for the user_id, who did a special change. (yellow highlight)

Thanks a lot in advance!

 

Regards

Torsten

1 reply

Forum|alt.badge.img+10

When an order is changed, a transaction log entry is added to the demand table and the demand.created_by shows the user who performed the transaction.  An example of the query is: select demand.created_by from demand with (nolock) where bpart_gcl_id = 'Mngt' and order_id = '<Order ID>' order by creation_datetime desc;


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings