How to extract the value of the selected row

[Francisco.Mejia]

Hi,
Suppose you have table in a for with some records and you select a row. How do you get the value stored in the selected row and in a particular column and place that value in a text box ?

Thanks
Francisco

[adamaustin]

Try this: Get value of specfic cell in a table?

[Luke.Stone]

See the “Working With Different Datatypes” in the user manual. Specifically -

Accessing data in a DataSet
DataSets have various properties and functions that you can access through Python.
• rowCount - returns the number of rows in the dataset
• columnCount - returns the number of columns in the dataset
• getColumnName(index) - returns the name of the column at the given index
• getValueAt(row, column) - returns the value from the dataset at the given location. column can be either an integer or a column name, which is treated case-insensitive.

You will want to grab the dataset out of the table, then call getValueAt(table.selectedRow, table.selectedColumn) on it.

Assume this code was on a button:

table = event.source.parent.getComponent(“Table”)
textField = event.source.parent.getComponent(“Text Field”)
data = table.data
textField.text = data.getValueAt(table.selectedRow,table.selectedColumn)

[kavya_shree]

how to print the values from the database table by some condition.

I am able to print headers, how to print values.

Thank you

[JordanCClark]

I wrote a helper function for that.

View Dataset from script console

Sorry, I'm on vacation, but family is napping, so I get to play. Yes, this is how I relax. Don't judge. EDIT: Added option for printing from Perspective. Sorry, not quite ready for prime time. def printDataSet(datasetIn): from itertools import izip import ast if 'PropertyTreeScriptWrapper$ArrayWrapper' in str(type(datasetIn)): headers = datasetIn[0].keys() data = [] for row in datasetIn: data.append([item.value for item in row.values()]) datasetIn = system.dataset…

[PGriffith]

Also available in module form, if you want a system.dataset.print:

Ignition Extensions - Convenience utilities for advanced users

Introducing a hopefully community-engaged effort to build a useful repository of scripting and other Ignition utilities for everyone to benefit from. Download the latest release from the Releases page and take advantage of the following functions: Scripting Functions system.util system.util.getContext(): Context A convenience function to retrieve the local "context" object, useful as an entrypoint to other advanced scripting. system.util.deepCopy(object): Object Converts a given Pyth…