Database view to filter the tickets created on last 6 months

[Hari1]

Hi,

Need help to add filter condition for the database view to the tickets created on last 6 months.

I tried using inc_sys_created_on<javascript:gs.beginningOfLast6Months() but it's not working

[Noor Mohammad1]

hi hemanth,

try with this 

sys_created_onONLast 6 months@javascript:gs.beginningOfLast6Months()@javascript:gs.endOfLast6Months()^EQ

thanks,

S Noor Mohammad

[Hari1]

Hi Noor,

Please look into the below screenshots

I am getting the below error.

[Noor Mohammad1]

i am not sure of the where clause throwing those errors as you are putting that in database view, can you just remove those last 6 months condition and add filter condition after you create reports for that particular database view  instead.

[Hari1 · Accepted solution]

I was able to achieve this by using "sys_created_on>= DATE_SUB(CURDATE(), INTERVAL 6 MONTH)"