Execute Query: Incorrect syntax near keyword 'In'. when executing query in UiPath

Help Studio
, ,
1

“select groupname,username,userID,firstname,lastname,email,supervisornamefull,supervisorEmail,‘Member’ accesslevel,GroupDomain from DataStores.dbo.Activity_Groups” +
"Where GroupName In " + ABCGroupName + " And ABCId In " + ABCIds + " And GroupDomain Not In " + ABCGroupDomain

Above is the query that I am trying to execute but getting below syntax error.

Execute Query: Incorrect syntax near keyword ‘In’.

Thanks in advance for help.

2

can you add a space after dbo.Activity_Groups
so it will become
"....m DataStores.dbo.Activity_Groups "

3

Thanks @jack.chan. It worked.

1 Like
4

no problem, please mark my answer as solution. Thanks

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.