Skip to main content
A
AS_1034065113-Aquamarine
13-Aquamarine
August 8, 2023
Solved

Update Entries in nested Infotables

  • August 8, 2023
  • 1 reply
  • 1019 views

Hello There,

 

i have an Infotable that contains a nested infotable. Let's call them parent and child infotable. I'm able to add anything to the parent and update if i want. For the child infotable i'm somehow limited. I'm only able to add entries with AddRow() but update is not possible.

 

This is the code i'm using for testing that:

 

 

// check if an entry already exist and apply to the variable named project
let project = Things["test.outer.DT"].QueryDataTableEntries({
	query: {
 "filters": {
 "type": "And",
 "filters": [
 {
 "type": "EQ",
 "fieldName": "timeStamp",
 "value": timeStamp
 },
 {
 "type": "EQ",
 "fieldName": "position",
 "value": position
 }
 ]
 }
	} /* QUERY */
});

// create empty holder for the outer DT
let values = Things["test.outer.DT"].CreateValues();
// create empty holder for the inner DT
let versionData = DataShapes["test.inner"].CreateValues();
// create empty holder if no entries exist at the inner DT
let innerValues = new Object();

// check if an entry already exist and apply it to values if so
if(project.getRowCount()){
	values 		= project;
}else {
 values.timeStamp 				= timeStamp;
 values.position 				= position;
 // versionData is the nested Infotable
 values.versionData 				= versionData; 
}

// check if the inner Infotable has an entry
entry = Resources["InfoTableFunctions"].Query({
t: values.versionData /* INFOTABLE */,
query: {
 "filters": {
 "type": "EQ",
 "fieldName": "versionName",
 "value": versionName
 }
 }
});

// if the inner Infotable has an entry change the property state to hit
if(entry.getRowCount()){
 entry.state = "hit";
 Resources["InfoTableFunctions"].UpdateQuery({
 t: values.versionData /* INFOTABLE */,
 query: {
 "filters": {
 "type": "EQ",
 "fieldName": "versionName",
 "value": versionName
 }
 } /* QUERY */,
 values: entry /* INFOTABLE */
 });
 
}else{
 innerValues.versionName = versionName;
 innerValues.State	 = State; 

 // add the new entry to the inner Infotable
 values.versionData.AddRow(innerValues);
}

// update the hole entry at the outer Infotable
Things["test.outer.DT"].AddOrUpdateDataTableEntry({
	values: values /* INFOTABLE */
});

 

 

 

Everything works beside the "UpdateQuery". I tried with "AddOrUpdateDataTableEntry" on values.versionData but i get there an error since it is no real existing Infotable. After few testings and tries i found this: update nested Infotable but i dont get why it doesn't work. 
Or is Thingworx not designed for nested Infotables even when it's possible?

in entry i have the changes but UpdateQuery does not update anything.

 

    Best answer by AS_10340651

    Okay, who ever will use this UpdateQuery should know that this command is actually a copy command and not an update command (thanks for the wrong and confusing naming). 

    That means, if you use it, then the return of UpdateQuery will be a changed copy of the matched query. while the original table is untouched.

     

    i use now this workaround 

    values.versionData.rows.toArray().forEach((row,e) => {
 if(row.versionName == versionName){
 row.State	= State; 
 }
}

    and then the "AddOrUpdateDataTableEntry" will actually do the rest.

    1 reply

    A
    AS_1034065113-AquamarineAuthorAnswer
    13-Aquamarine
    August 8, 2023

    Okay, who ever will use this UpdateQuery should know that this command is actually a copy command and not an update command (thanks for the wrong and confusing naming). 

    That means, if you use it, then the return of UpdateQuery will be a changed copy of the matched query. while the original table is untouched.

     

    i use now this workaround 

    values.versionData.rows.toArray().forEach((row,e) => {
 if(row.versionName == versionName){
 row.State	= State; 
 }
}

    and then the "AddOrUpdateDataTableEntry" will actually do the rest.

      Terms & ConditionsCookie settingsAccessibility statement