seems I almost there, the problem I found is that the value i supposed to be saved for a!query is not the standard form. What should be the correct one?
a!save(target:ri!userrole.USER_ID, value:cast(type!Integer, a!queryEntity( entity:cons!KONE_Development_userrole_Constant, fetchTotalCount:true, query:a!query( selection: a!querySelection( columns: { a!queryColumn( field: "USER_ID" ) } ), filter:a!queryFilter( field:"NAME",operator:"=", value:ri!userinputsheet.kone_user_name, applyWhen:not(isnull(ri!userinputsheet.KONE_user_name)) ), pagingInfo:a!pagingInfo( startIndex: 1, batchSize: 50 ) ) ).data.USER_ID) ),
Discussion posts and replies are publicly visible
you either have to re-save all columns along with the changed one (making sure to correctly populate them in your CDT first), or if your need is strong enough, you can instead create a separate CDT that contains only the columns for the table Primary Key ID, and the column(s) you want to change. I advise only going with this solution when the use for it in your system will be very common, as it creates extra setup and maintenance hassles.