Craig Brass Systems Forum: getSubmittedTicket does not return correct result set - Craig Brass Systems Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

getSubmittedTicket does not return correct result set

#1
User is offline   moosarka 

  • Member
  • Pip
  • Group: Members
  • Posts: 8
  • Joined: 24-November 08
Andrew,

It looks like getSubmittedTickets might not return the correct result set. In the function, the where clause which retrieves the list of tickets for a given email uses the userid criteria. You may want to change the criteria to match against the email instead.

When a ticket is created, it's userID is set. However, you can always edit the ticket's owner email address, but the userid remains the same.

from: $whereClauses[] = 'userid=' . ((int) $userId);
to: $whereClauses[] = 'email="'. $email .'"';

What do you think?

Peter



0

#2
User is offline   Craig Brass 

  • Staff - Managing Director and Chief Software Architect
  • PipPipPip
  • Group: Management
  • Posts: 349
  • Joined: 17-January 07
The GetSubmittedTickets would also be wrong then wouldn't it as this is getting all tickets owned by the user id of the email address supplied via the API?
Craig Brass
Managing Director and Chief Software Architect - Craig Brass Systems
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users