Date Filter Not working in Database view

[Ashu Gunjal]

My Database view is not loading due to huge amount of data almost 30 lpa. I am trying to add datewise filtering the data like 1 year so it will load.

We can't use report here because database page is not loading. please find the attached image of my DB view . 

Table is not loading. can anyone help me to get data by date here. attached image also

join condition:

Table	Order	Left Join	Condition
mi_instance	100	false	(mi_table = 'incident' || mi_table = 'incident_task')
incidnet_task	200	false	inct_sys_id = mi_id
incident	500	false	(inct_incident = inc.sys_id  || mi_id = inc_sys_id)

[Voona Rohila]

Hi Ashu

Can you correct the field name of created on and try.

[Ashu Gunjal]

TThis is the result I got after updating field

[Ryan153]

Hello Ashu,

Have you tried to use the OOTB Metric to Incident view as shown here? I don't know exactly what your use case is for going to the Task table and then to the Incident table but perhaps this could help you. This model will allow you to filter on the Metric Definitions that are important for your report and should help eliminate a lot of the noise.  

[Ashu Gunjal]

This is client requirement