Report on requester conversations of a request
Query :
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
How to compare date column with auto filled date templates?
- Here is the example for getting this week data - CREATEDTIME >= <from_thisweek> AND CREATEDTIME <= <to_thisweek>
- <from_thisweek> - Starting date of this week
- <to_thisweek> - Ending date of this week
- Available Date Templates
- Today - <from_today> - <to_today>
- This week - <from_thisweek> - <to_thisweek>
- Last week - <from_lastweek> - <to_lastweek>
- This month - <from_thismonth> - <to_thismonth>
- Last month - <from_lastmonth> - <to_lastmonth>
- This quarter - <from_thisquarter> - <to_thisquarter>
- Last quarter - <from_lastquarter> - <to_lastquarter>
- Yesterday - <from_yesterday> - <to_yesterday>
Krishna Bharat
ServiceDesk Plus - MSP Support team