Dears,
I need to get records (CIs) with Installed date in the current month, regardless of the year.
In ServiceNow there are already some 'trend' filter to do this, but only a static month can be used:
How can I implement the same filter, but with the condition 'Installed trend on current month'?
Thank you,
Sutot
hi,
I got your issue you are looking for records installed on a current month regardless of the year.
So one thing that you can do is to create a script include and set the filter to sys_id isOneOf javascript:getTrendONCurrentMonth('field_name','table_name')
here is how you can use that script include in filter
script include should be client callable
here is the code for script include
this code will automatically get the current month and will return the trend on records.
function getTrendONCurrentMonth (fieldName,tableName) {
var StringMonth='';
var shortMonth='';
var integerMonth=new GlideDateTime().getMonth();
switch(integerMonth)
{
case 1:
StringMonth='January';
shortMonth='jan';
break;
case 2:
StringMonth='February';
shortMonth='feb';
break;
case 3:
StringMonth='March';
shortMonth='mar';
break;
case 4:
StringMonth='April';
shortMonth='apr';
break;
case 5:
StringMonth='May';
shortMonth='may';
break;
case 6:
StringMonth='June';
shortMonth='june';
break;
case 7:
StringMonth='July';
shortMonth='july';
break;
case 8:
StringMonth='August';
shortMonth='aug';
break;
case 9:
StringMonth='September';
shortMonth='sep';
break;
case 10:
StringMonth='October';
shortMonth='oct';
break;
case 11:
StringMonth='November';
shortMonth='noc';
break;
case 12:
StringMonth='December';
shortMonth='dec';
break;
}
var sys_ids='';
var g=new GlideRecord(tableName);
g.addEncodedQuery(fieldName+"DATEPART"+StringMonth+"@javascript:gs.datePart('month','"+shortMonth+"','EE')");
g.query();
while(g.next())
{
if(sys_ids=='')
{
sys_ids+=g.getUniqueValue();
}else{
sys_ids+=','+g.getUniqueValue();
}
}
return sys_ids.toString();
}
Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Hammad ul Aziz
