[Bug]: I can't select with condition "IN" in MSSQL

[dumy]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

when I make the selection, it does not display the data. When I take the string in management studio work this query
SELECT * FROM Users WHERE Id in ('8E965D1A-8EB8-43CA-B2C6-5E81946B4BC8', '14CC7614-FFFC-4DC0-9669-57E84BCBC522', 'CB32D41B-3FCC-4DD6-B546-B2477AC001C3', 'A5DCFAFD-3C 69-4CD8 -9840-E4C3D86D03F1', '8E3D5C2D-F5EB-4C54-88CE-64C98EBBB6D2', '4C7AF14B-83E5-4B72-B5C4-0C50743F6AF8', '3F534757-713E-4907-B09B-345D0 B4ED8DA');

Expected Behavior

7 rows from the table should be displayed

Steps to reproduce

1. Add SQL Server
2. Write Query SELECT col1 FROM Users WHERE Id in ('8E965D1A', 'A5DCFAFD')
3. and run

Environment

No response

Additional Information

No response

[falnyr]

Can you provide additional details? E.g. version of MSSQL and schema for the table you're selecting from?

Also, have you tried using a different connection? E.g. similar query from a different table?

[dumy]

if is number I don't have a problem but it's is iterate from srting then don't return nothing. In all tables in all version of SQL Server

[dumy]

in MySQL is simple and work

[MichalisDBA]

@dumy If you profile the query while it runs you can see that the query is executed as stored procedure and adds additional quotes ''.

Your query works. To make it work with lowcoder, go to the Data Sources for your MSSQL data source, check the Enable toggling prepared statements for queries then go to your query -> advanced tab and check Disable prepared statements

[dumy]

it's is one value it's work

if is two value don't show any from table.

• it was disabled for me

[MichalisDBA]

Please check again to make sure prepared statements are disabled. For me with your example works perfectly

[dumy]

Thx @MichalisDBA, problem solved, I'm so happy