Table editable value write back to the dataset tag In perspective

Ignition
1

I have a dataset tag, I am binding tag to a table. I want two columns to be editable in that and after editing, dataset value should write back to the same tag.
How can I do this?
Any idea?
Thanks.

2

https://docs.inductiveautomation.com/display/DOC81/system.dataset.setValue

3

I have tried with system.dataset.setvalue().
Table data is in json format, so setValue is not working for json data.
I have tried to convert data in dataset or Pydataset like this but it is not working.

image
image1079×338 55.3 KB

4

ah yes like that it wont work
You will have to create a dataset then from the ‘json’ using header and data like the first example here

https://docs.inductiveautomation.com/display/DOC81/Datasets

5

I think I may be missing something. Are you directly binding to the tag? If I bind a table’s data to a tag, it stays a BasicDataset.

6

Yes from tag we can get basic Dataset but I have transform script to convert tag data into json because to make fields editable data should be in json right?

7

You would if you are modifying the data directly in the table. But, you are binding to a tag, instead.

onEditCellCommit

	newData = system.dataset.setValue(self.props.data, event.row, event.column, event.value)
	system.tag.writeBlocking('[tagProvider]path/to/tag', newData)
1 Like
8

But it is giving error
1st arg can't be coerced to com.inductiveautomation.ignition.common.Dataset

9

Did you bind it without the transform?

10

Yes, It worked, Thanks a lot.I thought json data is required for editable functionality.
I have one more doubt,
How to Access network drive folder in perspective - Ignition - Inductive Automation Forum
any idea for this?