Skip to main content
P
pavitrad2763
December 13, 2022
Question

DB is not getting updated

  • December 13, 2022
  • 4 replies
  • 0 views

Hi,

I'm trying to update the DB and all the fields are getting updated except Employee Id.

Value for EmployeeId is getting updated in Process model Variables as below but not getting updated in DB.

    4 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    December 13, 2022

    If your process variable pv!applyLeave is written to that record, it misses the primary key value. This results in an insert, but not an update.

    BTW, the images are very small and almost impossible to read.

    P
    pavitrad2763Author
    December 13, 2022

    Hi Stefan,

    Could you please let me know what I need to do to resolve this. Attaching the images again

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    December 13, 2022

    To update a record, you need to query the existing data first. It will then contain the primary key field you defined.

    konduruc733182
    konduruc733182
    December 13, 2022

    Hello Pavitra, you can use a script task and pass the stored value/input value of employee record type(employeeId:pk) into the Apply leave record type variable.

    Terms & ConditionsAccessibility statement