Skip to main content
A
AP_1034300816-Pearl
16-Pearl
August 18, 2023
Question

How to update each index of infotable rows which is already created in userextension.

  • August 18, 2023
  • 1 reply
  • 1207 views

I have added infotable property in userextensions. When iam updating every index of infotable, this folloeing error is poping up. How to update each index of infotable rows which is already created in userextension.
Error: JavaException: java.lang.ClassCastException: com.thingworx.types.InfoTable cannot be cast to com.thingworx.types.collections.ValueCollection

1 reply

V
19-Tanzanite
Velkumar19-Tanzanite
19-Tanzanite
August 18, 2023

Hi @AP_10343008 

 

Based on your error message: You are trying to add ValueCollection to InfoTable variable. 

 

It will be helpful if you post your code to debug it

 

The below script is used to add a new row to user extension

var infoTableValue = Users["Administrator"].testp;

infoTableValue.AddRow({
	f1: "t1",
	f2: "t2"
});

infoTableValue.AddRow({
	f1: "t3",
	f2: "t4"
});

Users["Administrator"].testp = infoTableValue;

var result = Users["Administrator"].testp;

 

To update infotable value

var infoTableValue = Users["Administrator"].testp;

for(var i = 0 ; i < infoTableValue.length; i++)
{
 if(infoTableValue.rows[i].f1 === "t1")
 {
 infoTableValue.rows[i].f2 = "Changed";
 }
}

Users["Administrator"].testp = infoTableValue;

var result = Users["Administrator"].testp;

 

/VR

A
AP_1034300816-PearlAuthor
16-Pearl
August 18, 2023

Example: I have 15 rows in Users["Administrator"].testp
Based on change event, iam running same service 15 times to update each row[index] of infotable. 

So i need a code to update only particular row in user extension property directly not the full infotable. 
I tried the below code by directly passing index number of infotable but it doesnt worked.

newEntry.AddRow({colA : "A", colB : "B"});

Users["Administrator"].testp[1] = newEntry;

V
19-Tanzanite
Velkumar19-Tanzanite
19-Tanzanite
August 18, 2023

Hi @AP_10343008 

 

If you know the index of the row 

 

// Get value from User extension and store it in InfoTable
var infoTableValue = Users["Administrator"].testp;

// update row value based on index
infoTableValue.rows[INDEXNUMBER].f1 = "directValue"; 

// Update User extension value
Users["Administrator"].testp = infoTableValue;

// Return result to validate data
var result = Users["Administrator"].testp;

 

/VR

Terms & ConditionsCookie settingsAccessibility statement