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.
Note also that it's trivially easy to query the most recent version of a row, update just the desired field, and re-write that value - it won't update anything other than the value you updated. This is a little easier than Stewart's suggestion, in cases where it's not being done very much (and thus potentially impacting performance or risking conflicts).
As I used view to display data on dashboard . When I edit data on dashboard it will save to database. So not all fields have come in view. That's why i use this query database to update data.
That's not really relevant. If you have the table's primary key ID, you can query the current data in that row, update the value, and re-write it using WTDS. This is still true regardless of whether someone's looking at an interface that uses View data.