go to post Claudia Cortes Villa · May 8 Yes, a message is being sent from a production and it is an HL7 message.The message was not modified before it was forwarded.in the traceability of the messages they are sent and passed correctly, but when the user tries to resend one the error described above occurs
go to post Claudia Cortes Villa · Apr 11 Hello, thank you very much for the help, I managed to get what I expected
go to post Claudia Cortes Villa · Apr 5 Yes, in the healthshare environment I am running the following script: SELECT id, substr(TimeCreated, 12, 5) as HORA, (DATEDIFF(ms, TimeCreated, TimeProcessed)) as TiempoTranscurrido , TimeCreated as fecha, GETDATE() as hora_actualFROM ens.messageheader WHERE SourceConfigName = 'HL7Filler HCIS' AND TimeCreated >= '2024-03-19 12:51:11.125' I would like that in exchange for entering the exact time I could obtain it in the format, I have tried with the following script but it brings me the messages for that exact time and I need to bring all the logs in that time period "2 hours" SELECT id, substr(TimeCreated, 12, 5) as HORA, (DATEDIFF(ms, TimeCreated, TimeProcessed)) as TiempoTranscurrido , TimeCreated as fecha, GETDATE() as hora_actualFROM ens.messageheader WHERE SourceConfigName = 'HL7Filler HCIS' AND TimeCreated >= DATEADD(hour, -2, GETDATE())