search

rappen / FetchXMLBuilder

FetchXML Builder for XrmToolBox and Microsoft Dynamics 365 / CRM
https://fetchxmlbuilder.com/
GNU General Public License v3.0
133 stars 55 forks source link

Convert to SQL doesn't work with IN Clause #1001

Closed Davey1971 closed 8 months ago

Davey1971 commented 8 months ago

When trying to convert a FetchXML query to SQL, it fails when there is a operator "IN"

Example

G999DBBB-6d9b-ed11-BBB9-0022486GG415

Error message when trying to convert to SQL Query

Failed to generate SQL Query.

Unsupported SQL condition operator 'in'

Davey1971 commented 8 months ago

Sorry, I forgot to include the Example in Code brackets

`

G999DBBB-6d9b-ed11-BBB9-0022486GG415

`

MarkMpn commented 8 months ago

If you have SQL 4 CDS installed, tick the "Use SQL 4 CDS for SQL conversion" option under Options > Settings > Behavior and it should handle this conversion.

Davey1971 commented 8 months ago

Thanks that worked

rappen commented 8 months ago

Thanks @MarkMpn. I'm closing this now. Reopen if needed!