# Drop down did not update value

**URL:** <https://forum.inductiveautomation.com/t/drop-down-did-not-update-value/110579>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [September 12, 2025, 2:29pm UTC](https://forum.inductiveautomation.com/t/drop-down-did-not-update-value/110579 "2025-09-12T14:29:39Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![TechEnlive](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@TechEnlive](https://forum.inductiveautomation.com/u/TechEnlive)\
**Post date:** [September 12, 2025, 2:29pm UTC](https://forum.inductiveautomation.com/t/drop-down-did-not-update-value/110579/1 "2025-09-12T14:29:39Z")

</div>

Hi,

I have a dropdown inside the table row. All other field update with new values but Dropdown value did not updated. On Dropdown change item it is not updated.  
"compatibility": row["COMPATIBILITY"], is dropdown. the field name is correct.

```python
def runAction(self, event):
		    
	table = self.parent.parent.getChild("Table_0")
	table.commitEdits()	
	data = table.props.data    
   
	for row in data:
		system.db.runNamedQuery(
		"gestione_produzione/Consumption/Update_tableMpDefine", 
		{
            "description": row["DESCRIPTION"],
            "compatibility": row["COMPATIBILITY"],
            "itemId": row["ITEMID"]
        }
        )

```

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [September 12, 2025, 2:44pm UTC](https://forum.inductiveautomation.com/t/drop-down-did-not-update-value/110579/2 "2025-09-12T14:44:46Z")

</div>

All your script there is doing is firing off a named query.  
If you're displaying the results of whatever that named query is updating somewhere else in your session, you would have to _poll_ the database for results to see any updates.

---

<div class="post-metadata">

**Author:** ![TechEnlive](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@TechEnlive](https://forum.inductiveautomation.com/u/TechEnlive)\
**Post date:** [September 12, 2025, 3:15pm UTC](https://forum.inductiveautomation.com/t/drop-down-did-not-update-value/110579/3 "2025-09-12T15:15:23Z")

</div>

I am sorry i could not undestand.  
Here i can share the data when click the save button we have in table.props.data is as below.  
You can see the DropDown did not change he value.

```python
[{"COMPATIBILITY":"P","DESCRIPTION":"CATALIZZATORE AMMINICO POLIFUNZIONALE PU ESPANSO 1 (PUR)","ITEMID":"MCATAMMI0102","bit":"P"},{"COMPATIBILITY":"","DESCRIPTION":"CATALIZZATORE AMMINICO POLIFUNZIONALE PU ESPANSO 2 (PIR7","ITEMID":"MCATAMMI0103","bit":""},{"COMPATIBILITY":"K","DESCRIPTION":"CATALIZZATORE AMMINICO DI BLOWING PU ESPANSO (PIR)","ITEMID":"MCATAMMI0104","bit":"K"},{"COMPATIBILITY":"","DESCRIPTION":"CATALIZZATORE ORGANOMETALLICO PER PU ESPANSO (PIR)","ITEMID":"MCATORGMI0101","bit":""},{"COMPATIBILITY":"I","DESCRIPTION":"CICLO/ISOPENTANO- DENATURATO 70% / 30%","ITEMID":"MESPMIX02001","bit":"I"},{"COMPATIBILITY":"A","DESCRIPTION":"CO-ESPANDENTE PU A BASE H2O 40%","ITEMID":"MESPMIX03001","bit":"A"},{"COMPATIBILITY":"","DESCRIPTION":"CICLO/ISOPENTANO- PURO 70% / 30%55","ITEMID":"MESPMIX05001","bit":""},{"COMPATIBILITY":"V","DESCRIPTION":"PMDI FUNZIONALITA’ 2,6 PER PU ESPANSO","ITEMID":"MISOMBF00001","bit":"V"}]

```

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [September 12, 2025, 3:24pm UTC](https://forum.inductiveautomation.com/t/drop-down-did-not-update-value/110579/4 "2025-09-12T15:24:03Z")

</div>

> [@TechEnlive](#):
>
> `	table.commitEdits()	`

Did you add a custom method to the table called `commitEdits`, or is this an LLM hallucination? There's no such function on the Perspective table:

> **[Perspective - Table Scripting | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.3/appendix/components/perspective-components/perspective-display-palette/perspective-table/perspective-table-scripting)**
>
> This page details the various scripting, component, and extension functions available for Perspective's Table component.

If you didn't add a custom method by this name, then your script is failing on this line and never even attempting to run your named query.

---

<div class="post-metadata">

**Author:** ![TechEnlive](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@TechEnlive](https://forum.inductiveautomation.com/u/TechEnlive)\
**Post date:** [September 12, 2025, 3:28pm UTC](https://forum.inductiveautomation.com/t/drop-down-did-not-update-value/110579/5 "2025-09-12T15:28:15Z")

</div>

> [@TechEnlive](#):
>
> table.commitEdits()

This was a solution Chatgpt said. table.commitEdits().  
It shows error also but while pasting code i forget to delete this.  
Thanks for helping i will go through the link and let you update if got the solution..

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 12, 2025, 3:32pm UTC](https://forum.inductiveautomation.com/t/drop-down-did-not-update-value/110579/6 "2025-09-12T15:32:26Z")

</div>

> [@TechEnlive](#):
>
> This was a solution Chatgpt said.

You didn't say so in your OP, which is required by this forum's rules (in the FAQ). LLMs make so many mistakes with Ignition that this "heads up" helps us help you. (Or ignore you, because the LLM problems with Ignition are so frustrating. Consider learning to write your own code.)

---

<div class="post-metadata">

**Author:** ![TechEnlive](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@TechEnlive](https://forum.inductiveautomation.com/u/TechEnlive)\
**Post date:** [September 12, 2025, 10:03pm UTC](https://forum.inductiveautomation.com/t/drop-down-did-not-update-value/110579/7 "2025-09-12T22:03:06Z")

</div>

Thank you for your advice. I understand your perspective. Could you please help me with using a dropdown as an inline column? I’m currently using it, but the column data isn’t updating.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [September 12, 2025, 10:52pm UTC](https://forum.inductiveautomation.com/t/drop-down-did-not-update-value/110579/8 "2025-09-12T22:52:23Z")

</div>

> [@paul-griffith](#):
>
> If you're displaying the results of whatever that named query is updating somewhere else in your session, you would have to _poll_ the database for results to see any updates.

This is my best guess as to what might be going on, but you're providing virtually no information about your actual setup. All we can do is _guess_ unless you provide more information about what you've actually got set up.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 12, 2025, 11:16pm UTC](https://forum.inductiveautomation.com/t/drop-down-did-not-update-value/110579/9 "2025-09-12T23:16:42Z")

</div>

The expected implementation is to implement the table's onEditSomething actions, passing fresh changes directly to the DB as you go. After each, you must use the table components [.refreshBinding()](https://www.docs.inductiveautomation.com/docs/8.1/ignition-modules/perspective/scripting-in-perspective/perspective-component-methods#refreshing-bindings) method on `props.data` to update the display.

---

<div class="post-metadata">

**Author:** ![TechEnlive](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@TechEnlive](https://forum.inductiveautomation.com/u/TechEnlive)\
**Post date:** [September 16, 2025, 8:56am UTC](https://forum.inductiveautomation.com/t/drop-down-did-not-update-value/110579/10 "2025-09-16T08:56:51Z")

</div>

Hi,

I’m using a message handler. In the DD change event, I call the table message handler and update the row with the new data. This approach works well and also gives me the opportunity to extend it with more functionality.

Thanks a lot **paul-griffith & pturmel** for your support and advice!