Write to DB with Save Button Script

[dcan87]

def runAction(self, event):
	# Grab the values to place in new DB row.
	Parent = self.parent.parent.parent.getChild("containerLineMachine").getChild("labelLineName").props.text
	SAP = self.parent.parent.parent.getChild("containerSapLabel").getChild("SAP Label").props.text
	CommonName = self.parent.parent.parent.getChild("containerLineMachine").getChild("labelCommonName").props.text
	Note = self.parent.parent.getChild("CoordinateContainer").getChild("NewCommentTextArea").props.text
	 
	# Use those values in the Insert Comment Named Query.
	system.db.runNamedQuery("InsertMachineComment", {"myParent":Parent, "mySAP":SAP, "myCommonName":CommonName, "myNote":Note})
	 
	# Refresh the table to immediately bring in the new row.
	system.db.refresh(event.source.parent.getChild("CommentHistoryTable"), "data")

Ok, what am I doing wrong here?

On Click of the 'Save' button appears to do nothing. This is an event script onActionPerformed on my 'Save' button.

[Transistor]

Wiki - how to post code on this forum

This thread is intended as a short help file for all those struggling to post formatted code on the forum. Posting formatted code on the forum (and most others) is as simple as selecting the code and pressing the </> button. It works the same as applying Bold or Italic styles to your document. It preserves indentation and applies syntax highlighting. [How to post code]

[lrose]

@dcan87

Ok, what am I doing wrong here?

Posting a picture of code without properly formatted text following in the text?

On a serious note though:

I see from your code that you are working in perspective.

system.db.refresh() is only scoped for vision. You're looking for self.refreshBinding()

P.S. I'm not retyping your script.

[craigb]

If you look at the logs in the gateway there is a good chance it will tell you exactly what the problem is, or at least point you to the line in fault.

[Transistor]

Tip: a handy way to debug a script is,

• Create a memory tag, say, projectNameDebug.
• Where you need to debug in your script add in a write to the tag:

system.tag.writeBlocking(["[default]projectNameDebug"], ["onActionPerformed fired."]

This will show you the last debug before the script stopped.

https://docs.inductiveautomation.com/display/DOC81/system.tag.writeBlocking

[dcan87]

@lrose

self.refreshBinding()

Good insight thank you, I will start creating this habit!

[lrose]

@Transistor

Tip: a handy way to debug a script is,

• Create a memory tag, say, projectNameDebug.
• Where you need to debug in your script add in a write to the tag:

system.tag.writeBlocking(["[default]projectNameDebug"], ["onActionPerformed fired."]

Not discrediting this by any means, but why would you do this when you can use a logger to log to the wrapper file, or for temporary debugging use system.perspective.print() (or just print for vision) and print messages directly to the output console?

[Transistor]

@lrose

but why would you do this when you can use a logger

I find loggers difficult to use. Switch to the browser, stop the live view, try and find the logger, scroll right across because it doesn't wrap.
The tag can be monitored on the Tag Browser pane.

Maybe I've missed something in my learning Igniton but I've searched and never found a good tutorial on the logger. I have a tremendous fund of ignorance to draw from!

[PGriffith]

One advantage of the writing-to-a-tag approach is you get feedback inside the designer; no need to open the gateway webpage. But it is definitely easier to get richer info via the logs.

[lrose]

@Transistor

I have a tremendous fund of ignorance to draw from!

I share that trait.

I have this bookmarked:

Event Configuration Print Out to debug

It’s complicated Starting from most local to least… In the script console, print will log directly to the output buffer on the right hand side. system.util.getLogger() will log to the named ‘Output Console’ Designer window. Bonus: A script invoked from here using system.util.invokeAsync will print to the regular output console, not the buffer on the right hand side. Anywhere else in the designer (except Perspective), print and system.util.getLogger will log to the ‘Out…

Of particular interest is the last part of that. Very helpful, since I almost always have the developer tools open when working in perspective.

@PGriffith

system.perspective.print has a ‘scope’ argument. If unspecified or set to ‘client’, output will be sent to the browser console wherever the session is running, and not logged to the gateway. If scope is set to ‘gateway’, then output is logged…to the gateway.

[pturmel]

@Transistor

loggers difficult to use

Heh. I use a 2nd 4k monitor, and use tail -f .../wrapper.log from an SSH connection to the gateway.

Highly recommended (really).

[Tim_Carlton]

Nice. My laptop seems to top out at an external 4k plus an external FHD. Even a 1900x1200 at 30Hz makes it wonky.

[dcan87]

Ok I am struggling to get the table to refresh after save:

def runAction(self, event):
	# Grab the values to place in new DB row.
	Parent = self.parent.parent.parent.getChild("containerLineMachine").getChild("labelLineName").props.text
	SAP = self.parent.parent.parent.getChild("containerSapLabel").getChild("SAP Label").props.text
	CommonName = self.parent.parent.parent.getChild("containerLineMachine").getChild("labelCommonName").props.text
	Note = self.parent.parent.getChild("CoordinateContainer").getChild("NewCommentTextArea").props.text
	 
	# Use those values in the Insert Comment Named Query.
	system.db.runNamedQuery("Machine Comments Panel/InsertMachineComment", {"myParent":Parent, "mySAP":SAP, "myCommonName":CommonName, "myNote":Note})
	 
	# Refresh the table to immediately bring in the new row.
	system.refreshBinding(self.parent.parent.getChild("CommentHistoryTable").props.data)

	# Clear text field
	self.parent.parent.getChild("CoordinateContainer").getChild("NewCommentTextArea").props.text = ""

Gateway log tells me Line 12 "object has no attribute 'refreshBinding'"

[Transistor]

@dcan87

system.refreshBinding(self.parent.parent.getChild("CommentHistoryTable").props.data)

Try,
self.parent.parent.getChild("CommentHistoryTable").refreshBinding("props.data")

https://docs.inductiveautomation.com/display/DOC81/Perspective+Component+Methods#PerspectiveComponentMethods-RefreshingBindings

[lrose]

refreshBinding() is a function on the component object it's self. It isn't a system function.

Assuming that this script is located on the table you are attempting to update, then all you should need is:

self.refreshBinding("props.data")

If not, then you will need to get the path to the table component and then call refresh binding, as @Transistor has shown.