I am trying to request, as exposed in the subject, all the tickets that went through the Approval process.
I thought the following request would be enough :
SELECT UserRequest FROM UserRequest AS UserRequest WHERE (UserRequest.approver_id != 0)
But, strangely, it returns only a dozen of UserRequests which seems strange compared to the 54 in a "rejected" status.
Could anyone of you be kind enough to share his precious knowledge?
Yours sincerely,
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi all,
I am trying to request, as exposed in the subject, all the tickets that went through the Approval process.
I thought the following request would be enough :
SELECT UserRequest FROM UserRequest AS UserRequest WHERE (
UserRequest.approver_id!= 0)But, strangely, it returns only a dozen of UserRequests which seems strange compared to the 54 in a "rejected" status.
Could anyone of you be kind enough to share his precious knowledge?
Yours sincerely,
Forget it, i think i have an issue.
Sorry for the inconvenience created by my newbie-ness (can't find a way to delete my topic)