AnsweredAssumed Answered

Thinning out Portal Record

Question asked by TracyBogans on Mar 2, 2015
Latest reply on Mar 8, 2015 by TracyBogans

Title

Thinning out Portal Record

Post

I have a table (Outside Source -ODBC)  that contains ticket information example

ID, UserName, TicketNumber, Description, SystemName, DateTime,                  Status.... and so on.

1  ,        tcb ,       123,              bahbah1,                PC,    2/2/2015 12:01PM,    open

2  ,        tcb ,       123,              bahbah2,                PC,    2/12/2015 2:23PM,     open

3  ,        smc ,     123,              bahbah3,                PC,    2/22/2015 2:01AM,      open

4  ,        pat ,       123,              bahbah4,                 PC,   2/27/2015 11:01AM,    closed

5  ,        smc ,     124,              bahbah3,                PC,    2/28/2015 2:01AM,      open

6  ,        tcb ,       124,              bahbah4,                 PC,   3/1/2015 11:01AM,    closed

 
I want to create a portal(1st choice) or report(if portal cant be done)  that will show the first ticket and the latest record. (Start off Ticket and lastest update)  . A ticket could stay open for 2 weeks and have 30 records tied to that ticketNumber. ID Field is a field that I added to this imported data.. Auto-Enter Serial (Text field)

Outcomes