# Perspective Table Checkbox:: get state for update query within onEditCellCommit event

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-checkbox-get-state-for-update-query-within-oneditcellcommit-event/35272>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [June 2, 2020, 10:00pm UTC](https://forum.inductiveautomation.com/t/perspective-table-checkbox-get-state-for-update-query-within-oneditcellcommit-event/35272 "2020-06-02T22:00:49Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dgorman](https://avatars.discourse-cdn.com/v4/letter/d/6f9a4e/32.png) [@dgorman](https://forum.inductiveautomation.com/u/dgorman)\
**Post date:** [June 2, 2020, 10:00pm UTC](https://forum.inductiveautomation.com/t/perspective-table-checkbox-get-state-for-update-query-within-oneditcellcommit-event/35272/1 "2020-06-02T22:00:49Z")

</div>

I have a boolean value coming in from SQL (bit) and rendering it as a checkbox. On the edit I am having a hard time getting the value off of the checkbox to pickup that state change (true,false,checked, unchecked, 1,0 etc).

**IsApproved = self.props.data.getValueAt(event.rowIndex, ‘IsApproved’)**

does not seem to give me a value on an edit.  
Any ideas or questions I can answer to help clarify? Thanks in advance.
