Workflow and ServiceDesk Community

 View Only
  • 1.  How to? - Modify a SQL table data

    Posted Oct 17, 2012 01:06 PM

    I tying to update a SQL table based on an end user response provided in a form.  I’m currently appending the responses to a SQL table.  One of the response items on the form is a data entry needed to update another table.  I’ve created a table generator Integration library to perform the data modification.  The integration library is configured to update field_3 based on a match of field_2. When I run the workflow I receive a message indicating field_1 cannot be modified.  I do not want to modify field_1.  How does the integration library need to be configured to avoid accessing field_1 and update field_3?



  • 2.  RE: How to? - Modify a SQL table data

    Posted Oct 17, 2012 01:09 PM

    Try checking the "null for identities" checkbox. I think this functions as "ignore ID column". This assumes your field_1 above is an ID.

    If that doesn't work, using a Query/Script component (vs a set of Table generator comps) is an option here... your SQL would just be something like:

    UPDATE mytable SET mycolumnhere = @blah WHERE myid = @yadda

    Above, blah would be the updated value, and yadda would be some ID to identify what row to update



  • 3.  RE: How to? - Modify a SQL table data

    Posted Oct 22, 2012 02:42 PM

    Thank you for your reply.  I tried to use the "Null" checkbox but it did not work.  I'll take a look at the SQL script and provide feedback later.