Need to include a condition in script include 'ImportSetCleaner'

[mdrafi]

Hi,

We have a import set table (u_reply), currently only 1 week of data maintained on this table. There is an OOTB Scheduled job 'Import Set Deleter' which is removing the data older than 7 days. It calls OOTB script include 'ImportSetCleaner'.

What I need is, I want to have 30 days of data only for the import set table mentioned above. I am having difficulty in modifying the script as I can't change the value of the variable 'daysAgo' present in the script include, because it affects all the import set tables. As per my analysis, we need to add a condition for this table in '_removeData' function but how to set the 30 days?

Can you suggest on this.

Thanks,

Rafi

[mdrafi]

Hi Ankur,

I tried it today, but no luck.

Thanks,
Rafi

[Ankur Bawiskar]

Hi Rafi,

Can you share the code which you updated in that script include?

Regards

Ankur

[mdrafi]

Hi Ankur,

Here is the code I changed in _queryIsets. I would like to test with 3 days first.

_queryIsets : function() {

var gr = new GlideRecord('sys_import_set');

gr.setLimit(this.isetsChunk);

if (this.table)

gr.addQuery('table_name', this.table);

if (this.daysAgo > 0){

if(this.table == 'u_cgi_remedy_reply'){

gr.addEncodedQuery('sys_created_onRELATIVELE@dayofweek@ago@' + 3);

}

else{

gr.addEncodedQuery('sys_created_onRELATIVELE@dayofweek@ago@' + this.daysAgo);

}

}

gr.query();

var isets = new Array();

while (gr.next()) {

this._log('Cleaning import set ' + gr.number);

isets.push(gr.sys_id + '');

}

return isets;

},

Thanks,

Rafi

[Ankur Bawiskar]

Hi Rafi,

Did you add log statements in the script include function. I have added you can also add and check in system log table.

_queryIsets : function() {

gs.log('Rafi inside queryIsets method');

var gr = new GlideRecord('sys_import_set');

gr.setLimit(this.isetsChunk);

if (this.table)

gr.addQuery('table_name', this.table);

if (this.daysAgo > 0){

if(this.table == 'u_cgi_remedy_reply'){

gs.log('Rafi inside table is remedy reply');

gr.addEncodedQuery('sys_created_onRELATIVELE@dayofweek@ago@' + 3);

}

else{

gr.addEncodedQuery('sys_created_onRELATIVELE@dayofweek@ago@' + this.daysAgo);

}

}

gr.query();

var isets = new Array();

while (gr.next()) {

this._log('Cleaning import set ' + gr.number);

isets.push(gr.sys_id + '');

}

return isets;

},

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Ankur

[Ankur Bawiskar]

Hi Rafi,

Any update on this?

Regards

Ankur