Report for financial year

[Nikithesh R]

Hello All,

I have to create report incidents open in financial year. Kindly help me out how to create filter.

Thanks.

[Ankur Bawiskar]

@Nikithesh R 

you will have to do some custom logic for this if you don't see any such option in the date filter

create client callable script include and query and return those INCs which are created between the financial year you want

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

[Nikithesh R]

@Ankur Bawiskar 

I want create report on Incident table which are open for the financial year. Example: Current year June to Next year May.

I want this report to run every year. Can you suggest me the solution.

Thanks

[Ankur Bawiskar]

@Nikithesh R 

then create a report with this year June to next year May

then run a yearly scheduled job which runs on 31st May every year and simply update the report filter condition via GlideRecord

I shared solution few years ago, simply enhance it

Can we write script to change reports filter condition? 

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

[Nikithesh R]

@Ankur Bawiskar 

Please help me to get Previous year June 1st in filter in below code.

var gr = new GlideRecord('sys_report');
gr.addQuery('sys_id','b44000f283290210a38da9e0deaad319');
gr.query();
if(gr.next())
{
	var gdt = new GlideDateTime(gs.nowDateTime());

	var query = "sys_created_onBETWEENjavascript:gs.dateGenerate('" + Previous year June 1st+ "','" + "00:00:00" + "')@javascript:gs.dateGenerate('" + gdt.getDate() + "','" + "00:00:00" + "')";

	gr.filter = query;
	gr.update();
}