Differences

This shows you the differences between two versions of the page.

--- getvaluesfromatwodimensionalvalueobjectscripts [2024/07/25 12:54] – created amyw
+++ getvaluesfromatwodimensionalvalueobjectscripts [2024/07/25 13:01] (current) – amyw
@@ Line 1: / Line 1: @@
 TwoDimensionalValueObject (2DVO) is a object that can hold a two dimensional array of ValueObjects. This makes it convenient to store values from a database table. The data is stored in column format with each column being represented by a vector. There are n of these where n is the number of rows. All these are stored in a single vector "values".
+That is, the size of the Vector is the number of rows of the data. The organization is: Vector 'Values' (size()== number of columns) VectorColumn0 [Row0Value, Row1Value, ...] (size() = number of rows) VectorColumn1 [Row0Value, Row1Value, ...] VectorColumn2 [Row0Value, Row1Value, ...] ..
-That is, the size of the Vector is the number of rows of the data. That is, the organization is: Vector 'Values' (size()== number of columns) VectorColumn0 [Row0Value, Row1Value, ...] (size() = number of rows) VectorColumn1 [Row0Value, Row1Value, ...] VectorColumn2 [Row0Value, Row1Value, ...] .. getColumnCount() returns values.size() getRowCount() returns values.elementAt(0)).size() The data is square, that is, no column values are missing, no rows are short.
+getColumnCount() returns values.size();  getRowCount() returns values.elementAt(0)).size(). The data is square, that is, no column values are missing, no rows are short.
 Overall, The core idea  of 2DVO is to represent each column as a vector and then store these vectors in a main vector. This structure allows for efficient access to rows and columns.
+The following code snippet demonstrates how to extract data from a TwoDimensionalValueObject and populate a java.util.ArrayList with the objects in an object called "dataObject":
+<code>
+//1. Create a variable to store the 2DVO object values in a java.util.ArrayList
+var dataArrayList = new java.util.ArrayList();
+//2. Get all data from the database by using Database Raw Table Lookup, the output is in a 2D value object with rows and columns. Asssigne the output to a variable "dataResult:
+ var dataResult = 2DVO table output;
+// Count the rows of the table using vector.getRowCount() method
+rowCount = dataResult.getRowCount();
+for (var i = 0; i < rowCount; i++) {
+    // If want to get all the objects, each row is one object
+    var rowData = dataResult.getRow(i);
+    // below codes use vector.getValueAt(i, column_index) method to retrieve the values of a specific column and assign it to the corresponding property in the SomeDataObject instance
+    // Create a new object (replace with your actual object type)
+    var dataObject = new SomeDataObject();
+    // To access properties and populate dataObject
+	        dataObject.property1 =dataResult.getValueAt (i, 0);
+		dataObject.property2=dataResult.getValueAt(i, 1);
+		dataObject.property3 =dataResult.getValueAt(i, 2);
+		...
+		dataObject.property6 = dataResult.getValueAt(i, 5);
+		dataObject.property7 = dataResult.getValueAt(i, 6);
+		....
+    // Add each data object to the dataArrayList
+    dataArrayList.add(dataObject);
+}
+</code>
-The folowing code snippet demonstrates how to extract data from a
-TwoDimensionalValueObject and populate a java.util.ArrayList with the objects in an object called "dataObject":