SAW56
asked on
Business Objects sql for previous month
I need assistance modifying the following SQL so it pulls the incidents that were created in the previous month.
SELECT
SCN.INCIDENT.INCIDENT_ID,
SCN.INCIDENT.ASSIGNMENT_GR OUP,
SCN.INCIDENT.OPEN_TIME,
SCN.INCIDENT.UPDATE_TIME,
SCN.INCIDENT.STATUS
FROM
SCN.INCIDENT
WHERE
( SCN.INCIDENT.ASSIGNMENT_GR OUP IN ( 'Purchasing', 'Accounting','Engineering' ,'Fleet' )
AND
SCN.INCIDENT.STATUS IN ( 'Pending Vendor','Open','Pending Other','Completed','Pendin g Customer','Work In Progress','Accepted','Wait ing for Part','Referred','Part on Order','Pending Change' )
)
Thank you.
SELECT
SCN.INCIDENT.INCIDENT_ID,
SCN.INCIDENT.ASSIGNMENT_GR
SCN.INCIDENT.OPEN_TIME,
SCN.INCIDENT.UPDATE_TIME,
SCN.INCIDENT.STATUS
FROM
SCN.INCIDENT
WHERE
( SCN.INCIDENT.ASSIGNMENT_GR
AND
SCN.INCIDENT.STATUS IN ( 'Pending Vendor','Open','Pending Other','Completed','Pendin
)
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.