Combine Date Filters

[lepatrick]

Hi @luxzg,

thanks for your great work, which is normally the job of 3CX... I try to simplify your scripts to a simple bash script with curl. But I am unable to combine date filters, e.g. year AND month.

$filter=year(SegmentStartTime) eq 2025 --> is working
$filter=year(SegmentStartTime) eq 2025 and month(SegmentStartTime) eq 7 --> not working

For a survey script I need all calls since last run of the script to specific Queue and answered by an agent.

For me it's not possible to get only the newest, I always get the oldest and sorting filters will be ignored. Because very long call history it's no option to always load all logs and filter locally.

Thanks for your help and ideas.

[luxzg]

Hey, my mind is wandering elsewhere these days... But those date/time fuelds were very finicky. Are you sure you're using filters correctly and exactly as in samples? I really can't vouch for anything else, as there are several things that look like they SHOULD (logically) work, but 3CX XAPI will still spit out errors if you try them.

Eg, from that older standalone script:

https://github.com/luxzg/3CX-XAPI_examples/blob/main/old-standalone_scripts/fetch_call_history2.ps1

$FullURI = "$url/xapi/v1/CallHistoryView?`$orderby=SegmentStartTime asc&`$top=$top&`$filter=date(SegmentStartTime) ge $from and date(SegmentStartTime) le $to&`$count=true"

Here you can see me using date (instead of year /month rhat you used).

From and to are strings eg:

[string]$from = "2025-02-01",
[string]$to = "2025-02-28",

So why not try with date, and ge 2025-07-01 .. le 2025-07-31 ? You'll still get just that one month, plus, if you'll ever need just a week, you're already all set for some query like from 2025-07-01 till 2025-07-05

Hope that helps!