cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

dynamic

Muthu_chithira
Regular Member

dynamic

I have to display grid dynamically(But multiple rows in sql have to displayed in single row in grid). Its keep on change based on value selecting in combo box.

For eg:

am having this table in sql 

 

Now this "wi_id" in combobox

Based on the selection i must diplay this field_name, and field_value.

But i must display in a single row. Here number of rows is not fixed. It keep on change

 

 like this. Field_name becomes header, and field_value in rows. (eg: i took wi_id=3)

 

 

To get this result :

 

Get TAble From SQL

var params = {
WiName: WorkInstrn /* STRING */
};

// result: INFOTABLE dataShape: "BOBCAT_SpecifcationDetais_DS_C"
det = me.Wi_FieldDetails(params);

 

Create INfoTAble

var params = {
infoTableName: WorkInstrn/* STRING */
};

// result: INFOTABLE
a= Resources["InfoTableFunctions"].CreateInfoTable(params);

Add Field NAme for Created Infotable

for( i=0 ; i<det.length ;i++ )
{
var newField = new Object();
newField.name = det.rows[i].field_name;
newField.baseType = 'STRING';
a.AddField(newField);
}

Adding Row in Infotable
var newRow=new Object();
for(i=0 ; i<det.length ;i++ )
{
b=det.rows[i].field_name
c=det.rows[i].field_value
newRow.b=c         ------------Here am getting issue. I couldnt give header dynamically.it takes 'b' as header ,not the value of b

}
a.AddRow(newRow);

var result=a

 

 

 

Give solution for this.How to achieve this. FOr this infotable , rows,field everyting have to change dynamically..

 

Announcements

Check out the upcoming Expert Session: Understanding ThingWorx Navigate Licensing in Community "Customer Events" section.