Expression rule to compare two values

Question

I want to write an expression rule to compare two values: 
 first value is from rule input and second value from a db table field.If the values are same ,then another field(column) of my db table must be set to inactive or 0.

Mike Schmitt · Answer

FYI, you're able to edit your post if you want to change something, it's not really needed to post essentially the same thing again. 
 For your question, you should be able to query from your database table (using a!queryEntity() or, preferably, referencing an existing expression rule you've already set up to handle queries to that table), and compare the result to the input value. I'm not exactly clear what you mean when you say "another field of my table must be set to inactive", as an expression rule itself cannot change data in a DB table - what you describe will probably be most easily accomplished by using a process model which sets the desired value determined by some initial logic then writes that row back to your table.

jasmithak · Answer

load( local!dbdata:{ {id:1,isactive:1,fieldId:1,formId:2}, {id:1,isactive:1,fieldId:1,formId:3}, }, 
 a!forEach( items: local!dbdata, expression: if( and( tointeger(fv!item.fieldId) = ri!fieldId, tointeger(fv!item.formId) = ri!formId ), {id:fv!item.id,isactive:0,fieldId:fv!item.fieldId,formId:fv!item.formId}, fv!item ) ) ) 
 I specified dbdata as dictionary in above code. cast it to CDT using type! and write the output to database entity.