1 Reply Latest reply on Oct 30, 2015 1:25 AM by jaeyan RSS
    jaeyan Explorer

    Is there "Distinct" function in the Infotable services?

    I would like to get distinct items from results that are infotable type.

    It's similar with "distinct()" of SQL.


    Is there anyone know about this as a embedded function of Thingworx?

      • Re: Is there "Distinct" function in the Infotable services?
        jaeyan Explorer

        I'm sorry.

        I found distinct service in the Infotable function.


        Below is my code.

        Please refer my code if you have same problem of mine.



        var params = {

          maxItems: 500 /* INFOTABLE */,

          startDate: undefined /* QUERY */,

            endDate : undefined,

            oldestFirst: false,




        var result = me.QueryPropertyHistory(params);



        var params = {

          t: result,

            columns: "UserID"




        // result: INFOTABLE dataShape: "undefined"

        var result = Resources["InfoTableFunctions"].Distinct(params);