I have used query databse service in my process model.
Here I wrote this query to update particular fields in database table. I searched on google and i found that active class parameter should be used in query to update database table.
I have made parameter like this and i used these parameters in my above query using ac! . But when i run this model it doesn't move ahead from this stage eventhough there is no error on this stage.
Is my configuration proper?
Discussion posts and replies are publicly visible
Is there any particular reason you're not using the Write to Data Store Entity node? The Query DB node is recommended to only be used sparingly and when there are absolutely no other options, as far as I know. The configuration is more difficult and more confusing (as you've experienced) and you won't find anywhere near as much support for it here.
I want to update only few field in table not whole data so that's why i am using this query database service.
You can create a CDT that only has the field(s) you want to update and the field that uniquely identifies the target row - a so-called "partial CDT" and then you can use the WTDS node as you would normally.