How can I get the max date result most current transaction for this?
- SELECT ticket.ticket_number,
-
max(Ticket_status_history.addeddate) as date,
-
(ticket_status.lastupdateddate),
-
max(Ticket_Status.description )AS Equipment_Status
-
-
FROM Ticket
-
INNER JOIN Tickets_Extended
-
ON Ticket.ticket_number = Tickets_Extended.ticket_number
-
INNER JOIN Tickets_Extended_Flex
-
ON Tickets_Extended.field_number = Tickets_Extended_Flex.field_number
-
INNER JOIN Tickets_Extended TE
-
ON ((Ticket.ticket_number = TE.ticket_number) AND (TE.field_number = 8))
-
INNER JOIN Ticket_Status_History
-
ON Ticket.ticket_number = Ticket_Status_History.Ticket_number
-
INNER JOIN Ticket_Status
-
ON Ticket_Status_History.Current_Status = Ticket_Status.id
-
-
WHERE (Tickets_Extended_Flex.LabelText = 'product number')
-
and ticket.ticket_number=2729382
-
group by ticket.ticket_number
-
, ticket_status.lastupdateddate
-
