Skip to end of metadata
Go to start of metadata

You have a requirement where Operators must add a comment (note) to every entry that was coded as a specific Mode, for example, 
Maintenance or Production, for a given Line, Equipment.

Step-by-step guide

We will use an Analysis Controller to feed a Power Table which has a onCellEdited Extension Function to handle writing the Note

  1. Create an Analysis with the following:
    Data Points: Mode Begin Time,Mode Duration,Mode End Time,Equipment Note
    Filter By: Equipment Path = @eqPath AND Equipment Mode Type = 'Maintenance' (or Production or whatever Mode you wish to Filter by)
    Group By: Mode Begin Time
    on your Analysis Controller, add a Custom Property eqPath = string
    in the Property Window, the Analysis Controller should look like this:
  2. add a Date Range and a Power Table Component
    you will bind
    the Analysis Controller Start/End Date to the Date Range Start/End Date
    the Power Table Data to the Analysis Controller Data
  3. add some Scripting to the Power Table Extension Function onCellEdited

    if colName == "Equipment Note":
    		# get the equipment path from the MES Object Selector
    		eqPath = self.parent.getComponent('MES Object Selector').equipmentItemPath
    		# get the date of the event from the Analysis dataset
    		date =, 'Mode Begin Time')
    		# check to see if there is not already a note
    		if system.mes.getTagCollectorValue(eqPath, 'Equipment Note', '', date,) is None:
    			# if no note exists, add the note
    			system.mes.addTagCollectorValue(eqPath, 'Equipment Note', '', date, newValue)
    			# otherwise, update the note
    			system.mes.updateTagCollectorValue(eqPath, 'Equipment Note', '', date, newValue)
    		# rerun the analysis	
    		self.parent.getComponent('MES Analysis Controller').refresh()

    the following .proj is built-in with all of the above (on Inductive 7.9.10)

Maintain Equipment Notes 7910.proj