Get a Particular Infotable Field with a Service

[vieirac1]

Hi Team,

I have the below service, calling QueryImplementingThingswithData that returns to me an Infotable with several fields,

However, I only want my service to return a particular field from this infotable, please, how to do it?

// result: INFOTABLE dataShape: "RootEntityList"
var retorno = ThingTemplates["MyTemplate"].QueryImplementingThingsWithData({
maxItems: undefined /* NUMBER */,
nameMask: undefined /* STRING */,
query: myquery /* QUERY */,
tags: undefined /* TAGS */
});

//this query will return an infotable with many fields, how do I return only 1 of these fields?

var result = //I just need 1 field from the infotable above

[Radu]

Hi,

In the Query service, you can define maxItems as 1, and it will only return one result.

[vieirac1]

Actually, i need to return all rows, but only a particular field for these set of rows

[Radu]

You can use the Distinct() method of the InfoTableFunctions for that. Search for "Distinct" in Code Snippets.

[vieirac1]

Tks a lot, will test and let you know

I thought distinct would remove rows with similar values

[Radu · Accepted solution]

That's what Distinct does, it removes duplicates and returns only one column.

If you want to keep the duplicates, you'd have to use the CreateInfoTable service to create a new infotable, add the desired field to it through AddField, and then add rows to the newly created infotable using AddRow and iterating through the bigger infotable.

You can access column values like this: info.rows[x].columnName.