Update infotable rows thingworx 9.1.0

Hi,

UpdateQuery function will only return the row(s) that got updated not the entire infotable with updated records.

So you probably need to update every field one by one.

Please find below my code for reference:

//Step 1: Find the record with matching batch
let query = {
    "filters": {
        "type": "EQ",
        "fieldName": "Batch",
        "value": batch
    }
};

let matchingBatch = me.QueryDataTableEntries({
    values: undefined /* INFOTABLE */,
    maxItems: undefined /* NUMBER */,
    tags: undefined /* TAGS */,
    source: undefined /* STRING */,
    query: query /* QUERY */
});

//Step 2: Find the row of the "Members" infotable to update with matching MachineName & UserID
// Update every field of the row to the corresponding value of "value" input
let members = matchingBatch.Members,
    mn=value.rows[0].MachineName,
    uid=value.rows[0].UserID,
    valueCollection = new Object();
valueCollection.MachineName = mn;
valueCollection.UserID = uid;
// update the rest fields one by one
members.Find(valueCollection).FieldToUpdate = value.FieldToUpdate;

// Step 3: Create a single row of infotable with updated Members Info
let newEntry = {
    Batch: batch, // STRING [Primary Key]
    Members: members // INFOTABLE
};

let newRecord = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({
    infoTableName: "InfoTable",
    dataShapeName: "DataTableShape"
});
newRecord.AddRow(newEntry);

// Step 4: Use AddOrUpdateDataTableEntry to update record with matching Batch which is the PK
me.AddOrUpdateDataTableEntry({
    sourceType: undefined /* STRING */,
    values: newRecord /* INFOTABLE */,
    location: undefined /* LOCATION */,
    source: undefined /* STRING */,
    tags: undefined /* TAGS */
});

Hi @VaibhavShinde ,

You should make adjustments to below line of code instead of copying my code as "FieldToUpdate" is a field I made it up.

members.Find(valueCollection).FieldToUpdate = value.FieldToUpdate;

Make adjustment depending on how the datashape you defined for your "Members" infotable.

e.g If your Members has following structure:

MachineName  UserID  FieldA  FieldB

Then change to below code:

members.Find(valueCollection).FieldA = value.FieldA;

members.Find(valueCollection).FieldB = value.FieldB;