Bullhorn | CEQL - Documentation Update

[rsbarbo]

Description

Under Bullhorn CEQL Documentation, we are showing the expressions currently handled by the endpoint, however, "LIKE" is not one of them.

Where expressions
The expression or expressions specifying what to search and what objects to return in our result set
This is made up of a left­hand­side (LHS), an operator and a right­hand­side (RHS).
The valid CEQL operators are:
“AND”
“OR”
“=”
“!=”
“<” “>”
“<=” “>=”
“LIKE”
“IN”
“IS NULL”

After reading the documentation, we have noticed that Bullhorn doesn't support "LIKE" in a conventional way, however, it does support in a slightly different way. Please see example below:

Scenario

Customer wants to use "wildcards" within their CEQL queries, in the case of Bullhorn it would be possible to do it, however, it be approached slightly different within the WHERE clause:

In the WHERE clause you can make use of the "wildcard", by using the following syntax <column_name> = '%<VALUE>%'.

https://console.cloud-elements.com/elements/api-v2/hubs/crm/candidates?where=phone%20%3D%20'%256172456310%25'

[daniel-cherry]

@claytonshaver The cloud elements query language appears to be a generic section that is currently applied to all elements. There are a few stories around the proposed CEQL user guide that this can probably be added to as additional tips. I can add this request to one of those stories and close as a dup. Let me know if you agree