Conversations for all open tickets.
I have this report which shows me the conversations for tickets within a time frame. What modification would I need to do in order to get the report for all open tickets? Thanks.
SELECT workorder.WORKORDERID "Request ID"
SELECT workorder.WORKORDERID "Request ID"
, workorder.TITLE "SUBJECT"
, longtodate(conversation.CREATEDTIME) "Conversation TIME"
, conversation.TITLE "Reply SUBJECT"
, conversationdescription.DESCRIPTION "Reply"
, aaauser.FIRST_NAME "Replied requester" FROM conversation
LEFT JOIN workorder ON (conversation.WORKORDERID = workorder.WORKORDERID)
LEFT JOIN aaauser ON (conversation.REQUESTERID = aaauser.USER_ID)
LEFT JOIN conversationdescription ON (conversationdescription.CONVERSATIONID = conversation.CONVERSATIONID)
where workorder.createdtime >= <from_thismonth> and workorder.createdtime <= <to_thismonth>
order by 1 DESC