How to write a GraphQL request with date between
# supportc
codey1416
09/26/2023, 6:21 PMIt was suggested I try this approach
{
DiagnosticReportList(subject: "${patientRef}", date_gt: "${formatISO(date)}", date_lt: "${formatISO(addDays(date, 1))}") {
...
}
}
But that is not working. I get the following errors:
[
{
"severity": "error",
"code": "invalid",
"details": {
"text": "Unknown argument \"date_gt\" on field \"QueryType.DiagnosticReportConnection\". Did you mean \"date\"?"
}
},
{
"severity": "error",
"code": "invalid",
"details": {
"text": "Unknown argument \"date_lt\" on field \"QueryType.DiagnosticReportConnection\". Did you mean \"date\"?"
}
}
]
codey1416
09/26/2023, 6:22 PMI've also tried
reports: DiagnosticReportConnection(
subject: "${patientRef}",
date: "gt${formatISO(date)}<${formatISO(addDays(date, 1)}"
) {...}
without success
r
reshma
09/26/2023, 10:32 PMStill working on "between" but just testing this gt and it works
{
DiagnosticReportConnection(
issued: "gt2022-02-01"
_count: 100
) {
count
edges {
resource {
id
issued
category {
coding {
code
}
}
code {
coding {
code
}
}
specimen {
resource {
... on Specimen {
collection {
collectedDateTime
}
receivedTime
}
}
}
subject {
resource {
... on Patient {
id
gender
address {
state
}
}
}
}
}
}
}
}
c
codey1416
09/27/2023, 9:31 PM@reshma Yes - I can get it to work with just one also - I need both though
r
reshma
09/27/2023, 9:38 PMOk - just tested this
{
DiagnosticReportConnection(
_filter:"issued gt \"2022-01-01\" and issued lt \"2024-02-01\""
_count: 100
) {
count
edges {
resource {
id
issued
category {
coding {
code
}
}
code {
coding {
code
}
}
specimen {
resource {
... on Specimen {
collection {
collectedDateTime
}
receivedTime
}
}
}
subject {
resource {
... on Patient {
id
gender
address {
state
}
}
}
}
}
}
}
}
c
codey1416
09/28/2023, 2:59 PM@reshma you are amazing! Thank you!
codey1416
09/30/2023, 1:34 AM@reshma I keep getting "Unknown argument _filter on field QueryType.AppointmentConnection." when I try and use _filter
codey1416
09/30/2023, 1:34 AMAny advice?
r
reshma
09/30/2023, 2:54 AMCan you send the permalink of the Graphiql like above? That will help me find out what's going on
c
codey1416
09/30/2023, 3:49 AMI'm using a self hosted version
codey1416
09/30/2023, 4:08 AMBut even if I run your code from yesterday I'm now getting the same error
codey1416
09/30/2023, 4:08 AM[
{
"severity": "error",
"code": "invalid",
"details": {
"text": "Unknown argument \"_filter\" on field \"QueryType.DiagnosticReportConnection\"."
}
}
]
codey1416
09/30/2023, 4:10 AMEven this simple one gives me the same error about _filter
c
cody
10/01/2023, 4:59 PMHi @codey1416 - I just verified that the "_filter" does work with "DiagnosticReportConnection":
Copy code
{
DiagnosticReportConnection(_filter: "issued gt '2023-11-01'") {
count offset pageSize
edges {
resource {
resourceType
id
}
}
}
}_filter156 Views