Here is my query and Object Properties
select
T.ID,
T.ENTITY_TYPE as "EntityType",
T.ENTITY_ID as "EntityID",
T.ENTITY_NAME as "EntityName",
T.USER_ID as "UserID",
T.STATUS as "Status",
T.REASON_CODE as "Reason",
T.CREATE_DATE as "CreateDate",
T.UPDATE_DATE as "UpdateDate",
T.LASTNOTE as "LastNote",
-- next line pulls in the first part of the LastNote up to the first
Carriage
-- Return.
replace(regexp_substr(T.LastNote, '.*$', 1, 1, 'm'),CHR(13),'') as
"FirstLine",
0 as "Selected"
from
(
-- all the columns from the Messages table.
select M.*,
-- get the last note from Message History.
( Select MH.NOTES
from HI_MESSAGE_HISTORY MH
where
MH.MESSAGE_ID = M.ID
-- next line finds the latest message history row with
-- a note, or null if there are no message history rows
-- with a note.
and MH.ID = (
-- next line finds the last Message History record for this
message
-- that has a non-null note.
select max(id)
from HI_MESSAGE_HISTORY HMH
where HMH.NOTES is not null
and HMH.MESSAGE_ID = M.ID)
) LastNote
FROM HI_MESSAGES M
WHERE M.Status in ('failed', 'under review')
) T
and.
public int ID { get; set; }
public string EntityType { get; set; }
public string EntityID { get; set; }
public string EntityName { get; set; }
public string UserID { get; set; }
public string Status { get; set; }
public string Reason { get; set; }
public DateTime? CreateDate { get; set; }
public DateTime? UpdateDate { get; set; }
public string LastNote { get; set; }
public string FirstLine { get; set; }
public bool Selected { get; set; }
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.
