Tag value change script help

andrews · August 11, 2022, 9:00pm

Hello, I have 8 mutli state buttons and 8 drop downs working of a dataset for each. I need to make sure none of the 8 can have the same value at the same time.

I was thinking a value change script on the tag would be best.

I’m feel a little lost on the best way to script it. Below is my code, any input would be appreciated. Essentially adding values to array, and cross checking. if already in use write old value i.e. no change else, change to new value on selected tag . Do I need the else?

# create array to hold current values
MSBchecks = []
# add tag valyes to array
tags = system.tag.browseTags(parentPath="System1/Project1/Filler Supply Screen/PumpAndValve/Pump", recursive = True)
for tag in tags:
    # Wrties tag path to array
    MSBchecks.append (tag.value)
# checks if current value is already in use
if currentValue.value in MSBchecks:
    if not 0:
        message = "device " + currentValue.value + "is already being used. please unselect it and try again "
        system.tag.write("Tanks/tankHiSP/selection5",previousValue.value)
	    system.gui.messageBox(message, "Pump Error")
else:
    system.tag.write("Tanks/tankHiSP/selection5",currentValue.value)

pturmel · August 11, 2022, 11:45pm

I wouldn’t use tags at all. I’d use my view() function to filter the master list of choices at each dropdown to exclude the choices in the others. Like this, for the 3rd dropdown:

view("Select * Where value not in args",
  {Root Container.path.to.master.data},
  {Root Container.Dropdown 1.selectedValue},
  {Root Container.Dropdown 2.selectedValue},
  {Root Container.Dropdown 4.selectedValue},
  {Root Container.Dropdown 5.selectedValue},
  {Root Container.Dropdown 6.selectedValue},
  {Root Container.Dropdown 7.selectedValue},
  {Root Container.Dropdown 8.selectedValue})

Notice how I skipped Dropdown 3. Do likewise for the others.

No script. Just the above binding on the choices data for each dropdown.

andrews · August 12, 2022, 10:41pm

@pturmel can you please explain this line a little more?

Thank you!

pturmel · August 13, 2022, 11:25am

The view function’s first argument after the string is the FROM dataset. In this case, it would be a static dataset on a custom property (Root Container, probably) contain all of the possible choices.

andrews · August 14, 2022, 1:08pm

@pturmel While this looks perfect. I’m having trouble finding documentation for the view() function. Would you be able to point me in the right direction? This is for my own benefit so I can find similar things in the future.

Thank you!

lrose · August 14, 2022, 1:35pm

The view() function is part of @pturmel’s simulation aids module. Which is free. Although I’m not sure if it supports 7.8.

pturmel · August 14, 2022, 1:37pm

There is a version for v7.8 still available, but I don’t actively support it. See all options (with link to docs) here:

https://www.automation-pros.com/modulesales.html

The page for the view() function itself is here:

https://www.automation-pros.com/simaids/doc/expression.view.html

andrews · August 14, 2022, 2:07pm

Well I guess here’s to hoping I don’t run into issues, or I’ll have to script it an alternate way.

Thankfully from what I hear they are gonna upgrade us next year.

andrews · August 15, 2022, 2:34pm

@pturmel that’s perfect for the drop down. Would the multistate button be able to work in a similar way.

pturmel · August 15, 2022, 2:35pm

You’ll have to explain what you’re after for those (I don’t use them).

andrews · August 15, 2022, 2:49pm

Essentially same thing. User can’t select button state if already selected on other button.

But honestly at this point I’m tempted to make it all dropdowns now.

andrews · August 15, 2022, 9:48pm

@pturmel I’d like selected value 0 to be exempt because that is the default none selection. How would I go about writing that?

would something like Select * Where value not in args and value not 0
Thank you

pturmel · August 15, 2022, 10:18pm

Select * Where value == 0 or value not in args

andrews · August 17, 2022, 2:44pm

@pturmel I’m getting this error:

java.lang.Exception: Error executing expression binding on
Filler Pump Popup Update.Root Container.Group.Dropdown 8.data
	at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:91)
	at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.startup(ExpressionPropertyAdapter.java:112)
	at com.inductiveautomation.factorypmi.application.binding.DefaultInteractionController.setPropertyAdapter(DefaultInteractionController.java:203)
	at com.inductiveautomation.factorypmi.designer.property.configurators.ExpressionConfigurator.bind(ExpressionConfigurator.java:283)
	at com.inductiveautomation.factorypmi.designer.property.configurators.ExpressionConfigurator.tryCommit(ExpressionConfigurator.java:219)
	at com.inductiveautomation.factorypmi.designer.property.configurators.ConfiguratorMultiplexor$EditorParent.tryCommit(ConfiguratorMultiplexor.java:213)
	at com.inductiveautomation.factorypmi.designer.property.configurators.ConfiguratorMultiplexor.tryCommit(ConfiguratorMultiplexor.java:358)
	at com.inductiveautomation.factorypmi.designer.property.configurators.DynamicOptsDialog.doOK(DynamicOptsDialog.java:117)
	at com.inductiveautomation.factorypmi.designer.property.configurators.DynamicOptsDialog.access$000(DynamicOptsDialog.java:43)
	at com.inductiveautomation.factorypmi.designer.property.configurators.DynamicOptsDialog$1.actionPerformed(DynamicOptsDialog.java:83)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$500(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.WaitDispatchSupport$2.run(Unknown Source)
	at java.awt.WaitDispatchSupport$4.run(Unknown Source)
	at java.awt.WaitDispatchSupport$4.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.awt.WaitDispatchSupport.enter(Unknown Source)
	at java.awt.Dialog.show(Unknown Source)
	at java.awt.Component.show(Unknown Source)
	at java.awt.Component.setVisible(Unknown Source)
	at java.awt.Window.setVisible(Unknown Source)
	at java.awt.Dialog.setVisible(Unknown Source)
	at com.inductiveautomation.factorypmi.designer.property.configurators.DynamicOptsDialog.showDialog(DynamicOptsDialog.java:185)
	at com.inductiveautomation.factorypmi.designer.model.VisionDesignerImpl.openBindingDialog(VisionDesignerImpl.java:1087)
	at com.inductiveautomation.factorypmi.designer.property.editors.bb.DynamicOptionsButton.actionPerformed(DynamicOptionsButton.java:36)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at com.jidesoft.plaf.basic.BasicJideButtonListener.mouseReleased(Unknown Source)
	at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI$Handler.repostEvent(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI$Handler.mouseReleased(Unknown Source)
	at com.jidesoft.swing.DelegateMouseInputListener.mouseReleased(Unknown Source)
	at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
	at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$500(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: com.inductiveautomation.ignition.common.expressions.ExpressionException: Unable to execute view
	at com.automation_pros.simaids.expressions.View.execute(View.java:269)
	at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:46)
	at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
	at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:82)
	... 105 more
Caused by: Traceback (most recent call last):
  File "<expression:view>", line 6, in <module>
NameError: name 'value' is not defined

	at com.inductiveautomation.ignition.common.script.ScriptManager.runCode(ScriptManager.java:634)
	at com.inductiveautomation.ignition.common.script.ScriptManager.runCode(ScriptManager.java:590)
	at com.automation_pros.simaids.expressions.View.execute(View.java:267)
	... 108 more
Caused by: Traceback (most recent call last):
  File "<expression:view>", line 6, in <module>
NameError: name 'value' is not defined

	at org.python.core.Py.NameError(Py.java:260)
	at org.python.core.PyFrame.getname(PyFrame.java:257)
	at org.python.pycode._pyx14.f$0(<expression:view>:9)
	at org.python.pycode._pyx14.call_function(<expression:view>)
	at org.python.core.PyTableCode.call(PyTableCode.java:165)
	at org.python.core.PyCode.call(PyCode.java:18)
	at org.python.core.Py.runCode(Py.java:1275)
	at com.inductiveautomation.ignition.common.script.ScriptManager.runCode(ScriptManager.java:631)
	... 110 more

Ignition v7.8.5 (b2016120813)
Java: Oracle Corporation 1.8.0_271

the code looks like this:

view("Select * Where value == 0 or value not in args",
  {Root Container.Group.FillerList},
  {Root Container.Group.Dropdown 9.selectedValue},
  {Root Container.Group.Dropdown 10.selectedValue},
  {Root Container.Group.Dropdown 11.selectedValue},
  {Root Container.Group.Dropdown 12.selectedValue},
  {Root Container.Group.Dropdown 13.selectedValue},
  {Root Container.Group.Dropdown 14.selectedValue})

I skipped 8 because it is for that dropdown. I put the code as an expessrion binding on the data for the dropdown

pturmel · August 17, 2022, 7:01pm

Column names are case sensitive.

andrews · August 17, 2022, 7:15pm

ah my bad, missed that. lol. thank you!