New post

查找

Question
· Jan 20

What is the way to see the latest executed SQL query?

Hi folks!

Is there any way to know the text of the SQL queries executed against the IRIS server?

My case: I have an SQL class query with a few parameters and and some combination of values causes unexpected results.

It'd be great if I could just copy the query from some log of queries done vs my IRIS the server. Cannot find it easily, though. Any advice?

13 new Comments
Discussion (13)3
Log in or sign up to continue
Question
· Jan 20

Challenges Facing Home-Based Care in Modern Healthcare

Home-based care has become a vital part of modern healthcare systems. As aging populations grow and healthcare costs rise, more individuals prefer receiving care in the comfort of their own homes rather than in hospitals or long-term care facilities. Home-based care supports independence, improves patient satisfaction, and reduces strain on institutional healthcare settings.

Despite its many advantages, home-based care faces several challenges that must be addressed to ensure quality, sustainability, and accessibility. Understanding these challenges is essential for healthcare providers, caregivers, policymakers, and support foundations working to strengthen home-based care services.

Workforce Shortages and Caregiver Burnout

One of the most significant challenges in home-based care is the shortage of qualified caregivers. The demand for home care aides continues to rise, yet recruitment and retention remain difficult.

Caregivers often face long hours, emotional stress, and physically demanding tasks. Without adequate support, training, and fair compensation, burnout becomes common. High turnover disrupts continuity of care and negatively affects patient outcomes.

Addressing workforce shortages requires investment in caregiver education, mental health support, and career development opportunities.

Limited Access to Training and Certification

Quality home-based care depends on skilled and knowledgeable caregivers. However, many caregivers lack access to affordable training programs and certification pathways.

Without proper education, caregivers may struggle to manage chronic conditions, mobility issues, or cognitive decline effectively. This gap in training can compromise care quality and patient safety.

Expanding education funding, certification programs, and caregiver scholarships is essential to strengthen the home-based care workforce.

Financial Barriers and Funding Gaps

Home-based care can be cost-effective in the long term, but financial barriers still limit access for many families. Insurance coverage, reimbursement policies, and out-of-pocket costs vary widely.

Caregivers may also face financial strain due to low wages, unpaid caregiving responsibilities, or lack of benefits. These financial challenges affect both caregivers and care recipients.

Sustainable funding models and financial assistance programs are needed to ensure equitable access to home-based care.

Coordination and Communication Challenges

Home-based care often involves multiple stakeholders, including caregivers, healthcare providers, family members, and social service organizations. Poor coordination and communication can lead to fragmented care.

Without clear care plans and information sharing, patients may experience gaps in treatment, medication errors, or inconsistent support.

Improving care coordination through digital tools, standardized protocols, and collaborative care models can enhance efficiency and outcomes.

Technology and Digital Divide

Technology plays an increasing role in home-based care, from remote monitoring to telehealth services. However, not all patients or caregivers have access to or familiarity with digital tools.

Older adults may struggle with technology use, while caregivers may lack training in digital health systems. Limited internet access in some regions further widens the gap.

Bridging the digital divide requires user-friendly solutions, training programs, and infrastructure investment.

Emotional and Social Isolation

While home-based care allows individuals to remain in familiar environments, it can also lead to social isolation. Reduced social interaction affects both patients and caregivers.

Caregivers working alone may feel disconnected from peers, while older adults may experience loneliness without regular engagement.

Caregiver communities, peer support networks, and community-based programs play a crucial role in addressing emotional well-being.


Regulatory and Policy Challenges

Home-based care operates within complex regulatory frameworks that vary by region. Inconsistent policies, licensing requirements, and reimbursement rules can create barriers for providers and caregivers.

Clear, supportive policies are needed to promote quality standards, protect caregivers, and expand access to home-based care services.

The Path Forward for Home-Based Care

Overcoming these challenges requires collaboration across healthcare systems, nonprofit organizations, and policymakers. Investing in caregiver education, mental health support, fair compensation, and community networks is critical.

By addressing workforce, financial, technological, and emotional challenges, home-based care can continue to grow as a sustainable and compassionate healthcare solution.

Frequently Asked Questions (FAQs)

1. Why is home-based care becoming more important in modern healthcare?
Home-based care supports aging populations, reduces hospital overcrowding, and allows individuals to receive care in familiar environments.

2. What are the biggest challenges facing home-based care today?
Workforce shortages, limited training, financial barriers, care coordination issues, and caregiver burnout are major challenges.

3. How does caregiver burnout affect home-based care quality?
Burnout leads to high turnover, reduced care consistency, and lower quality outcomes for patients.

4. Can technology improve home-based care?
Yes, but only if caregivers and patients have access, training, and user-friendly digital tools.

5. How can organizations support sustainable home-based care?
By investing in caregiver education, mental health support, fair wages, and strong community support networks.

Discussion (0)1
Log in or sign up to continue
Article
· Jan 20 4m read

Usando o Postman para testar o OAuth2.0 do repositório InterSystems FHIR - Parte 1

Olá a todos, sou eu novamente para compartilhar o que ando estudando recentemente.😓

 

Recentemente, estou estudando como configurar a autenticação OAuth2 para o repositório InterSystems FHIR. E descobri que os seguintes artigos são muito bons e fáceis de seguir.😁

SMART on FHIR EHR Launch com IRIS for Health

Construindo um Repositório FHIR + Configuração de Servidor de Autorização OAuth2/Servidor de Recursos no IRIS for Health Parte 2

 

Para mim, como um usuário que não possui muito conhecimento sobre OAuth2.0, acho bastante difícil entender como configurar todo o ambiente OAuth2.0 antes de saber como ele se parece (o que é? quais são os parâmetros que preciso? qual é o resultado esperado?) de um ponto de vista puramente de usuário. 🤔 Aqui, tento inverter um pouco a sequência: vamos tentar falar sobre OAuth2.0 primeiro pelo lado do cliente. E, aqui, usaremos o Postman como cliente.😁

Se você quiser ter um ambiente de teste para OAuth, pode tentar os seguintes dockers:

workshop-iris-oauth2 ou o docker neste artigo Construindo um Repositório FHIR + Configuração de Servidor de Autorização OAuth2/Servidor de Recursos no IRIS for Health Parte 1

Neste artigo, configurei um repositório InterSystems FHIR com suporte a HTTPS em minha máquina local. (Baseado na minha observação, corrija-me se eu estiver errado, para fazer o OAuth da InterSystems funcionar, o servidor de recursos deve suportar HTTPS😑😐)

 


Então, vamos começar por algo simples. 😀

Caso 1: Autenticação Básica 

 As informações que precisamos são:

URL {hostname}/{path}/{Resources}?{parameters}
Body (opcional)
Username  
Password  

 

Embora testar no Postman seja simples, a aparência é a seguinte:

Em geral, a autenticação básica é simples, porque tudo o que você precisa é da URL dos recursos que deseja obter e fornecer a credencial correspondente. 1 passo e você obtém os dados que deseja.😁✌

 


Caso 2: Autenticação OAuth 

O conceito é um pouco diferente da autenticação básica. Pelo meu entendimento, a diferença chave é o conceito de sessão e token. Talvez, antes de mergulharmos de fato no OAuth2.0, vamos falar sobre algo com o qual estamos familiarizados.

Considere o seguinte cenário: você deseja visitar um Museu de Arte para um evento especial chamado "O Momento Milagroso". Como este evento é muito popular, o Museu decidiu configurar um controle de fluxo, dividindo o horário de abertura em 8 sessões, cada sessão com duração de 1 hora, e o visitante deve reservar sua própria sessão na Bilheteria antes da visita. Em outras palavras, o visitante deve apresentar um bilhete válido (token) no horário correto (sessão) ao Museu de Arte para o evento "O Momento Milagroso".

 

A partir do cenário acima, podemos resumir o seguinte: do ponto de vista de um cliente OAuth2.0, para acessar os recursos que queremos, precisamos:

Passo 1: obter um token do Servidor de Autenticação (Comprar um bilhete na Bilheteria)

Passo 2: apresentar o token ao Servidor de Recursos (Apresentar o bilhete no Museu de Arte)

Para obter o token, você precisa informar ao Servidor de Autenticação:

1. Quem é você? (uma das formas mais simples é fornecer o client_id e o client_secret; claro que existem outras formas, mas quero manter a simplicidade aqui😁)

2. Qual é o Servidor de Recursos que você deseja acessar? (Qual museu? Qual local?), você pode fornecer isso no parâmetro audience.

3. Qual é o escopo (scope) do seu acesso? (Qual programa? Qual evento?), você pode fornecer isso no Scope, e este escopo deve ser definido entre o Servidor de Autenticação e o Servidor de Recursos.

 

Então... agora ... é hora de agir como um cliente

com as informações abaixo, e obter o token pelo Postman:

Auth Type OAuth2.0
Grant type Client Credentials
Access Token URL

https://{authentication server hostname}/oauth2/token?aud={resource server hostname}/path

Por exemplo,

https://authenticationserver.com/oauth2/token?aud=https://resourceserver...

Scope user/.read user/.write
Client Authentication Enviar como cabeçalho Basic Auth 

Após a conclusão da autenticação, clique em "use token"

 

Uhuuu!! agora temos um token válido aqui,😁😂 e ele expirará dentro de uma hora 😶🤐

 

Agora use o token para obter o recurso que desejamos

 

Agora tente obter o Recurso Patient (Paciente)

URL {resource server hostname}/{path}/Patient
Method GET
Token aquele que obtivemos no Passo 1

 

 

 

Uhuuu!! parece bom.😁

Obrigado pela leitura.

Discussion (0)1
Log in or sign up to continue
Announcement
· Jan 20

InterSystems Open Exchange Annual Recap 2025

Hello and welcome to InterSystems Open Exchange Annual Recap 2025.
General Stats:
174 new apps in 2025
6,717 downloads in 2025
1,101 applications all time
44,992 downloads all time
3,484 developers joined

Top applications of the year
This rating includes only applications that have been published this year. The popularity of applications depends on various metrics such as views, bookmarks, ZPM installation rate, releases, reviews, and clicks on the Download button on the app page.
Top applications of all time
This rating includes applications that have been published since Open Exchange went online. The popularity of applications depends on various metrics such as views, bookmarks, ZPM installation rate, releases, reviews, and clicks on the Download button on the app page.
Top developers of all time
 

A developer's rating is affected by factors such as publishing apps, entering contests, writing reviews, and releasing updates.

If you want to see the top developers based just on the number of apps they've published, you can find them here.
2025 at a GlanceInterSystems Open Exchange
Discussion (0)1
Log in or sign up to continue
Digest
· Jan 20

InterSystems Open Exchange Annual Newsletter 2025

Hello and welcome to the InterSystems Open Exchange Annual Newsletter 2025.
General Stats:
174 new apps in 2025
6,717 downloads in 2025
1,101 applications all time
44,992 downloads all time
3,484 developers joined

Top applications of the year
This rating includes only applications that have been published this year. The popularity of applications depends on various metrics such as views, bookmarks, ZPM installation rate, releases, reviews, and clicks on the Download button on the app page.
Top applications of all time
This rating includes applications that have been published since Open Exchange went online. The popularity of applications depends on various metrics such as views, bookmarks, ZPM installation rate, releases, reviews, and clicks on the Download button on the app page.
Top developers of all time
 

A developer's rating is affected by factors such as publishing apps, entering contests, writing reviews, and releasing updates.

If you want to see the top developers based just on the number of apps they've published, you can find them here.
2025 at a GlanceInterSystems Open Exchange