My script is not working

[suuriyas]

HI Community,

I have a requirement to generate a request when the records in sys certificate table has no valid from and no expires and with tag as valid certificate only for these records the request needs to be generated after 11 months from the created date.

so i have written a scheduled job for this and i tried testing it in background script but it is not working

Please let me know what is wrong in my script 

Note ; while testing i commented out this line (createdDateTime.addMonths(11);)

and created one new record in certificate table today and tested but it did not work

My script :

(function(){

    var today = new GlideDateTime();

    var certificates = new GlideRecord('sys_certificate');

    certificates.addNullQuery('valid_from');

    certificates.addNullQuery('expires');

    certificates.query('sys_tags','valid certificate');

    certificates.query();

while (certificates.next()){

    var createdDate = certificates.getValue('sys_created_on');

    var createdDateTime = new GlideDateTime(createdDate);

    createdDateTime.addMonths(11);

    if (createdDateTime.getDate() == today.getDate()&& createdDateTime.getMonth() == today.getMonth()&& createdDateTime.getYear() == today.getYear())

    {

        var cart = new Cart();

        var item = cart.addItem ('0b6fa369ebcc9610b2bff25e1bd0cd63');

        cart.setVariable(item, 'requested_for','e78e613febf41650b2bff25e1bd0cda3');

        cart.setVariable(item, 'username' , 'extsridhsu');

        cart.setVariable(item, 'short_description', 'Certificate expiration request for ' + certificates.name);

        cart.setVariable(item, 'business_justification', 'Certificate is about to expiry in next 30 days');

        var rc = cart.placeOrder();

    }

}

})();

[Ankur Bawiskar]

@suuriyas 

what debugging did you do?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@suuriyas 

are you sure you are forming the correct query for tags?

did you add gs.info() and see?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[suuriyas]

HI @Ankur Bawiskar ,

Thanks for replying

yes i  added the gs.info msg inside the if condition but logs are not showing seems issue with if condition but im not sure.

Just for testing i commented out the tags query also but no luck.

In sys certificate table there is one record that matches but not sure why if condition is not working 

[Ankur Bawiskar]

@suuriyas 

till the time your query works fine, it won't go inside.

I have doubt about sys_tags field query syntax.

please check that

If my response helped please mark it correct and close the thread so that it benefits future readers.