I train the users to use bulk edit and update the field. Or if we have time to do some development, add a button to call updateRecord() client API for the selected records and show the confirmation dialog
If you planning to try out @harperdbio with the dot net core app, I just built a basic startup package that helps in integration and performing operations like
CreateSchema
CreateTable
CreateRecord
CreateBulkRecord
GetById
ExecuteQuery
UpdateRecord
github.com/rajat-srivas/Harp…
For example, with UpdateRecord. Set "Replacement Value Strategy" to "Literal Value". Then add property "/path/to/date/field" with value "${field.value:toDate('MM/dd/yyyy HH:mm:ss', 'EST'):format('MM/dd/yyyy HH:mm:ss', 'UTC 01:00')}" (2/2)
SQL Insert and Update functions for our MBS #Xojo SQL Plugin
InsertRecord(TableName as String, Record as Dictionary)
UpdateRecord(TableName as String, Record as Dictionary, Keys as Dictionary)
Just pass values as dictionary and we write the SQL for you.
mbsplugins.net/archive/2018-…
Update the contents of an @apachenifi FlowFile using UpdateRecord: community.hortonworks.com/ar… <-- how to prepare each record in a flow by adding new fields to / removing unnecessary fields from it, then use the success relation to pass it along for further record-based processing