Legacy Dev Forum Posts

 View Only

Sign Up

Filter by "value *contains* substring" in Purecloud Platform API query?

  • 1.  Filter by "value *contains* substring" in Purecloud Platform API query?

    Posted 06-05-2025 18:16

    scottl | 2019-10-30 15:34:04 UTC | #1

    Me and colleague have been hunting around for this to no avail.

    We are using very basic Platform API call under /api/v2/analytics/conversations/details/jobs for conversation detail query,

    { "interval": "2019-10-18T00:00:00.000Z/2019-10-19T00:00:00.000Z", "segmentFilters": [ { "type": "or", "predicates": [ { "dimension": "subject", "value": "Joe" } ] } ] }

    This searches for conversations on 10/18/19 where the subject field is exactly "Joe", i.e. emails with subject title "Joe". So far so good.

    What we would very much like is a way to query for conversations where the subject field contains a substring such as "Joe". In many programming languages this is usually represented as wildcard symbol * in the string or a like() function or contains() function, but none of these appear to work for Purecloud Platform API queries. Is there a method for this in Purecloud Platform API? Any help would be appreciated.


    tim.smith | 2019-10-30 15:41:22 UTC | #2

    Analytics query predicates only support the operators matches, exists, and notExists; they do not support a contains or partial match operator. You can request new features at https://purecloud.ideas.aha.io/ideas.


    scottl | 2019-10-30 16:22:33 UTC | #3

    Ok, thanks. Done.


    system | 2019-11-30 16:22:33 UTC | #4

    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: 6374