Service tickets: PERSIPHONE CO.

Resolved tickets for PERSIPHONE CO.

Outstanding tickets for PERSIPHONE CO.

The essential code to do this operation relies on parameters (for example, custid and status) passed in from an HTML form in a servlet:

   String custid = request.getParameter("custid");
   String status = request.getParameter("status");
   String sql = "select * from problem where custid='" + custid + "' and status='" + status + "';"
   // next, just fill the table... 
 
CUSTIDPROBLEMIDCONTACTIDSUMMARYRESOLUTIONPRIORITYSTATUSOWNERCITYOPENEDUPDATEDCLOSED
PERSIPHONE CO.6MARVIN MCCARTHYAUTO ROLLOVER INTERMITTENT MediumEscalated Montpellier   
PERSIPHONE CO.13LILLY WONGTWO EXTENSIONS SEEM TO BE CROSS-CONNECTED HighEscalated Atlanta   

More . . .