Comments panel

Ignition
1

ok I am trying to use last name in the comments panel as the usernames are coded and wouldn’t help know who wrote the comment. here is what I am trying to use however I get an error referring to the root container.
used an expression to write this.

"INSERT INTO comments_panel "+
"(NoteText, username, Timestamp, Stick) "+
"Values "+
“(?, {Root Container.lastname}, Current_TimeStamp, ?)”

very simple however I am now expanding and need the lastname instead of ‘%s’

Thanks

2

here is the error I get.

GatewayException: SQL error for “INSERT INTO comments_panel (NoteText, username, Timestamp, Stick) Values (?, {Root Container.Comments Panel.firstname}, Current_TimeStamp, ?)”: ‘Root’ is not a recognized ODBC scalar function option.
caused by SQLServerException: ‘Root’ is not a recognized ODBC scalar function option.

Ignition v7.6.4 (b2013112117)
Java: Oracle Corporation 1.7.0_51

3

figured out myself.

"INSERT INTO comments_panel "+
"(NoteText, username, Timestamp, Stick) "+
"Values "+
“(?, '”+
{Root Container.Comments Panel.firstname}+
“’, Current_TimeStamp, ?)”