The first two systems I worked with using InterSystems technology were a PDP-11 running M11+ and a VAX 11/750 running M/VX. Too many years ago to count! 😊
Since then I've used most, if not all, InterSystems products up to IRIS and HealShare today.
I'm italian living in Switzerland and I work as Senior Consultant at GAIVOTA consultin SA, we provide professional services for InterSystems and other technologies.
Curiosity: apart from DC, I don't have ANY social account! 😁
select count(*) from (
select SessionId
from Ens.MessageHeader
where TimeCreated between '2025-02-01 00:00:00' and '2025-02-28 23:59:59'
group by SessionId
)
Ciao Riccardo,
<PROTECT> error, evidently the caller or the web application does not have enough permission.
Is the caller being authenticated? How? What user? What roles has the user?
Check the associated Web Application authentication and the user used by the caller to connect to your (FHIR) Web Application.
Well...if fact, a better query would be:
select count(DISTINCT SessionId)
from Ens.MessageHeader
where TimeCreated between '2025-02-01 00:00:00' and '2025-02-28 23:59:59'
Note: while the query is different, it ends running pretty much the same code as the previous query, but I like this better 😊