Incoming and Outgoing conversations with Attachment name and location (MSSQL & PGSQL)

Tested in Build PGSQL (14300) or MSSQL (14306)

PGSQL & MSSQL:

Incoming: (Referred as 'Conversations' in the database)

select conv.conversationid "Conversation ID", conv.workorderid "Request ID", wo.title "Request Subject", aaau.first_name "Sender", LONGTODATE (Conv.createdtime) "Incoming Conversation created time", Conv.title "Incoming Conversation subject", conv.ispublic "Public Conversation", sda.attachmentname "Attachment name", sda.attachmentpath "Attachment Path" FROM workorder wo LEFT JOIN conversation conv ON wo.workorderid=conv.workorderid LEFT JOIN conversationdescription convd ON conv.conversationid=convd.conversationid LEFT JOIN sduser sdu ON conv.requesterid=sdu.userid LEFT JOIN aaauser aaau ON sdu.userid=aaau.user_id LEFT JOIN workordertodescription wtd ON wtd.workorderid = wo.workorderid LEFT JOIN Conversationattachment ca ON conv.conversationid=ca.conversationid LEFT JOIN SDESKATTACHMENT SDA ON ca.attachmentid=sda.attachmentid where conv.ispublic='true' AND wo.createdtime>=<from_lastmonth> and wo.createdtime<=<to_lastmonth> group by conv.workorderid, wo.TITLE, conv.conversationid, aaau.first_name, Conv.createdtime, Conv.title, conv.ispublic, sda.attachmentname, sda.attachmentpath ORDER BY 2

Outgoing: (Referred as 'Notifications' in the database)

select n.notificationid "Notification ID", wo.workorderid "Request ID" , wo.title "Request Subject", longtodate(n.Notificationdate) "Outgoing conversation sent date" ,n.notificationtitle "Conversation subject", nau.first_name "Sender name", N.ISPUBLIC "Public conversation", sda.attachmentname "Attachment Name", sda.attachmentpath "Attachment Path" from workorder wo left join notify_workorder nw on wo.workorderid=nw.workorderid LEFT JOIN notification n on nw.notificationid=n.notificationid left join aaauser nau on n.senderid=nau.user_id left join notificationtodesc nod on n.notificationid=nod.notificationid left join notify_attachments na on n.notificationid=na.notificationid left join sdeskattachment sda on na.attachmentid=sda.attachmentid where n.ispublic='true' AND wo.createdtime>=<from_lastmonth> and wo.createdtime<=<to_lastmonth> AND nau.first_name!='system' group by n.notificationid,wo.workorderid, wo.TITLE, n.Notificationdate, n.notificationtitle, nau.first_name, N.ISPUBLIC, sda.attachmentname, sda.attachmentpath ORDER BY 2

How to compare date column with auto filled date templates?