RSS Feed

Plugin Developer Discussion

Hi,

I'm working on constructing a vaguely complex query on one of the built in queries (CBugEventQuery, specifically) and am running into a problem using the SQL LIKE operator.

When I add any clauses whose operation is LIKE to the WHERE, I get an exception when executing the query with the error:
"Invalid syntax: expected boolean expression, found 'LIKE'"

It looks like the API is doing some preprocessing on the WHERE string and doesn't recognize LIKE as a valid operation. Is using arbitrary SQL in database queries not supported? Is there documentation which explains what these restrictions are? I can do the filtering outside of the sql query, but it's substantially slower to do so.

Thanks,
-Clayton

As a security measure, and because we support three database backends, we parse the SQL and ensure it only uses approved functions and syntax.  The list of allowed functions is here:

https://developers.fogbugz.com/default.asp?W145

Unfortunately we don't support LIKE right now because the syntax differs between backends and we don't have a way to allow plugin developers to use different syntax based on the DB backend.