Service tickets: ASTROTECH CO.

Resolved tickets for ASTROTECH CO.

Outstanding tickets for ASTROTECH 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
ASTROTECH CO.1JON PEARSONNIGHT BELL INOPERATIVE HighEscalated Atlanta   
ASTROTECH CO.7TED WILKINSONCALL WAITING DISCONNECTS CALLER HighEscalated Pierre   
ASTROTECH CO.10FRED CHAVEZTRUNK BETWEEN BUILDINGS NOISY MediumEscalated Atlanta   
ASTROTECH CO.10FRED CHAVEZBAD SPARES LowEscalated Atlanta   

More . . .