topic Valid DeriveFields expressions in ThingWorx Developers

Valid DeriveFields expressions

BradC — Tue, 19 Nov 2019 14:45:52 GMT

Hi Everyone,

We are trying to fill in a thing name in the GetDesignTimePermission result infotable using the DeriveField snippet.

var params = { type: "Thing" /* STRING */, maxItems: 1000000 /* NUMBER */ }; var result1 = Resources["EntityServices"].GetEntityList(params); var result2 = Things[result1.rows[0].name].GetDesignTimePermissions(); //This is only for a single entity for testing purposes var params = { types: "STRING" /* STRING */, t: result2 /* INFOTABLE */, columns: "EntityName" /* STRING */, expressions: "result1.rows[0].name" /* STRING */ }; var result = Resources["InfoTableFunctions"].DeriveFields(params);

However we are having trouble finding a valid expression.

Error executing service GetDesignTimePermissionsforUser. Message :: Script evaluation error : ReferenceError: "result1" is not defined. (DSLCompiledExpressionProcessor#1) - See Script Error Log for more details.

What would be a valid expression to add the relevant thingname in a new column using DeriveFields?

Thanks,

Re: Valid DeriveFields expressions

abrigode — Tue, 19 Nov 2019 15:52:58 GMT

Hi BradC,

I don't think you will be able to add the Thing name through the use of DeriveFields(). This infoTable function is listed in a calculations category and only seems to work with mathematical expressions in my testing.

DeriveFields()

It may not be ideal but you can add a new column to your infoTable by using AddField() and writing logic to fill the cell value.

Re: Valid DeriveFields expressions

BradC — Thu, 21 Nov 2019 06:49:04 GMT

Thanks @abrigode for confirming that.