Legacy Dev Forum Posts

 View Only

Sign Up

Query for user details data not match

  • 1.  Query for user details data not match

    Posted 06-05-2025 18:03

    yuezhong | 2022-02-24 11:54:07 UTC | #1

    POST (option1) /api/v2/analytics/users/details/query vs (option2) /api/v2/analytics/users/details/jobs /api/v2/analytics/users/details/jobs/{jobId}

    Using same date time range, loop to get all result, but results data are not same.

    Some user's primaryPresence or routingStatus array count in option2 always 1 extra greater than data obtained with option1. They are not consistent.

    Example. Routing Status. Option 1 Data

    { "startTime": "2022-02-16T22:54:24.012Z", "endTime": "2022-02-16T22:54:28.699Z", "routingStatus": "OFFQUEUE" }, { "startTime": "2022-02-16T22:54:28.699Z", "endTime": "2022-02-16T22:55:41.469Z", "routingStatus": "COMMUNICATING" }, { "startTime": "2022-02-16T22:55:41.469Z", "endTime": "2022-02-17T00:21:32.901Z", "routingStatus": "OFFQUEUE" }, { "startTime": "2022-02-17T00:21:32.901Z", "endTime": "2022-02-17T00:21:33.784Z", "routingStatus": "IDLE" }, { "startTime": "2022-02-17T00:21:33.784Z", "endTime": "2022-02-17T00:21:33.785Z", "routingStatus": "INTERACTING" }, { "startTime": "2022-02-17T00:21:33.785Z", "endTime": "2022-02-17T00:39:25.081Z", "routingStatus": "INTERACTING" },

    Option 2 Data

    { "startTime": "2022-02-16T22:54:24.012Z", "endTime": "2022-02-16T22:54:28.699Z", "routingStatus": "OFFQUEUE" }, { "startTime": "2022-02-16T22:54:28.699Z", "endTime": "2022-02-16T22:55:41.469Z", "routingStatus": "COMMUNICATING" }, { "startTime": "2022-02-16T22:55:41.469Z", "endTime": "2022-02-17T00:21:32.901Z", "routingStatus": "OFFQUEUE" },

    > { > "startTime": "2022-02-16T22:55:41.469Z", > "routingStatus": "OFF_QUEUE" > },

    { "startTime": "2022-02-17T00:21:32.901Z", "endTime": "2022-02-17T00:21:33.784Z", "routingStatus": "IDLE" }, { "startTime": "2022-02-17T00:21:33.784Z", "endTime": "2022-02-17T00:21:33.785Z", "routingStatus": "INTERACTING" }, { "startTime": "2022-02-17T00:21:33.785Z", "endTime": "2022-02-17T00:39:25.081Z", "routingStatus": "INTERACTING" },

    Another Example, (primaryPresence) Option 1

    { "startTime": "2022-02-16T22:01:50.720Z", "endTime": "2022-02-16T23:51:49.715Z", "systemPresence": "ONQUEUE", "organizationPresenceId": "e08eaf1b-ee47-4fa9-a231-1200e284798f" }, { "startTime": "2022-02-16T23:51:49.715Z", "endTime": "2022-02-17T00:08:58.761Z", "systemPresence": "BREAK", "organizationPresenceId": "227b37e2-f1d0-4dd0-8f50-badd7cf6d158" }, { "startTime": "2022-02-17T00:08:58.761Z", "endTime": "2022-02-17T00:43:13.297Z", "systemPresence": "ONQUEUE", "organizationPresenceId": "e08eaf1b-ee47-4fa9-a231-1200e284798f" }, { "startTime": "2022-02-17T00:43:13.297Z", "endTime": "2022-02-17T00:49:31.563Z", "systemPresence": "AWAY", "organizationPresenceId": "fe981c38-f120-4aeb-8c29-348323cbe51f" },

    Option 2

    { "startTime": "2022-02-16T22:01:50.720Z", "endTime": "2022-02-16T23:51:49.715Z", "systemPresence": "ON_QUEUE", "organizationPresenceId": "e08eaf1b-ee47-4fa9-a231-1200e284798f" }, { "startTime": "2022-02-16T23:51:49.715Z", "endTime": "2022-02-17T00:08:58.761Z", "systemPresence": "BREAK", "organizationPresenceId": "227b37e2-f1d0-4dd0-8f50-badd7cf6d158" }, {

    > "startTime": "2022-02-16T23:51:49.715Z", > "systemPresence": "BREAK", > "organizationPresenceId": "227b37e2-f1d0-4dd0-8f50-badd7cf6d158"

    }, { "startTime": "2022-02-17T00:08:58.761Z", "endTime": "2022-02-17T00:43:13.297Z", "systemPresence": "ON_QUEUE", "organizationPresenceId": "e08eaf1b-ee47-4fa9-a231-1200e284798f" }, { "startTime": "2022-02-17T00:43:13.297Z", "endTime": "2022-02-17T00:49:31.563Z", "systemPresence": "AWAY", "organizationPresenceId": "fe981c38-f120-4aeb-8c29-348323cbe51f" },

    Hope someone can explain ?

    I have a requirement to build a report of the day of the total user online or offline in 30 minutes interval, i'm trying to get all the data and filter and count.


    system | 2022-03-27 11:54:43 UTC | #2

    This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.


    This post was migrated from the old Developer Forum.

    ref: 13689