1 Reply Latest reply on Apr 12, 2016 11:32 AM by qngo RSS
    jrajesh Newbie

    Format of the input for the source and query fields for the QueryDataTableEntries service of the DataTable

    Hi,

     

    What is the format of the input for the source and query fields for the QueryDataTableEntries service of the DataTable? Please give examples.

     

    Thanks and Regards,

    Jyothi

      • Re: Format of the input for the source and query fields for the QueryDataTableEntries service of the DataTable
        qngo Creator

        Hi,

         

        A query example:

        http://support.ptc.com/cs/help/thingworx_hc/thingworx_7.0_hc/index.jspx?id=QueryParameterforQueryServices&action=show

         

        var query = {
            filters: {
                type: "And",
                filters: [
                    {
                        type: "LIKE",
                        fieldName: "ID",
                        value: "%" + id + "%"
                    }, 
                    {
                        type: "LIKE",
                        fieldName: "EntityType",
                        value: entityType
                    }
                ]
            }
        };
        
        

         

        The source depends on how you add entry to table. By default, it's the login username. You can check it in your DataTable / Entity Information / Home Mashup.

         

        QueryDataTableEntries service:

         

        var params = {
         maxItems: undefined /* NUMBER */,
         values: undefined /* INFOTABLE*/,
         query: query /* QUERY */,
         source: "A_String" /* STRING */,
         tags: undefined /* TAGS */
        };
        
        // result: INFOTABLE
        var result = Things[DataTableName].QueryDataTableEntries(params)
        

         

        Regards,

        Quang-Dung