Extract date of last comment on csv file

[mregragui_ext]

hello community i want to extract only the date of last comment in a csv file how can i do this please .

[Marcos Kassak]

Hi @mregragui_ext,

You can query the sys_journal_field table with the record that you need and Order By Descending, you will get the latest comments, in order to check the date you can add a few columns and export as you wish.

Don't forget to share your business requirements so we can discuss better solutions for you.

If my response helps to solve your issue. Kindly mark it as helpful & correct. It will be helpful for future readers! 👍

Thanks,
Marcos Kassak
The world works with ServiceNow!