Unanswered

SQL - Get Rows V2 - Why does my filter query not work

(0) Share

Report

Posted on by dukatz

161

I'm trying to do a simple filter query on my rows where all rows get returned where 'key' starts with generic. So in SQL I would use key LIKE 'generic%' But I get an error. Is there a documentation about which syntax is supported by the connector?

Categories:

Business Process Flows

All responses (2)

Answers (0)

Suggested answer

MichaelFP 1,063 on at

Like (0)

Report

SQL - Get Rows V2 - Why does my filter query not work

SQL connector doesn't use T-SQL for sintax. it use ODATA for queries. If you want to still using T-SQL, i would recommend that you use store procedure and send the data as parameter to be user in the way that you like.
Suggested answer

dukatz 161 on at

Like (0)

Report

SQL - Get Rows V2 - Why does my filter query not work

So the Problem is, the Connector doesn't use SQl queries but ODATA queries Query options overview - OData | Microsoft Learn.

In my case startswith(key,'generic') was the solution.