I am trying to find a minimum value for QUEUED status.
Example: If a ticket is QUEUED for 4 times I need to get the value for the first it was QUEUED i.e. I need to get the minimum change date for the ticket QUEUED.
I have tried using the query "(SELECT MIN (CHANGEDATE) AS CHANGEDATE , TICKETID FROM MAXIMO.TKSTATUS WHERE STATUS = 'QUEUED' GROUP BY TICKETID)"
I have added a new table in the data model as"STATUS_HISTORY_NEW" and have used the above query. Have used left outer join still not able to get the reports.
Our database is Oracle.
below is the screenshot of data model.