# Commentary panel

**URL:** <https://forum.inductiveautomation.com/t/commentary-panel/3366>\
**Category:** Ignition\
**Created:** [September 29, 2011, 11:59am UTC](https://forum.inductiveautomation.com/t/commentary-panel/3366 "2011-09-29T11:59:46Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![SamJaimes](https://avatars.discourse-cdn.com/v4/letter/s/a6a055/32.png) [@SamJaimes](https://forum.inductiveautomation.com/u/SamJaimes)\
**Post date:** [September 29, 2011, 11:59am UTC](https://forum.inductiveautomation.com/t/commentary-panel/3366/1 "2011-09-29T11:59:46Z")

</div>

hi everybody!

I’ve been trying to set up a commentary panel. I followed instructions in the user manual, but It still doesn’t work. Can somebody help me?

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [September 29, 2011, 3:27pm UTC](https://forum.inductiveautomation.com/t/commentary-panel/3366/2 "2011-09-29T15:27:44Z")

</div>

First you need a table in the database to hold the notes. The table must have the following columns (data types are for MySQL):

ID (INT, primary key, auto-increment)  
Username (VARCHAR(45))  
Timestamp (DATETIME)  
NoteText (LONGTEXT)  
AttachmentName (VARCHAR(255)) (allows null)  
Attachment (LONGBLOB) (allows null)  
Sticky (TINYINT(1))

Once you have the table you can bind the data to the following SQL query:`SELECT ID, Username, Timestamp, NoteText, AttachmentName, Sticky FROM notes`The Insert Query 1 property should be:`INSERT INTO Notes (NoteText, Username, Timestamp, Attachment, AttachmentName, Sticky) VALUES (?, '%s', CURRENT_TIMESTAMP, ?, ?, ?)`Insert Query 2 should be blank. That is it! It should work once you have that.

---

<div class="post-metadata">

**Author:** ![SamJaimes](https://avatars.discourse-cdn.com/v4/letter/s/a6a055/32.png) [@SamJaimes](https://forum.inductiveautomation.com/u/SamJaimes)\
**Post date:** [October 5, 2011, 9:01am UTC](https://forum.inductiveautomation.com/t/commentary-panel/3366/3 "2011-10-05T09:01:56Z")

</div>

Thanks Travis, the panel is working. Now I’m trying to make a dynamic panel. I created a new column in Notes, where i need to store a tag value. When this tag changes its value, the panel would show all the data where new\_column is equal to that value.

How can I insert a tag value to Notes table from panel commentaries properties?

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [October 5, 2011, 2:17pm UTC](https://forum.inductiveautomation.com/t/commentary-panel/3366/4 "2011-10-05T14:17:47Z")

</div>

Well, the data property is bound to a SQL query so you can make it dynamic by adding a where clause using the tag’s value. The insert query and other queries are also properties and you can make them dynamic through expression bindings.

---

<div class="post-metadata">

**Author:** ![ecujak](https://avatars.discourse-cdn.com/v4/letter/e/839c29/32.png) [@ecujak](https://forum.inductiveautomation.com/u/ecujak)\
**Post date:** [October 5, 2011, 8:09pm UTC](https://forum.inductiveautomation.com/t/commentary-panel/3366/5 "2011-10-05T20:09:50Z")

</div>

Will you post a link to this item in the [manual](http://www.inductiveautomation.com/support/usermanuals/ignition/index.html)?

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [October 17, 2011, 5:49pm UTC](https://forum.inductiveautomation.com/t/commentary-panel/3366/6 "2011-10-17T17:49:14Z")

</div>

You mean a link to the [Comments Panel](http://www.inductiveautomation.com/support/usermanuals/ignition/index.html?tables_pmicommentspanel.htm) component itself? If so, there you go.