Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X
Am writing service to add or update record in data table and input to my service is "Tag" which will hold value like "Temperature".
My data table has fields like device_name, temperature, flow, pressure, etc (8 other fields).
So at run time i will get to know which field to update of data table but "AddOrUpdateDataTableEntry" service takes "values" in its params and this value is like empty
infotable which gets created like this :
var values = me.CreateValues();
values.DeviceName = deviceName;
values.Temperature = value;
values.Pressure1 = value;
values.Flow = value;
i dont want to check if tag value is "temperature" then values.Temperature = value because i need to write 10 if conditions as i have 10 fields
am unable to append tag value(temperature) to values.
how to create variable for above values at run time?
Solved! Go to Solution.
Dear Nisha,
Did you consider to use a for iterator to loop your Data Table fields and match it with your Tag, and then set value accordingly?
Here is my code:
Attached here:
// result: INFOTABLE dataShape: EntityList
var fields = Things["DT1"].GetFieldNames();
// result: INFOTABLE
var values = Things["DT1"].CreateValues();
values.id=6;//this is the primary ID you have to set a value to.
var tableLength = fields.rows.length;
for (var x = 0; x < tableLength; x++) {
var field = fields.rows
; if(field.name==Tag)
values[field.name]=value;
}
var params = {
sourceType: undefined /* STRING */,
values: values /* INFOTABLE*/,
location: undefined /* LOCATION */,
source: undefined /* STRING */,
tags: undefined /* TAGS */
};
// result: STRING
var id = Things["DT1"].AddOrUpdateDataTableEntry(params);
I set an id for the Data Table static but you could set it with your own dynamic way.
Thanks,
Br,
Anna
Dear Nisha,
Did you consider to use a for iterator to loop your Data Table fields and match it with your Tag, and then set value accordingly?
Here is my code:
Attached here:
// result: INFOTABLE dataShape: EntityList
var fields = Things["DT1"].GetFieldNames();
// result: INFOTABLE
var values = Things["DT1"].CreateValues();
values.id=6;//this is the primary ID you have to set a value to.
var tableLength = fields.rows.length;
for (var x = 0; x < tableLength; x++) {
var field = fields.rows
; if(field.name==Tag)
values[field.name]=value;
}
var params = {
sourceType: undefined /* STRING */,
values: values /* INFOTABLE*/,
location: undefined /* LOCATION */,
source: undefined /* STRING */,
tags: undefined /* TAGS */
};
// result: STRING
var id = Things["DT1"].AddOrUpdateDataTableEntry(params);
I set an id for the Data Table static but you could set it with your own dynamic way.
Thanks,
Br,
Anna
Thanks Anna it worked