I'll try and explain. We have the concept of a "Device" being stored as nodes in Umbraco. For each device we have a number of custom fields being added to the Examine Index in a IndexProviderTransformingIndexValues event. This is working ok.
What we would like to do, is add other custom fields against a device i.e Last Log Updated or Last Calibration Date and update these fields when the data "outside" of the node is changed. The data is stored in a custom database table in the same instance as Umbraco with the link being the Device node Key. Yes we could do a SQL lookup from the table, but for performance I want all the data in Examine for retrieval later.
Now, I realise that if someone publishes a Device, then these custom fields may get removed or altered (as they dont exist on the Device), and I'll try to handle that, but is there a way to get a record from Examine, update a field, and push it back into Examine, without Publishing the Device node and/or using the IndexProviderTransformingIndexValues?? i.e combo of ValueSetBuilder & IndexPopulator maybe?