Get Contacts last incident

Summary

How to get the last incident created for each contact

Content

Hello All,

We have requirement to anonymise contact 6 months after their last incident created. I have tried last and max expression, but it gives latest one value. we want to fetch last incident for all contact using ROQL. Can anyone help to sort out this.

 

Thanks,

kanchana