Javascript in Ms CRM (with odata query) is not working?

Question

I created a javaScript(by the way i learned it yesterday only )

this script is set to fire upon OnSave event of Accounts entity . I build a odata query using query builder tool that i found on Internet which is supposed to retrive all the tasks ($select=ActivityId,CreatedOn ) and whcih are created before 2015-01-26T18:30:00.000Z ($filter=CreatedOn ge datetime'2015-01-26T18:30:00.000Z')

here is the actual query from query builder :

$.ajax({
    type: "GET",
    contentType: "application/json; charset=utf-8",
    datatype: "json",
    url: Xrm.Page.context.getClientUrl() + "/XRMServices/2011/OrganizationData.svc/TaskSet?$select=ActivityId,CreatedOn&$filter=CreatedOn ge datetime'2015-01-26T18:30:00.000Z'",
    beforeSend: function (XMLHttpRequest) {
        XMLHttpRequest.setRequestHeader("Accept", "application/json");
    },
    async: true,
    success: function (data, textStatus, xhr) {
        var results = data.d.results;
   for (var i = 0; i < results.length; i++) {
        var ActivityId = results[i].ActivityId;
        var CreatedOn = results[i].CreatedOn;
   }
    },
    error: function (xhr, textStatus, errorThrown) {
        alert(textStatus + " " + errorThrown);
    }
});

in the query builder it returns result :

[
    {
        "CreatedOn": "/Date(1422342587000)/",
        "ActivityId": "c23ba479-f3a5-e411-80dc-c4346bada6a4"
    },
    {
        "CreatedOn": "/Date(1422342783000)/",
        "ActivityId": "ba7754ee-f3a5-e411-80dc-c4346bada6a4"
    },
    {
        "CreatedOn": "/Date(1422343425000)/",
        "ActivityId": "12d40a6d-f5a5-e411-80dc-c4346bada6a4"
    }
]

in the result i found that created on returns date as value "CreatedOn": "/Date(1422343425000)/", ..

I wanted to retrive all the tasks created 7 days prior to creating an new record in Accounts entity ..So i wrote logic got the current dat in terms of generic value var current_date = Date().valueOf() and subtracted 7 days in milisecs (7*24*60*60*1000=604800000) var week_earlier = current_date - 604800000;

in the code below you can see what i did

function retrive()
{
    //var date =2015-01-26T18:30:00.000Z;
    var current_date = Date().valueOf();
    var week_earlier = current_date - 604800000;



    $.ajax({
        type: "GET",
        contentType: "application/json; charset=utf-8",
        datatype: "json",
        url: Xrm.Page.context.getClientUrl() + "/XRMServices/2011/OrganizationData.svc/TaskSet?$select=ActivityId,CreatedOn&$filter=CreatedOn ge datetime'"+week_earlier+"'",
        beforeSend: function (XMLHttpRequest) {
            XMLHttpRequest.setRequestHeader("Accept", "application/json");
        },
        async: true,
        success: function (data, textStatus, xhr) {
            var results = data.d.results;
            for (var i = 0; i < results.length; i++) {
                var ActivityId = results[i].ActivityId;
                var CreatedOn = results[i].CreatedOn;
            }

            alert("number of records found  :"+results.length);

        },
        error: function (xhr, textStatus, errorThrown) {
            alert(textStatus + " " + errorThrown);
        }
    });

}

but its not working....it shows

"error Bad Request"

and i also tried quering with the in the url of browser with

https://avikcompany.crm5.dynamics.com/XRMServices/2011/OrganizationData.svc/TaskSet?$select=CreatedOn,ActivityId&$filter=CreatedOn ge datetime'1422342587000'(this '1422342587000' is present in result  of the previously fired query).

but it also threw an error





    
        

        

        HTTP 400 Bad Request

        
        
    

    

        

        
            
                
                    
                
                
                    The webpage cannot be found
                
            



            
                
                 HTTP 400
                    
                
            


        

        
            
                
                     
                
                
                    Most likely causes:
                    
                        There might be a typing error in the address.
                        If you clicked on a link, it may be out of date.
                    
                
            

            
                
                     
                
                
                    What you can try:
                
            

        
            
                
                     
                
                
                    
                        
                          
                              
                                  
                              
                              
                                  Retype the address.
                              
                          

                        
                    
                
            

        
            
                
                     
                
                
                    
                        
                          
                              
                                  
                              
                              
                                  
                              
                          
                        
                    
                
            


        
            
                
                     
                
                
                    
                        
                          
                              
                                  
                              
                              
                                  Go to  and look for the information you want.
                              
                          
                        
                    
                
            

        
            
                
                     
                
                
                    
                        
                          
                              
                                  
                              
                              
                                  
                                  
                              
                          
                        
                    
                    
                        This error (HTTP 400 Bad Request) means that Internet Explorer was able to connect to the web server, but the webpage could not be found because of a problem with the address.
                        For more information about HTTP errors, see Help.

Can any body tell me where i went wrong ? (I am asuming the date value i mentioned is not accepeted by the crm odata service ) Or how to convert date to this format "yyyy-mm-ddThh:mm:ss.uuuZ"

Royalty · Accepted Answer

You can easily get the date in that format by using toISOString();

http://jsfiddle.net/j5m97nfv/3/

var current_date = new Date().valueOf();
var week_earlier = new Date(current_date - 604800000);
var n = week_earlier.toISOString();

One problem you have in your code above is you are not constructing a new Date object. Your current_date is actually returning a date string that is not the date's representation in milliseconds. You need new Date();

Javascript in Ms CRM (with odata query) is not working?

Answers (1)

Related Questions