Database view where clause to have created in this month condition

[Naveen87]

Hello Developers,

I'm creating a Database view, Incident table is parent here. I'm successful fetching the data however its bit slow.

So I want to add another where clause to check incident created in this Month.

I used the query but it's not supported in Database view & got the below error.

Can anyone please suggest how to add created in this month query here?

[Dr Atul G- LNG]

Hi @Naveen87 

2nd part can be done in reporting only. Use DB view in report and get the data from report.

[Naveen87 · Accepted solution]

Hi @Dr Atul G- LNG ,

This worked for me

'inc.sys_created_on>= DATE_SUB(CURDATE(), INTERVAL 1 MONTH)&&inc.contact_type!='Event''

Got reference from here

https://www.servicenow.com/community/developer-forum/database-view-date-parameter/m-p/1417336

[Dr Atul G- LNG]

Good to know mate.

You can also accept my answer, as I redirected to the right way.