3 Replies Latest reply on Jul 17, 2017 3:03 AM by nbhagtani RSS
    nbhagtani Explorer

    How to query infotable to check given column is between specified date values?

    I have got infotable and i need to check that any column(having date value) is between specified start and end date. I tried one sample but it gives me error :

    " Wrapped org.json.JSONException: JSONObject["type"] not found. Cause: JSONObject["type"] not found."

     

    below is the code i tried:

     

    var query = {

       "filters": {

              //type: "OR",

              "filters": [

                {

                "fieldName": "Temperature",

                "type": "BETWEEN",

                "from": startDate,

                "to": endDate

              },

              {

                "fieldName": "Humidity",

                "type": "BETWEEN",

                "from": startDate,

                "to": endDate

              }

             

           ]

       }

    };

     

     

    var recordsToDisplay = Resources['InfoTableFunctions'].Query(

        {       

            query : query,      

            t : requiredRows    

        } );

     

    Please help me where i am going wrong.