Create new date filter in BOEXI40-Audit-MSSQUL

[Former Member]

Hi experts,

It is my first time working on IDT and sql sentences and I would appreciate some help. I am using the auditing universe (BOEXI40-Audit-MSSQUL) and there are several date filters (current month, previous month, current year, etc), but I need to develop a new one. The user will select a date (year-month), and the query would have to show data between that selected month and 11 month before. In other words, from a specific month, get the last full year.

There is a filter called "Custom date range" but you have to select the start date and end date. In my case start date should be calculated..

Do you know what would be the best way to do it??

Thanks in advance, best regards.

[amitrathi239 · Accepted solution]

Hi,

Create new filter in the universe.This is based on the Audit SQL server and this filter will fetch last 12 month data based on the Event Start time.

@Select(Events\Event StartTime)  between dateadd(month,-12 ,@Prompt('Enter a Date','D',,Mono,Free,Persistent))

and

@Prompt('Enter a Date','D',,Mono,Free,Persistent)

[Former Member · Accepted solution]

It works perfect, thanks Amit!